pgsql-hackers since 2012-09-15 00:00

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

Browse Archives

Prev | Next

Sept. 15, 2012

Thread Author Time
[RFC][PATCH] wal decoding, attempt #2 Andres Freund 00:33
[PATCH 1/8] Add embedded list interface (header only) 📎 Andres Freund 00:39
[PATCH 2/8] Add minimal binary heap implementation 📎 Andres Freund 00:39
[PATCH 3/8] Add support for a generic wal reading facility dubbed XLogReader 📎 Andres Freund 00:39
[PATCH 4/8] add simple xlogdump tool 📎 Andres Freund 00:39
[PATCH 5/8] Add a new syscache to fetch a pg_class entry via (reltablespace, relfilenode) 📎 Andres Freund 00:39
[PATCH 6/8] Log enough data into the wal to reconstruct logical changes from it if wal_level=logical 📎 Andres Freund 00:39
[PATCH 7/8] Make InvalidateSystemCaches public 📎 Andres Freund 00:39
[PATCH 8/8] Introduce wal decoding via catalog timetravel 📎 Andres Freund 00:39
Re: embedded list v2 Andres Freund 00:50
WIP checksums patch Jeff Davis 00:58
git tree Andres Freund 01:14
Re: Closing CF 2012-06 Noah Misch 01:50
Re: WIP checksums patch 📎 Jeff Davis 02:33
Re: pg_upgrade from 9.1.3 to 9.2 failed 📎 Rural Hunter 03:40
Re: embedded list v2 Tom Lane 05:32
Re: [BUGS] BUG #7534: walreceiver takes long time to detect n/w breakdown Fujii Masao 05:57
Re: [BUGS] BUG #7534: walreceiver takes long time to detect n/w breakdown Amit kapila 07:26
FW: Minor inheritance/check bug: Inconsistent behavior 📎 Amit kapila 08:04
Re: embedded list v2 Andres Freund 08:08
Re: git tree Andres Freund 10:14
Re: Re: [COMMITTERS] pgsql: Properly set relpersistence for fake relcache entries. Robert Haas 13:05
Re: Re: [COMMITTERS] pgsql: Properly set relpersistence for fake relcache entries. Tom Lane 16:29
Re: embedded list v2 Tom Lane 17:21
Re: pg_upgrade from 9.1.3 to 9.2 failed 📎 Bruce Momjian 18:06
Re: [BUGS] BUG #7534: walreceiver takes long time to detect n/w breakdown Fujii Masao 18:44
Re: [COMMITTERS] pgsql: Properly set relpersistence for fake relcache entries. Andres Freund 19:00

Sept. 16, 2012

Thread Author Time
_FORTIFY_SOURCE by default? Peter Eisentraut 00:31
Re: Re: [COMMITTERS] pgsql: Properly set relpersistence for fake relcache entries. Robert Haas 02:39
Re: Re: [COMMITTERS] pgsql: Properly set relpersistence for fake relcache entries. Tom Lane 04:32
Re: pg_upgrade from 9.1.3 to 9.2 failed Rural Hunter 04:38
Re: _FORTIFY_SOURCE by default? Tom Lane 04:41
Re: [BUGS] BUG #7534: walreceiver takes long time to detect n/w breakdown Amit kapila 06:10
Re: Re: [COMMITTERS] pgsql: Properly set relpersistence for fake relcache entries. Robert Haas 12:10
Patch to include c.h 📎 Gurjeet Singh 13:49
Re: embedded list v2 Andres Freund 14:23
Re: _FORTIFY_SOURCE by default? Andrew Dunstan 14:36
Re: _FORTIFY_SOURCE by default? Tom Lane 15:26
Re: Patch to include c.h Tom Lane 15:52
Possible fix for occasional failures on castoroides etc Tom Lane 16:04
Re: Possible fix for occasional failures on castoroides etc Andrew Dunstan 16:44
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Bruce Momjian 17:17
Re: embedded list v2 Andres Freund 17:56
Re: _FORTIFY_SOURCE by default? Peter Eisentraut 18:30
Re: _FORTIFY_SOURCE by default? Peter Eisentraut 18:34
pgsql: Fix bufmgr so CHECKPOINT_END_OF_RECOVERY behaves as a shutdown c Simon Riggs 18:54
Re: _FORTIFY_SOURCE by default? Tom Lane 19:58
Re: [WIP] Patch : Change pg_ident.conf parsing to be the same as pg_hba.conf Jeff Janes 20:09
Re: Question about SSI, subxacts, and aborted read-only xacts 📎 Kevin Grittner 21:16
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Tom Lane 22:04
Add pg_relation_by_filenode(reltbspc, filenode) admin function Andres Freund 22:15
[PATCH 1/2] Add a new relmapper.c function RelationMapFilenodeToOid that acts as a reverse of RelationMapOidToFilenode 📎 Andres Freund 22:15
[PATCH 2/2] Add a new function pg_relation_by_filenode to lookup up a relation given the tablespace and the filenode OIDs 📎 Andres Freund 22:15
Re: too much pgbench init output 📎 Tomas Vondra 22:26
Re: [PATCH 2/2] Add a new function pg_relation_by_filenode to lookup up a relation given the tablespace and the filenode OIDs Tom Lane 22:35
Re: [PATCH 2/2] Add a new function pg_relation_by_filenode to lookup up a relation given the tablespace and the filenode OIDs Andres Freund 22:46

Sept. 17, 2012

Thread Author Time
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Rural Hunter 01:35
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Tom Lane 01:48
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Rural Hunter 01:56
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Tom Lane 03:07
Re: [WIP] Patch : Change pg_ident.conf parsing to be the same as pg_hba.conf Amit Kapila 03:37
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Bruce Momjian 04:32
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Bruce Momjian 04:35
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Tom Lane 04:47
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Rural Hunter 05:03
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Rural Hunter 05:07
Re: Re: [COMMITTERS] pgsql: Properly set relpersistence for fake relcache entries. Tom Lane 05:35
Re: Re: [COMMITTERS] pgsql: Properly set relpersistence for fake relcache entries. Andres Freund 06:44
Re: [BUGS] BUG #7534: walreceiver takes long time to detect n/w breakdown Amit Kapila 07:03
Re: [PATCH 3/8] Add support for a generic wal reading facility dubbed XLogReader 📎 Heikki Linnakangas 07:40
Re: [PATCH 3/8] Add support for a generic wal reading facility dubbed XLogReader Andres Freund 08:12
Re: [PATCH 3/8] Add support for a generic wal reading facility dubbed XLogReader 📎 Heikki Linnakangas 08:30
Re: Re: [COMMITTERS] pgsql: Properly set relpersistence for fake relcache entries. Simon Riggs 08:44
Re: [PATCH 3/8] Add support for a generic wal reading facility dubbed XLogReader Andres Freund 09:07
Re: [PATCH 3/8] Add support for a generic wal reading facility dubbed XLogReader Andres Freund 10:01
Re: [PATCH 3/8] Add support for a generic wal reading facility dubbed XLogReader Heikki Linnakangas 10:52
Re: [PATCH 3/8] Add support for a generic wal reading facility dubbed XLogReader Heikki Linnakangas 10:55
Re: [PATCH 3/8] Add support for a generic wal reading facility dubbed XLogReader Andres Freund 11:42
Re: [PATCH 3/8] Add support for a generic wal reading facility dubbed XLogReader Heikki Linnakangas 11:50
Re: [PATCH 3/8] Add support for a generic wal reading facility dubbed XLogReader Andres Freund 12:06
Re: Possible fix for occasional failures on castoroides etc Dave Page 12:23
Re: [PATCH 3/8] Add support for a generic wal reading facility dubbed XLogReader Andres Freund 12:41
Re: Patch to include c.h Gurjeet Singh 13:49
Re: Re: [COMMITTERS] pgsql: Properly set relpersistence for fake relcache entries. Tom Lane 13:58
Re: [PATCH 3/8] Add support for a generic wal reading facility dubbed XLogReader Tom Lane 14:08
Re: [PATCH 3/8] Add support for a generic wal reading facility dubbed XLogReader Heikki Linnakangas 14:18
Re: [PATCH 3/8] Add support for a generic wal reading facility dubbed XLogReader Andres Freund 14:29
Re: [PATCH 3/8] Add support for a generic wal reading facility dubbed XLogReader Andres Freund 14:35
Re: [COMMITTERS] pgsql: Fix bufmgr so CHECKPOINT_END_OF_RECOVERY behaves as a shutdown c Robert Haas 14:59
Re: [COMMITTERS] pgsql: Fix bufmgr so CHECKPOINT_END_OF_RECOVERY behaves as a shutdown c Andres Freund 15:14
Re: Question about SSI, subxacts, and aborted read-only xacts Alvaro Herrera 18:54
Re: Question about SSI, subxacts, and aborted read-only xacts Kevin Grittner 19:28
Re: [COMMITTERS] pgsql: Fix bufmgr so CHECKPOINT_END_OF_RECOVERY behaves as a shutdown c Simon Riggs 21:04
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Bruce Momjian 21:07
Re: Question about SSI, subxacts, and aborted read-only xacts Jeff Davis 22:16

Sept. 18, 2012

Thread Author Time
Re: parallel pg_dump 📎 Joachim Wieland 02:01
Re: [COMMITTERS] pgsql: Fix bufmgr so CHECKPOINT_END_OF_RECOVERY behaves as a shutdown c Robert Haas 02:18
Re: _FORTIFY_SOURCE by default? Peter Eisentraut 02:50
Re: _FORTIFY_SOURCE by default? Tom Lane 03:10
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Craig Ringer 07:07
Invalid optimization of VOLATILE function in WHERE clause? Florian Schoppmann 07:13
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Etsuro Fujita 08:52
Re: [PATCH]Tablesample Submission Hitoshi Harada 09:32
Re: [BUGS] BUG #7534: walreceiver takes long time to detect n/w breakdown Fujii Masao 12:32
Re: [BUGS] BUG #7534: walreceiver takes long time to detect n/w breakdown Amit Kapila 12:50
Re: Proof of concept: auto updatable views [Review of Patch] 📎 Amit kapila 13:23
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Tom Lane 13:59
Re: [PATCH] Support for Array ELEMENT Foreign Keys 📎 Marco Nenciarini 15:52
Re: Confusing EXPLAIN output in case of inherited tables Tom Lane 17:50
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Bruce Momjian 23:22

Sept. 19, 2012

Thread Author Time
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Etsuro Fujita 02:41
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Tom Lane 03:32
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Tom Lane 03:38
Re: 9.2 Cascading replication after slave promotion Gibheer 04:09
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Bruce Momjian 06:05
Re: WIP patch: add (PRE|POST)PROCESSOR options to COPY Etsuro Fujita 06:05
Re: proposal - assign result of query to psql variable 📎 Shigeru HANADA 09:51
Re: Reduce palloc's in numeric operations. Heikki Linnakangas 12:20
Re: ToDo: allow to get a number of processed rows by COPY statement Heikki Linnakangas 12:32
Re: Invalid optimization of VOLATILE function in WHERE clause? Tom Lane 14:30
Re: Invalid optimization of VOLATILE function in WHERE clause? Merlin Moncure 14:58
Re: Invalid optimization of VOLATILE function in WHERE clause? Robert Haas 16:10
Re: Invalid optimization of VOLATILE function in WHERE clause? Tom Lane 16:34
Re: Invalid optimization of VOLATILE function in WHERE clause? Robert Haas 16:55
Removal of AcceptInvalidationMessages broke things Tom Lane 17:17
Re: Invalid optimization of VOLATILE function in WHERE clause? Tom Lane 17:26
Re: Re: [COMMITTERS] pgsql: Properly set relpersistence for fake relcache entries. Tom Lane 17:47
Re: Removal of AcceptInvalidationMessages broke things Noah Misch 18:17
Re: Re: [COMMITTERS] pgsql: Properly set relpersistence for fake relcache entries. Simon Riggs 18:21
Re: Removal of AcceptInvalidationMessages broke things Tom Lane 18:25
Re: Removal of AcceptInvalidationMessages broke things Robert Haas 18:53
Re: Invalid optimization of VOLATILE function in WHERE clause? Robert Haas 18:58
Re: Invalid optimization of VOLATILE function in WHERE clause? Kevin Grittner 19:39
Re: Invalid optimization of VOLATILE function in WHERE clause? ktm@rice.edu 19:47
CTE optimization fence on the todo list? Daniel Browning 20:05
Re: [v9.3] Extra Daemons (Re: elegant and effective way for running jobs inside a database) Simon Riggs 20:13
Re: Invalid optimization of VOLATILE function in WHERE clause? Kevin Grittner 20:26
Re: Invalid optimization of VOLATILE function in WHERE clause? Kevin Grittner 20:30
Re: Invalid optimization of VOLATILE function in WHERE clause? David Johnston 20:40
Re: Invalid optimization of VOLATILE function in WHERE clause? Kevin Grittner 20:54
Re: Invalid optimization of VOLATILE function in WHERE clause? David Johnston 21:38
Re: Invalid optimization of VOLATILE function in WHERE clause? Kevin Grittner 21:51
Re: Invalid optimization of VOLATILE function in WHERE clause? David Johnston 21:59
Re: [COMMITTERS] pgsql: Fix bufmgr so CHECKPOINT_END_OF_RECOVERY behaves as a shutdown c Andres Freund 23:07

Sept. 20, 2012

Thread Author Time
Re: Invalid optimization of VOLATILE function in WHERE clause? Florian Schoppmann 01:26
newline conversion in SQL command strings Peter Eisentraut 02:56
Re: 64-bit API for large object Kohei KaiGai 05:06
Re: [v9.3] Extra Daemons (Re: elegant and effective way for running jobs inside a database) Amit Kapila 05:10
Re: newline conversion in SQL command strings Heikki Linnakangas 06:01
Re: Fwd: PATCH: psql boolean display Heikki Linnakangas 07:54
[PATCH] Make pg_basebackup configure and start standby [Review] Amit Kapila 10:30
Doubt Regarding changes to disable keepalives in walsender Amit Kapila 10:55
Re: ToDo: allow to get a number of processed rows by COPY statement [Review of Patch] 📎 Amit Kapila 13:08
Re: newline conversion in SQL command strings Peter Eisentraut 13:12
Re: Invalid optimization of VOLATILE function in WHERE clause? Merlin Moncure 13:17
Re: [v9.3] Extra Daemons (Re: elegant and effective way for running jobs inside a database) Alvaro Herrera 13:42
Re: [v9.3] Extra Daemons (Re: elegant and effective way for running jobs inside a database) Kohei KaiGai 14:04
XLogInsert scaling, revisited 📎 Heikki Linnakangas 15:29
Re: XLogInsert scaling, revisited Tom Lane 15:37
Re: Invalid optimization of VOLATILE function in WHERE clause? Merlin Moncure 15:49
Re: XLogInsert scaling, revisited Andres Freund 15:51
Re: XLogInsert scaling, revisited Simon Riggs 15:55
Re: XLogInsert scaling, revisited Heikki Linnakangas 16:21
Re: proposal - assign result of query to psql variable 📎 Pavel Stehule 17:01
Suggestion for --truncate-tables to pg_restore 📎 Karl O. Pinc 17:24
Re: Confusing EXPLAIN output in case of inherited tables 📎 Tom Lane 18:55
Re: Move postgresql_fdw_validator into dblink Kohei KaiGai 19:18
Re: newline conversion in SQL command strings Andrew Dunstan 19:23
Re: newline conversion in SQL command strings Tom Lane 19:34
Re: ToDo: allow to get a number of processed rows by COPY statement [Review of Patch] 📎 Pavel Stehule 19:53
Re: newline conversion in SQL command strings Andrew Dunstan 19:55
Re: Re: proposal and patch : support INSERT INTO...RETURNING with partitioned table using rule Tom Lane 20:34
Re: PATCH: pgbench - aggregation of info written into log 📎 Tomas Vondra 20:56
Assigning NULL to a record variable Kevin Grittner 21:05
Re: Configuration include directory 📎 Selena Deckelmann 21:10
Re: Assigning NULL to a record variable Tom Lane 21:31
Re: Assigning NULL to a record variable Pavel Stehule 21:39
Re: [COMMITTERS] pgsql: Properly set relpersistence for fake relcache entries. Andres Freund 21:55
Re: Assigning NULL to a record variable Tom Lane 21:55
Re: alter enum add value if not exists Tom Lane 22:34

Sept. 21, 2012

Thread Author Time
Re: 64-bit API for large object Nozomi Anzai 01:34
pg_reorg in core? Michael Paquier 02:05
Re: pg_reorg in core? Josh Kupershmidt 03:07
Re: 64-bit API for large object Tatsuo Ishii 03:09
Re: pg_reorg in core? Michael Paquier 03:33
Re: 64-bit API for large object Tom Lane 03:33
Re: pg_reorg in core? Hitoshi Harada 04:00
Re: pg_reorg in core? Josh Kupershmidt 04:17
Re: Assigning NULL to a record variable Pavel Stehule 04:20
Re: [v9.3] Extra Daemons (Re: elegant and effective way for running jobs inside a database) Amit Kapila 05:26
Re: [v9.3] Extra Daemons (Re: elegant and effective way for running jobs inside a database) Amit Kapila 05:47
Re: xlog filename formatting functions in recovery Heikki Linnakangas 07:25
Re: proposal - assign result of query to psql variable 📎 Shigeru HANADA 08:24
Re: 64-bit API for large object Kohei KaiGai 08:25
Re: 64-bit API for large object Yugo Nagata 08:33
Re: pg_reorg in core? M.Sakamoto 08:45
Re: [ADMIN] pg_upgrade from 9.1.3 to 9.2 failed Rural Hunter 09:16
Re: 64-bit API for large object Tatsuo Ishii 09:27
Re: 64-bit API for large object Kohei KaiGai 09:34
Re: ToDo: allow to get a number of processed rows by COPY statement [Review of Patch] Amit Kapila 09:36

Browse Archives

Prev | Next