pgsql-hackers - October 2014

The PostgreSQL developers team lives here. Discussion of current development issues, problems and bugs, and proposed new features. If your question cannot be answered by people in the other lists, and it is likely that only a developer will know the answer, you may re-post your question in this list. You must try elsewhere first!

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

Oct. 1, 2014

Thread Author Time
Re: CREATE IF NOT EXISTS INDEX Josh Berkus 00:12
crash from pfree and brin index Mark Wong 00:39
Re: CREATE IF NOT EXISTS INDEX 📎 Fabrízio de Royes Mello 01:03
Re: CREATE IF NOT EXISTS INDEX Michael Paquier 01:22
Re: CREATE IF NOT EXISTS INDEX Fabrízio de Royes Mello 01:30
Re: REINDEX CONCURRENTLY 2.0 📎 Michael Paquier 07:00
Re: pgcrypto: PGP armor headers 📎 Heikki Linnakangas 07:11
"Value locking" Wiki page Peter Geoghegan 08:44
Re: "Value locking" Wiki page Andres Freund 08:49
Re: pgcrypto: PGP armor headers Marko Tiikkaja 08:58
Re: "Value locking" Wiki page Heikki Linnakangas 09:44
Re: "Value locking" Wiki page Andres Freund 10:10
Re: libpq-dev: pg_config_manual.h redefines CACHE_LINE_SIZE Andres Freund 10:24
Re: "Value locking" Wiki page Simon Riggs 10:50
Re: "Value locking" Wiki page Heikki Linnakangas 10:58
Re: test_shm_mq failing on anole (was: Sending out a request for more buildfarm animals?) Andres Freund 11:00
Re: pgcrypto: PGP armor headers 📎 Heikki Linnakangas 11:01
Re: "Value locking" Wiki page Simon Riggs 11:23
Re: INSERT ... ON CONFLICT {UPDATE | IGNORE} Andres Freund 11:30
Promise index tuples for UPSERT Simon Riggs 11:34
Re: pg_receivexlog and replication slots 📎 Andres Freund 11:38
Re: "Value locking" Wiki page Simon Riggs 11:42
Re: CREATE IF NOT EXISTS INDEX 📎 Fabrízio de Royes Mello 11:42
Re: pgcrypto: PGP armor headers 📎 Marko Tiikkaja 11:47
CINE in CREATE TABLE AS ... and CREATE MATERIALIZED VIEW ... Fabrízio de Royes Mello 12:17
Re: Allow format 0000-0000-0000 in postgresql MAC parser 📎 Herwin Weststrate 12:34
Re: "Value locking" Wiki page Heikki Linnakangas 12:43
Re: pg_receivexlog and replication slots Michael Paquier 12:54
Re: pg_receivexlog and replication slots Andres Freund 12:59
Re: pgcrypto: PGP armor headers Heikki Linnakangas 13:06
Re: "Value locking" Wiki page Simon Riggs 13:31
Re: "Value locking" Wiki page Simon Riggs 13:46
Re: "Value locking" Wiki page Heikki Linnakangas 13:49
Re: Time measurement format - more human readable Gregory Smith 13:58
Re: "Value locking" Wiki page Heikki Linnakangas 13:58
Re: pg_receivexlog and replication slots Alvaro Herrera 14:21
Re: open items for 9.4 Heikki Linnakangas 14:22
Re: pg_receivexlog and replication slots Andres Freund 14:22
Re: Full_page_write is off in backup mode Robert Haas 14:37
Re: test_shm_mq failing on anole (was: Sending out a request for more buildfarm animals?) Robert Haas 14:45
Re: test_shm_mq failing on anole (was: Sending out a request for more buildfarm animals?) Andres Freund 14:50
Re: test_shm_mq failing on anole (was: Sending out a request for more buildfarm animals?) Robert Haas 15:10
Re: Per table autovacuum vacuum cost limit behaviour strange Robert Haas 15:16
Re: autovacuum scheduling starvation and frenzy Robert Haas 15:31
Re: [v9.5] Custom Plan API Merlin Moncure 15:41
Re: autovacuum scheduling starvation and frenzy Alvaro Herrera 15:44
Re: pg_receivexlog and replication slots Andres Freund 15:44
Dynamic LWLock tracing via pg_stat_lwlock (proof of concept) 📎 Ilya Kosmodemiansky 16:19
NEXT VALUE FOR <sequence> 📎 Thomas Munro 16:28
Re: pg_receivexlog and replication slots Jan Wieck 17:17
Re: pg_receivexlog and replication slots Andres Freund 17:19
Re: pg_receivexlog and replication slots Jan Wieck 17:22
Re: pg_receivexlog and replication slots Andres Freund 17:32
Re: pg_receivexlog and replication slots Jan Wieck 17:36
Re: Scaling shared buffer eviction Andres Freund 18:54
Re: Yet another abort-early plan disaster on 9.3 Josh Berkus 18:56
Re: "Value locking" Wiki page Peter Geoghegan 19:03
Re: Scaling shared buffer eviction Andres Freund 19:04
Re: "Value locking" Wiki page Peter Geoghegan 19:06
Re: autovacuum scheduling starvation and frenzy Robert Haas 19:09
Re: Promise index tuples for UPSERT Heikki Linnakangas 19:54
Re: Promise index tuples for UPSERT Peter Geoghegan 19:58
Re: Promise index tuples for UPSERT Peter Geoghegan 19:59
Re: pg_background (and more parallelism infrastructure patches) Stephen Frost 20:56
Re: [v9.5] Custom Plan API Kohei KaiGai 21:08
Re: Time measurement format - more human readable Bogdan Pilch 21:18
Re: superuser() shortcuts 📎 Brightwell, Adam 22:37
Re: "Value locking" Wiki page Ants Aasma 23:42
UPSERT wiki page, and SQL MERGE syntax Peter Geoghegan 23:52

Oct. 2, 2014

Thread Author Time
Re: bad estimation together with large work_mem generates terrible slow hash joins Kevin Grittner 00:20
Re: superuser() shortcuts Stephen Frost 00:42
Re: Dynamic LWLock tracing via pg_stat_lwlock (proof of concept) Craig Ringer 03:25
Re: "Value locking" Wiki page Craig Ringer 03:53
Re: UPSERT wiki page, and SQL MERGE syntax Craig Ringer 04:44
Re: Escaping from blocked send() reprised. Kyotaro HORIGUCHI 06:36
Typo fixes in src/backend/rewrite/rewriteHandler.c 📎 Etsuro Fujita 06:55
Re: UPSERT wiki page, and SQL MERGE syntax Heikki Linnakangas 07:07
Re: bad estimation together with large work_mem generates terrible slow hash joins Heikki Linnakangas 07:11
Re: bad estimation together with large work_mem generates terrible slow hash joins Tomas Vondra 07:50
Re: UPSERT wiki page, and SQL MERGE syntax Peter Geoghegan 07:54
Re: Yet another abort-early plan disaster on 9.3 Simon Riggs 08:19
Re: Escaping from blocked send() reprised. Kyotaro HORIGUCHI 08:47
Re: Replication identifiers, take 3 Heikki Linnakangas 08:49
Re: Escaping from blocked send() reprised. Andres Freund 09:02
Re: Yet another abort-early plan disaster on 9.3 Peter Geoghegan 09:30
Re: Replication identifiers, take 3 Andres Freund 09:30
Re: Dynamic LWLock tracing via pg_stat_lwlock (proof of concept) Andres Freund 09:50
Re: Escaping from blocked send() reprised. Kyotaro HORIGUCHI 10:11
Re: pgbench throttling latency limit 📎 Heikki Linnakangas 10:50
Re: Dynamic LWLock tracing via pg_stat_lwlock (proof of concept) Ilya Kosmodemiansky 11:07
Re: Dynamic LWLock tracing via pg_stat_lwlock (proof of concept) Ilya Kosmodemiansky 11:22
Re: NEXT VALUE FOR <sequence> Heikki Linnakangas 11:27
Re: pgcrypto: PGP signatures Heikki Linnakangas 11:47
proposal: doc: simplify examples of dynamic SQL Pavel Stehule 11:51
Re: pgcrypto: PGP signatures Marko Tiikkaja 12:12
Re: Dynamic LWLock tracing via pg_stat_lwlock (proof of concept) Stephen Frost 12:23
Re: Replication identifiers, take 3 Robert Haas 12:28
Re: Dynamic LWLock tracing via pg_stat_lwlock (proof of concept) Stephen Frost 12:28
Re: pg_background (and more parallelism infrastructure patches) Robert Haas 12:42
Re: pg_background (and more parallelism infrastructure patches) Stephen Frost 13:11
Log notice that checkpoint is to be written on shutdown 📎 Michael Banck 13:21
Re: NEXT VALUE FOR <sequence> Tom Lane 13:48
Re: Per table autovacuum vacuum cost limit behaviour strange 📎 Alvaro Herrera 13:54
Re: WITH CHECK and Column-Level Privileges Stephen Frost 13:58
Re: Yet another abort-early plan disaster on 9.3 Ryan Johnson 13:59
Re: Per table autovacuum vacuum cost limit behaviour strange Robert Haas 14:28
"port/atomics/arch-*.h" are missing from installation 📎 Kohei KaiGai 14:33
Re: Inefficient barriers on solaris with sun cc Andres Freund 14:34
Re: Scaling shared buffer eviction Andres Freund 14:36
Re: Scaling shared buffer eviction Robert Haas 14:40
Re: Scaling shared buffer eviction Andres Freund 14:44
Re: Inefficient barriers on solaris with sun cc Robert Haas 14:55
Re: Scaling shared buffer eviction Robert Haas 14:56
Re: "port/atomics/arch-*.h" are missing from installation Andres Freund 15:03
Re: Per table autovacuum vacuum cost limit behaviour strange Stephen Frost 15:03
Re: Log notice that checkpoint is to be written on shutdown David G Johnston 15:17
Re: Inefficient barriers on solaris with sun cc Andres Freund 15:18
Re: Scaling shared buffer eviction Andres Freund 15:20
Re: Inefficient barriers on solaris with sun cc Robert Haas 15:35
Re: Per table autovacuum vacuum cost limit behaviour strange Alvaro Herrera 15:37
Re: Log notice that checkpoint is to be written on shutdown 📎 Michael Banck 16:00
DDL Damage Assessment Dimitri Fontaine 16:30
Re: DDL Damage Assessment Fabrízio de Royes Mello 16:46
Re: DDL Damage Assessment Claudio Freire 16:49
Re: DDL Damage Assessment Harold Giménez 16:56
Re: Scaling shared buffer eviction Heikki Linnakangas 17:04
Re: Scaling shared buffer eviction Andres Freund 17:07
Re: DDL Damage Assessment Joe Conway 17:15
Re: Inefficient barriers on solaris with sun cc Andres Freund 18:06
Re: DDL Damage Assessment Joshua D. Drake 19:07
TAP test breakage on MacOS X Robert Haas 19:19
Re: Scaling shared buffer eviction Robert Haas 19:22
Re: Proper query implementation for Postgresql driver Robert Haas 19:30
Re: DDL Damage Assessment Stephen Frost 19:34
Re: DDL Damage Assessment Stephen Frost 19:37
Re: DDL Damage Assessment Stephen Frost 19:40
Re: NEXT VALUE FOR <sequence> Robert Haas 19:43
Re: DDL Damage Assessment Josh Berkus 19:43
Re: UPSERT wiki page, and SQL MERGE syntax Peter Geoghegan 19:46
Re: DDL Damage Assessment José Luis Tallón 19:48
Re: Yet another abort-early plan disaster on 9.3 Josh Berkus 19:56
Re: INSERT ... ON CONFLICT {UPDATE | IGNORE} Bruce Momjian 20:10
Re: DDL Damage Assessment Steven Lembark 20:19
Re: PL/pgSQL 2 Steven Lembark 20:24
Re: PL/pgSQL 2 Steven Lembark 20:31
Re: DDL Damage Assessment Claudio Freire 20:31
Re: DDL Damage Assessment Peter Geoghegan 20:37
Re: DDL Damage Assessment Peter Geoghegan 20:38
Re: DDL Damage Assessment Claudio Freire 20:52
Re: DDL Damage Assessment Peter Geoghegan 21:00
Re: DDL Damage Assessment Stephen Frost 21:03
Re: DDL Damage Assessment Claudio Freire 21:04
Re: DDL Damage Assessment Claudio Freire 21:08
Re: INSERT ... ON CONFLICT {UPDATE | IGNORE} Peter Geoghegan 21:08
Re: TAP test breakage on MacOS X Peter Eisentraut 21:09
Re: DDL Damage Assessment Peter Geoghegan 21:10
Re: TAP test breakage on MacOS X Andres Freund 21:11
Re: DDL Damage Assessment Stephen Frost 21:11
Re: DDL Damage Assessment Andres Freund 21:14
Re: DDL Damage Assessment Alvaro Herrera 21:15
Re: DDL Damage Assessment Andres Freund 21:16
Re: DDL Damage Assessment Alvaro Herrera 21:19
Re: DDL Damage Assessment Stephen Frost 21:19
Re: DDL Damage Assessment Stephen Frost 21:22
Re: INSERT ... ON CONFLICT {UPDATE | IGNORE} Bruce Momjian 21:37
Re: Assertion failure in syncrep.c Simon Riggs 21:37
[PATCH] Simplify EXISTS subqueries containing LIMIT 📎 Marti Raudsepp 21:41
Re: DDL Damage Assessment Claudio Freire 21:41
Re: Per table autovacuum vacuum cost limit behaviour strange Alvaro Herrera 21:59
Re: DDL Damage Assessment Dimitri Fontaine 22:26
Re: DDL Damage Assessment Jan Wieck 22:43
Re: Proposal for updating src/timezone Tom Lane 22:46
Re: NEXT VALUE FOR <sequence> 📎 Thomas Munro 23:01
Re: Promise index tuples for UPSERT Peter Geoghegan 23:05
Re: NEXT VALUE FOR <sequence> Thomas Munro 23:10
Re: CREATE IF NOT EXISTS INDEX Marti Raudsepp 23:15
Re: NEXT VALUE FOR <sequence> Tom Lane 23:18
Re: DDL Damage Assessment Joe Conway 23:38

Oct. 3, 2014

Thread Author Time
Fixed xloginsert_locks for 9.4 📎 Greg Smith 00:08
Re: DDL Damage Assessment Stephen Frost 00:26
Re: Fixed xloginsert_locks for 9.4 Peter Geoghegan 00:26
Re: Per table autovacuum vacuum cost limit behaviour strange Stephen Frost 00:35
Re: Patch to add support of "IF NOT EXISTS" to others "CREATE" statements Marti Raudsepp 00:38
Re: Yet another abort-early plan disaster on 9.3 Peter Geoghegan 00:54
Re: CREATE IF NOT EXISTS INDEX Marti Raudsepp 00:55
Re: TAP test breakage on MacOS X Robert Haas 01:18
Re: pg_receivexlog and replication slots 📎 Michael Paquier 01:30
GiST splitting on empty pages Andrew Gierth 02:03
Re: TAP test breakage on MacOS X Tom Lane 02:08
Re: Patch to add support of "IF NOT EXISTS" to others "CREATE" statements 📎 Fabrízio de Royes Mello 02:38
Re: DDL Damage Assessment Jim Nasby 03:07
Re: proposal: doc: simplify examples of dynamic SQL Jim Nasby 03:16
Re: TAP test breakage on MacOS X Tom Lane 03:17
Re: CREATE IF NOT EXISTS INDEX 📎 Fabrízio de Royes Mello 03:25
Re: CREATE IF NOT EXISTS INDEX Fabrízio de Royes Mello 03:29
Re: CREATE IF NOT EXISTS INDEX Fabrízio de Royes Mello 03:35
Re: proposal: doc: simplify examples of dynamic SQL David G Johnston 04:06
How to make ResourceOwnerForgetBuffer() O(1), instead of O(N^2) scale 📎 Kouhei Kaigai 04:08
Re: How to make ResourceOwnerForgetBuffer() O(1), instead of O(N^2) scale Tom Lane 04:25
Re: DDL Damage Assessment Claudio Freire 04:40

Browse Archives

Prev | Next