pgsql-hackers - February 2013

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

Feb. 1, 2013

Thread Author Time
Re: json api WIP patch Tom Lane 00:12
Re: json api WIP patch David E. Wheeler 00:16
Re: json api WIP patch Andrew Dunstan 00:26
Re: json api WIP patch Tom Lane 00:32
Re: json api WIP patch David E. Wheeler 00:38
Re: json api WIP patch Gavin Flower 00:41
Re: Cascading replication: should we detect/prevent cycles? Josh Berkus 01:01
Streaming-only cascading replica won't come up without writes on the master Josh Berkus 01:04
parameter info? Andrew Dunstan 01:05
Re: Cascading replication: should we detect/prevent cycles? Josh Berkus 02:48
Re: find libxml2 using pkg-config 📎 Peter Eisentraut 03:17
Re: recursive view syntax Peter Eisentraut 03:34
Re: parameter info? Pavel Stehule 04:02
Re: parameter info? Tom Lane 04:17
Re: Suggestion: Issue warning when calling SET TRANSACTION outside transaction block Amit Kapila 05:04
Re: proposal - assign result of query to psql variable Pavel Stehule 05:22
Re: Re: proposal: a width specification for s specifier (format function), fix behave when positional and ordered placeholders are used 📎 Pavel Stehule 05:37
Re: Cascading replication: should we detect/prevent cycles? Peter Geoghegan 07:43
Re: pg_dump --pretty-print-views Jeevan Chalke 08:01
Unusually high IO for autovacuum worker Vlad Bailescu 08:14
Re: Cascading replication: should we detect/prevent cycles? Mark Kirkwood 08:16
Re: Unusually high IO for autovacuum worker Pavel Stehule 08:29
Re: Unusually high IO for autovacuum worker Pavan Deolasee 09:01
Re: [GENERAL] Unusually high IO for autovacuum worker Pavan Deolasee 09:37
Re: [GENERAL] Unusually high IO for autovacuum worker Pavan Deolasee 09:43
Re: Unusually high IO for autovacuum worker Vlad Bailescu 09:54
Re: Cascading replication: should we detect/prevent cycles? Craig Ringer 10:19
Re: [v9.3] writable foreign tables Daniel Farina 10:22
Re: [v9.3] writable foreign tables Kohei KaiGai 10:34
Re: Unusually high IO for autovacuum worker Pavan Deolasee 11:08
Re: Visual Studio 2012 RC Craig Ringer 11:12
Re: Unusually high IO for autovacuum worker Vlad Bailescu 11:49
Re: Unusually high IO for autovacuum worker Pavan Deolasee 12:40
proposal: enable new error fields in plpgsql (9.4) 📎 Pavel Stehule 12:47
Re: proposal: enable new error fields in plpgsql (9.4) Marko Tiikkaja 12:52
Re: proposal: enable new error fields in plpgsql (9.4) Pavel Stehule 13:00
Re: Performance Improvement by reducing WAL for Update Operation 📎 Amit Kapila 13:06
Turning auto-analyze off (was Re: [GENERAL] Unusually high IO for autovacuum worker) Pavan Deolasee 13:15
Re: Unusually high IO for autovacuum worker Kevin Grittner 13:27
Re: parameter info? Andrew Dunstan 13:34
Re: Unusually high IO for autovacuum worker Vlad Bailescu 13:40
Re: proposal: enable new error fields in plpgsql (9.4) Peter Eisentraut 13:43
obsolete code Andrew Dunstan 13:44
Re: Back-branch update releases coming in a couple weeks Andres Freund 13:50
Re: proposal: enable new error fields in plpgsql (9.4) Pavel Stehule 13:51
Re: Visual Studio 2012 RC Andrew Dunstan 13:55
Re: backend hangs at immediate shutdown (Re: Back-branch update releases coming in a couple weeks) 📎 Peter Eisentraut 13:55
Re: proposal: enable new error fields in plpgsql (9.4) Pavel Stehule 13:59
Re: backend hangs at immediate shutdown (Re: Back-branch update releases coming in a couple weeks) Andres Freund 14:04
Re: [PATCH] HOT on tables with oid indexes broken Alvaro Herrera 14:07
Re: backend hangs at immediate shutdown (Re: Back-branch update releases coming in a couple weeks) Tom Lane 15:12
Re: autovacuum not prioritising for-wraparound tables Alvaro Herrera 15:17
Re: Turning auto-analyze off (was Re: [GENERAL] Unusually high IO for autovacuum worker) Tom Lane 15:34
Re: Turning auto-analyze off (was Re: [GENERAL] Unusually high IO for autovacuum worker) Alvaro Herrera 15:37
Re: obsolete code Tom Lane 15:38
Re: Turning auto-analyze off (was Re: [GENERAL] Unusually high IO for autovacuum worker) Pavan Deolasee 15:54
Re: obsolete code Andrew Dunstan 16:06
Re: Turning auto-analyze off (was Re: [GENERAL] Unusually high IO for autovacuum worker) Pavan Deolasee 16:16
Re: PATCH: Split stats file per database WAS: autovacuum stress-testing our system Alvaro Herrera 16:19
Re: obsolete code Tom Lane 16:20
Re: obsolete code Pavel Stehule 16:21
Re: obsolete code Pavel Stehule 16:25
Re: obsolete code Pavel Stehule 16:27
Re: obsolete code Stephen Frost 16:31
Re: pkg-config files for libpq and ecpg 📎 Peter Eisentraut 16:34
Re: obsolete code Andrew Dunstan 16:35
Re: Streaming-only cascading replica won't come up without writes on the master Heikki Linnakangas 17:04
Re: PL/PgSQL STRICT Peter Eisentraut 17:11
Re: Turning auto-analyze off (was Re: [GENERAL] Unusually high IO for autovacuum worker) Bruce Momjian 17:23
Re: Turning auto-analyze off (was Re: [GENERAL] Unusually high IO for autovacuum worker) Pavan Deolasee 17:33
Re: COPY FREEZE has no warning Bruce Momjian 17:57
Re: PL/PgSQL STRICT Marko Tiikkaja 18:19
GetOldestXmin going backwards is dangerous after all Tom Lane 19:35
Re: Re: [COMMITTERS] pgsql: Tolerate timeline switches while "pg_basebackup -X fetch" is run Robert Haas 19:46
Re: sql_drop Event Trigger Robert Haas 20:07
cannot move relocatable extension out of pg_catalog schema Peter Eisentraut 20:08
Re: cannot move relocatable extension out of pg_catalog schema Tom Lane 20:21
some psql table output flaws 📎 Peter Eisentraut 20:22
Re: some psql table output flaws Erik Rijkers 21:03
Re: GetOldestXmin going backwards is dangerous after all Robert Haas 21:15
Re: Re: [PATCH 1/5] Centralize Assert* macros into c.h so its common between backend/frontend Alvaro Herrera 21:34
Re: autovacuum not prioritising for-wraparound tables Robert Haas 21:59
Re: autovacuum not prioritising for-wraparound tables Jeff Janes 22:05
Re: json api WIP patch Robert Haas 22:08
Re: cannot move relocatable extension out of pg_catalog schema Peter Eisentraut 22:13
Re: obsolete code Peter Eisentraut 22:16
Re: autovacuum not prioritising for-wraparound tables Andres Freund 22:34
Re: json api WIP patch Daniel Farina 22:39
Re: autovacuum not prioritising for-wraparound tables Christopher Browne 22:43
Re: proposal - assign result of query to psql variable Tom Lane 22:56
Re: json api WIP patch Tom Lane 23:03
Re: autovacuum not prioritising for-wraparound tables Tom Lane 23:08
Re: autovacuum not prioritising for-wraparound tables 📎 Jeff Janes 23:09
Cascading replica waits for write on master to come up Josh Berkus 23:17
issues with range types, btree_gist and constraints Tomas Vondra 23:40
Re: GetOldestXmin going backwards is dangerous after all Tom Lane 23:56

Feb. 2, 2013

Thread Author Time
Re: GetOldestXmin going backwards is dangerous after all Tom Lane 00:24
Re: autovacuum not prioritising for-wraparound tables Jeff Janes 04:48
proposal 9.4 plpgsql: allows access to call stack from GET DIAGNOSTICS statement 📎 Pavel Stehule 09:23
Using indexes for partial index builds Paul Norman 10:05
Re: proposal - assign result of query to psql variable Pavel Stehule 10:30
Re: GetOldestXmin going backwards is dangerous after all Simon Riggs 11:00
Re: GetOldestXmin going backwards is dangerous after all Simon Riggs 11:07
Re: proposal - assign result of query to psql variable Shigeru Hanada 11:25
Re: autovacuum not prioritising for-wraparound tables Andres Freund 13:25
Re: autovacuum not prioritising for-wraparound tables Andres Freund 13:41
Re: GetOldestXmin going backwards is dangerous after all Andres Freund 14:24
Re: proposal - assign result of query to psql variable Pavel Stehule 14:43
Re: COPY FREEZE has no warning Noah Misch 14:51
Re: COPY FREEZE has no warning Bruce Momjian 15:12
Re: Turning auto-analyze off (was Re: [GENERAL] Unusually high IO for autovacuum worker) Vlad Bailescu 15:19
Re: GetOldestXmin going backwards is dangerous after all Robert Haas 15:23
Re: GetOldestXmin going backwards is dangerous after all Robert Haas 15:34
Re: Suggestion: Issue warning when calling SET TRANSACTION outside transaction block Robert Haas 15:38
Re: autovacuum not prioritising for-wraparound tables Robert Haas 15:43
Re: autovacuum not prioritising for-wraparound tables Robert Haas 16:25
Re: COPY FREEZE has no warning Tom Lane 17:09
Re: proposal - assign result of query to psql variable Tom Lane 17:38
Re: COPY FREEZE has no warning 📎 Bruce Momjian 17:56
Re: GetOldestXmin going backwards is dangerous after all Simon Riggs 18:32
Re: GetOldestXmin going backwards is dangerous after all Simon Riggs 18:34
Re: GetOldestXmin going backwards is dangerous after all Simon Riggs 18:35
Re: GetOldestXmin going backwards is dangerous after all Andres Freund 18:38
Re: Cascading replication: should we detect/prevent cycles? Robert Haas 18:41
Re: autovacuum not prioritising for-wraparound tables Andres Freund 18:49
pgsql: Mark vacuum_defer_cleanup_age as PGC_POSTMASTER. Simon Riggs 18:55
Re: COPY FREEZE has no warning Noah Misch 19:27
Re: autovacuum not prioritising for-wraparound tables Robert Haas 19:54
Re: pgsql: Mark vacuum_defer_cleanup_age as PGC_POSTMASTER. Robert Haas 19:55
Re: GetOldestXmin going backwards is dangerous after all Simon Riggs 20:11
Re: proposal - assign result of query to psql variable 📎 Pavel Stehule 20:39
Re: PL/Python result object str handler Steve Singer 20:43
Re: Setting visibility map in VACUUM's second phase 📎 Jeff Janes 21:01
Re: autovacuum not prioritising for-wraparound tables Andres Freund 21:03
Re: logical changeset generation v4 - Heikki's thoughts about the patch state Andres Freund 21:38
Re: proposal - assign result of query to psql variable Tom Lane 22:12
Re: PATCH: Split stats file per database WAS: autovacuum stress-testing our system Jeff Janes 22:33
Re: PATCH: Split stats file per database WAS: autovacuum stress-testing our system Tomáš Vondra 22:54

Feb. 3, 2013

Thread Author Time
Re: autovacuum not prioritising for-wraparound tables Andres Freund 01:40
Re: autovacuum not prioritising for-wraparound tables 📎 Andres Freund 01:41
Re: autovacuum not prioritising for-wraparound tables Christopher Browne 02:08
Re: autovacuum not prioritising for-wraparound tables Gavin Flower 02:47
Re: [PATCH] pg_isready (was: [WIP] pg_ping utility) 📎 Phil Sorber 02:55
[PATCH] Add PQconninfoParseParams and PQconninfodefaultsMerge to libpq Phil Sorber 03:16
Re: PL/Python result object str handler Peter Eisentraut 05:35
Re: Setting visibility map in VACUUM's second phase Pavan Deolasee 06:24
Re: [PATCH] Add PQconninfoParseParams and PQconninfodefaultsMerge to libpq Magnus Hagander 06:37
Re: Suggestion: Issue warning when calling SET TRANSACTION outside transaction block Amit kapila 07:19
Re: [PATCH] Add PQconninfoParseParams and PQconninfodefaultsMerge to libpq 📎 Phil Sorber 07:23
Re: missing rename support 📎 Dean Rasheed 15:04
Re: autovacuum not prioritising for-wraparound tables Tom Lane 16:17
Re: autovacuum not prioritising for-wraparound tables Andres Freund 16:41
Re: autovacuum not prioritising for-wraparound tables Kevin Grittner 17:25
Re: [COMMITTERS] pgsql: Mark vacuum_defer_cleanup_age as PGC_POSTMASTER. Tom Lane 17:53
Re: proposal - assign result of query to psql variable Pavel Stehule 18:22
Re: autovacuum not prioritising for-wraparound tables Tom Lane 18:26
Re: proposal - assign result of query to psql variable Tom Lane 19:02
Re: proposal - assign result of query to psql variable Pavel Stehule 19:34
Re: PATCH: Split stats file per database WAS: autovacuum stress-testing our system Jeff Janes 19:46
sepgsql and materialized views 📎 Kevin Grittner 20:38
Re: PATCH: Split stats file per database WAS: autovacuum stress-testing our system Jeff Janes 20:54
Re: pg_dump --pretty-print-views Tom Lane 21:06
Re: autovacuum not prioritising for-wraparound tables Andres Freund 21:08
Re: ALTER command reworks Tom Lane 21:57
Turning off hot_standby_feedback 📎 Simon Riggs 22:25
Re: [COMMITTERS] pgsql: Mark vacuum_defer_cleanup_age as PGC_POSTMASTER. Simon Riggs 22:37
Re: autovacuum not prioritising for-wraparound tables Jeff Janes 22:58

Feb. 4, 2013

Thread Author Time
Re: PATCH: Split stats file per database WAS: autovacuum stress-testing our system Tomas Vondra 00:49
Re: PATCH: Split stats file per database WAS: autovacuum stress-testing our system Tomas Vondra 00:50
Re: PATCH: Split stats file per database WAS: autovacuum stress-testing our system 📎 Tomas Vondra 00:51
Re: cannot move relocatable extension out of pg_catalog schema Robert Haas 01:16
Re: json api WIP patch Robert Haas 01:20
Re: json api WIP patch Andrew Dunstan 02:05
Re: PATCH: Split stats file per database WAS: autovacuum stress-testing our system Tomas Vondra 02:21
Re: lazy_vacuum_heap()'s removal of HEAPTUPLE_DEAD tuples Noah Misch 03:00
Re: ALTER command reworks Kohei KaiGai 05:02
Re: proposal: ANSI SQL 2011 syntax for named parameters Pavel Stehule 08:55
Re: cannot move relocatable extension out of pg_catalog schema Hannu Krosing 09:13
Re: sepgsql and materialized views Kohei KaiGai 09:17
Re: pg_dump --pretty-print-views Marko Tiikkaja 10:04
Re: GetOldestXmin going backwards is dangerous after all Andres Freund 10:37
Re: Temporal features in PostgreSQL Miroslav Šimulčík 10:40
Re: Streaming-only cascading replica won't come up without writes on the master Josh Berkus 11:00
Re: [PATCH] pg_isready (was: [WIP] pg_ping utility) Bruce Momjian 11:49
Re: missing rename support Ali Dar 12:48
Re: [PATCH] Add PQconninfoParseParams and PQconninfodefaultsMerge to libpq Alvaro Herrera 14:13
Re: json api WIP patch Merlin Moncure 14:18
Re: ALTER command reworks Alvaro Herrera 14:23
Re: [PATCH] Add PQconninfoParseParams and PQconninfodefaultsMerge to libpq Phil Sorber 15:08
Re: [PATCH] Add PQconninfoParseParams and PQconninfodefaultsMerge to libpq Alvaro Herrera 15:16
Re: [PATCH] Add PQconninfoParseParams and PQconninfodefaultsMerge to libpq Phil Sorber 15:25
Re: [PATCH] Add PQconninfoParseParams and PQconninfodefaultsMerge to libpq Alvaro Herrera 15:32
Re: Audit Logs WAS: temporal support patch Miroslav Šimulčík 15:33
Re: Turning auto-analyze off (was Re: [GENERAL] Unusually high IO for autovacuum worker) Robert Haas 15:35
Re: logical changeset generation v4 - Heikki's thoughts about the patch state Robert Haas 15:39
Re: json api WIP patch Robert Haas 15:47
Re: Turning off hot_standby_feedback Robert Haas 15:52
Re: sepgsql and materialized views Kevin Grittner 15:58
Re: GetOldestXmin going backwards is dangerous after all Tom Lane 16:07
Re: json api WIP patch Andrew Dunstan 16:10

Browse Archives

Prev | Next