pgsql-hackers since 2020-10-09 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

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

Browse Archives

Prev | Next

Oct. 9, 2020

Thread Author Time
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith 00:14
Re: [PATCH] ecpg: fix progname memory leak Michael Paquier 00:19
Re: Assertion failure with LEFT JOINs among >500 relations David Rowley 00:36
RE: [Patch] Optimize dropping of relation buffers using dlist [email protected] 00:41
Remove some unnecessary if-condition 📎 Hou, Zhijie 00:59
Re: Expansion of our checks for connection-loss errors Kyotaro Horiguchi 01:05
Re: Expansion of our checks for connection-loss errors Tom Lane 01:41
Re: Assertion failure with LEFT JOINs among >500 relations Tom Lane 02:06
Re: [Patch] Optimize dropping of relation buffers using dlist Kyotaro Horiguchi 02:12
Re: [Patch] Optimize dropping of relation buffers using dlist Kyotaro Horiguchi 02:24
RE: Transactions involving multiple postgres foreign servers, take 2 [email protected] 02:33
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 02:47
Re: Expansion of our checks for connection-loss errors Kyotaro Horiguchi 02:53
RE: POC: postgres_fdw insert batching [email protected] 03:01
Re: Logical replication CPU-bound with TRUNCATE/DROP/CREATE many tables Amit Kapila 03:10
Re: Fix typos in reorderbuffer.c Amit Kapila 03:13
Re: Minor documentation error regarding streaming replication protocol Bruce Momjian 03:17
RE: extension patch of CREATE OR REPLACE TRIGGER 📎 [email protected] 03:19
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila 03:23
Re: Assertion failure with LEFT JOINs among >500 relations David Rowley 04:32
Re: Logical replication CPU-bound with TRUNCATE/DROP/CREATE many tables Dilip Kumar 04:35
Re: Logical replication CPU-bound with TRUNCATE/DROP/CREATE many tables Amit Kapila 05:00
Re: Parallel copy Amit Kapila 05:12
Re: Logical replication CPU-bound with TRUNCATE/DROP/CREATE many tables Dilip Kumar 05:25
Re: Parallel copy Amit Kapila 05:31
Wrong statistics for size of XLOG_SWITCH during pg_waldump. 📎 [email protected] 05:41
Re: Wrong example in the bloom documentation Daniel Westermann (DWE) 05:44
Re: Transactions involving multiple postgres foreign servers, take 2 Kyotaro Horiguchi 05:55
RE: [PoC] Non-volatile WAL buffer 📎 Deng, Gang 06:09
Re: Parallel copy Amit Kapila 06:40
Re: range_agg Pavel Stehule 06:51
Re: [HACKERS] logical decoding of two-phase transactions 📎 Ajin Cherian 07:17
RE: Transactions involving multiple postgres foreign servers, take 2 [email protected] 07:27
abstract Unix-domain sockets 📎 Peter Eisentraut 07:28
Re: Parallel INSERT (INTO ... SELECT ...) Thomas Munro 07:30
Re: dynamic result sets support in extended query protocol Peter Eisentraut 07:31
Re: partition routing layering in nodeModifyTable.c 📎 Amit Langote 08:01
Re: Parallel copy Greg Nancarrow 08:06
Re: libpq debug log Kyotaro Horiguchi 08:31
Add a description to the documentation that toast_tuple_target affects "Main" 📎 Shinya Okano 08:43
Re: Wrong statistics for size of XLOG_SWITCH during pg_waldump. Kyotaro Horiguchi 08:46
Re: [PATCH] ecpg: fix progname memory leak Daniel Gustafsson 08:47
Re: Logical replication CPU-bound with TRUNCATE/DROP/CREATE many tables Simon Riggs 08:49
Re: Logical replication CPU-bound with TRUNCATE/DROP/CREATE many tables Amit Kapila 09:04
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 09:06
Re: Parallel INSERT (INTO ... SELECT ...) Amit Kapila 09:09
Re: Parallel copy 📎 Bharath Rupireddy 09:22
powerpc pg_atomic_compare_exchange_u32_impl: error: comparison of integer expressions of different signedness (Re: pgsql: For all ppc compilers, implement compare_exchange and) fetch_add Christoph Berg 09:28
Re: [HACKERS] Custom compression methods Dilip Kumar 09:31
Re: SEARCH and CYCLE clauses 📎 Peter Eisentraut 09:40
Re: Parallel INSERT (INTO ... SELECT ...) Amit Kapila 09:42
Re: Parallel copy Amit Kapila 09:56
Re: powerpc pg_atomic_compare_exchange_u32_impl: error: comparison of integer expressions of different signedness (Re: pgsql: For all ppc compilers, implement compare_exchange and) fetch_add Noah Misch 10:01
Re: SEARCH and CYCLE clauses Pavel Stehule 10:17
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 10:20
Re: Parallel copy Bharath Rupireddy 10:20
Re: Parallel copy Amit Kapila 10:57
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 10:57
Re: Transactions involving multiple postgres foreign servers, take 2 Masahiko Sawada 11:01
Re: [PATCH] ecpg: fix progname memory leak John Naylor 11:08
Re: Parallel INSERT (INTO ... SELECT ...) Amit Kapila 12:04
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 12:23
Uninitialized var utilized (src/backend/tsearch/spell.c) 📎 Ranier Vilela 12:36
Re: Transactions involving multiple postgres foreign servers, take 2 Masahiko Sawada 12:45
Re: Parallel INSERT (INTO ... SELECT ...) Amit Kapila 12:51
Re: Parallel INSERT (INTO ... SELECT ...) Amit Kapila 12:56
Re: Parallel INSERT (INTO ... SELECT ...) Amit Kapila 12:58
Re: Assertion failure with LEFT JOINs among >500 relations Tom Lane 13:19
Re: Expansion of our checks for connection-loss errors Fujii Masao 13:21
BUG #16663: DROP INDEX did not free up disk space: idle connection hold file marked as deleted PG Bug reporting form 13:24
Re: Two fsync related performance issues? Michael Banck 13:49
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 14:01
Re: Uninitialized var utilized (src/backend/tsearch/spell.c) Daniel Gustafsson 14:07
Re: Uninitialized var utilized (src/backend/tsearch/spell.c) Ranier Vilela 14:09
Re: Expansion of our checks for connection-loss errors Tom Lane 14:17
Re: Uninitialized var utilized (src/backend/tsearch/spell.c) Tom Lane 14:37
Re: Uninitialized var utilized (src/backend/tsearch/spell.c) Ranier Vilela 14:38
Re: libpq debug log Alvaro Herrera 14:48
Re: Wrong example in the bloom documentation Bruce Momjian 15:08
Possible NULL dereferencing null pointer (src/backend/executor/nodeIncrementalSort.c) 📎 Ranier Vilela 15:24
Re: [PATCH] ecpg: fix progname memory leak Magnus Hagander 15:48
Re: Expansion of our checks for connection-loss errors 📎 Tom Lane 16:14
Re: [PATCH] ecpg: fix progname memory leak Tom Lane 16:50
Re: Possible NULL dereferencing null pointer (src/backend/executor/nodeIncrementalSort.c) Tomas Vondra 17:05
Re: dynamic result sets support in extended query protocol Andrew Dunstan 17:32
Re: Batching page logging during B-tree build Andrey Borodin 18:08
Re: dynamic result sets support in extended query protocol Dave Cramer 18:39
Re: dynamic result sets support in extended query protocol Andres Freund 18:46
Re: dynamic result sets support in extended query protocol Dave Cramer 18:49
Re: pg_upgrade: fail early if a tablespace dir already exists for new cluster version 📎 Bruce Momjian 18:53
[PATCH] Add `truncate` option to subscription commands 📎 David Christensen 18:54
Re: [PATCH] ecpg: fix progname memory leak Bruce Momjian 18:57
Re: dynamic result sets support in extended query protocol Andres Freund 18:59
Re: dynamic result sets support in extended query protocol Dave Cramer 19:02
Re: pg_upgrade: fail early if a tablespace dir already exists for new cluster version Justin Pryzby 19:23
Re: [PATCH] ecpg: fix progname memory leak John Naylor 19:24
Re: BUG #15858: could not stat file - over 4GB Tom Lane 20:22
Re: Possible NULL dereferencing null pointer (src/backend/executor/nodeIncrementalSort.c) Ranier Vilela 20:25
Re: Improving connection scalability: GetSnapshotData() Andrew Dunstan 20:38
Re: Parallel INSERT (INTO ... SELECT ...) Thomas Munro 20:39
Re: Possible NULL dereferencing null pointer (src/backend/executor/nodeIncrementalSort.c) Tom Lane 20:47
Re: Possible NULL dereferencing null pointer (src/backend/executor/nodeIncrementalSort.c) Ranier Vilela 20:50
Re: Possible NULL dereferencing null pointer (src/backend/executor/nodeIncrementalSort.c) Peter Geoghegan 20:57
Re: Possible NULL dereferencing null pointer (src/backend/executor/nodeIncrementalSort.c) Ranier Vilela 21:00
Re: Possible NULL dereferencing null pointer (src/backend/executor/nodeIncrementalSort.c) Stephen Frost 21:02
Re: Possible NULL dereferencing null pointer (src/backend/executor/nodeIncrementalSort.c) Tom Lane 21:05
Re: Possible NULL dereferencing null pointer (src/backend/executor/nodeIncrementalSort.c) Ranier Vilela 21:09
Re: Possible NULL dereferencing null pointer (src/backend/executor/nodeIncrementalSort.c) Stephen Frost 21:16
Re: Possible NULL dereferencing null pointer (src/backend/executor/nodeIncrementalSort.c) Peter Geoghegan 21:17
Re: Possible NULL dereferencing null pointer (src/backend/executor/nodeIncrementalSort.c) Tomas Vondra 22:04
Re: Possible NULL dereferencing null pointer (src/backend/executor/nodeIncrementalSort.c) Tomas Vondra 22:12
Re: Possible NULL dereferencing null pointer (src/backend/executor/nodeIncrementalSort.c) Tom Lane 22:45
Re: pg_upgrade: fail early if a tablespace dir already exists for new cluster version 📎 Bruce Momjian 23:42

Oct. 10, 2020

Thread Author Time
Re: Possible NULL dereferencing null pointer (src/backend/executor/nodeIncrementalSort.c) Ranier Vilela 01:37
Re: Wrong statistics for size of XLOG_SWITCH during pg_waldump. 📎 [email protected] 01:50
Use list_delete_xxxcell O(1) instead of list_delete_ptr O(N) in some places 📎 Hou, Zhijie 02:44
Re: Possible NULL dereferencing null pointer (src/backend/executor/nodeIncrementalSort.c) David G. Johnston 03:10
Re: Parallel INSERT (INTO ... SELECT ...) Amit Kapila 04:32
Re: [PATCH] Add `truncate` option to subscription commands Amit Kapila 05:14
Re: SEARCH and CYCLE clauses Pavel Stehule 05:25
Re: SQL-standard function body 📎 Peter Eisentraut 08:41
Make LANGUAGE SQL the default 📎 Peter Eisentraut 08:49
Re: WIP: WAL prefetch (another approach) 📎 Tomas Vondra 11:29
Re: BUG #15858: could not stat file - over 4GB 📎 Juan José Santamaría Flecha 11:31
Re: Parallel INSERT (INTO ... SELECT ...) Amit Kapila 11:55
Re: [PATCH] Add `truncate` option to subscription commands David Christensen 12:16
Re: BUG #15858: could not stat file - over 4GB Michael Paquier 12:23
Re: BUG #15858: could not stat file - over 4GB Juan José Santamaría Flecha 14:29
Re: Batching page logging during B-tree build Andrey Borodin 16:00
Re: Make LANGUAGE SQL the default Tom Lane 16:14
Re: Make LANGUAGE SQL the default Pavel Stehule 16:30
Re: BUG #15858: could not stat file - over 4GB Tom Lane 17:42
Re: BUG #15858: could not stat file - over 4GB Juan José Santamaría Flecha 19:00

Oct. 11, 2020

Thread Author Time
Re: BUG #15858: could not stat file - over 4GB Michael Paquier 00:24
Re: BUG #15858: could not stat file - over 4GB Tom Lane 00:34
Re: Parallel INSERT (INTO ... SELECT ...) Amit Kapila 02:05
Re: Parallel INSERT (INTO ... SELECT ...) Thomas Munro 02:38
Re: powerpc pg_atomic_compare_exchange_u32_impl: error: comparison of integer expressions of different signedness (Re: pgsql: For all ppc compilers, implement compare_exchange and) fetch_add 📎 Noah Misch 05:10
Re: public schema default ACL Noah Misch 07:57
Re: speed up unicode normalization quick check Michael Paquier 10:27
Re: Possible NULL dereferencing null pointer (src/backend/executor/nodeIncrementalSort.c) Ranier Vilela 10:39
Re: powerpc pg_atomic_compare_exchange_u32_impl: error: comparison of integer expressions of different signedness (Re: pgsql: For all ppc compilers, implement compare_exchange and) fetch_add Tom Lane 17:12
Re: Possible NULL dereferencing null pointer (src/backend/executor/nodeIncrementalSort.c) David G. Johnston 17:52
Re: [PATCH] Add `truncate` option to subscription commands Euler Taveira 18:13
Re: powerpc pg_atomic_compare_exchange_u32_impl: error: comparison of integer expressions of different signedness (Re: pgsql: For all ppc compilers, implement compare_exchange and) fetch_add Christoph Berg 18:35
Re: [PATCH] Add `truncate` option to subscription commands David Christensen 22:13

Oct. 12, 2020

Thread Author Time
Re: BUG #15858: could not stat file - over 4GB Michael Paquier 01:01
Re: Wrong statistics for size of XLOG_SWITCH during pg_waldump. Michael Paquier 01:12
Re: powerpc pg_atomic_compare_exchange_u32_impl: error: comparison of integer expressions of different signedness (Re: pgsql: For all ppc compilers, implement compare_exchange and) fetch_add Michael Paquier 01:16
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 01:20
Re: Possible NULL dereferencing null pointer (src/backend/executor/nodeIncrementalSort.c) Ranier Vilela 01:34
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 01:44
Re: Wrong statistics for size of XLOG_SWITCH during pg_waldump. [email protected] 01:46
RE: Transactions involving multiple postgres foreign servers, take 2 [email protected] 02:07
Re: [HACKERS] Runtime Partition Pruning Andy Fan 02:28
Re: [PATCH] Keeps tracking the uniqueness with UniqueKey Andy Fan 02:32
Re: [PATCH] Keeps tracking the uniqueness with UniqueKey Andy Fan 02:33
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 02:41
Re: Possible NULL dereferencing null pointer (src/backend/executor/nodeIncrementalSort.c) David G. Johnston 02:44
Re: [PATCH] Add `truncate` option to subscription commands Amit Kapila 03:00
Re: Parallel INSERT (INTO ... SELECT ...) 📎 Thomas Munro 03:10
Re: BUG #15858: could not stat file - over 4GB Tom Lane 03:27
Re: Parallel INSERT (INTO ... SELECT ...) Amit Kapila 03:31
Re: powerpc pg_atomic_compare_exchange_u32_impl: error: comparison of integer expressions of different signedness (Re: pgsql: For all ppc compilers, implement compare_exchange and) fetch_add Noah Misch 04:46
Re: Resetting spilled txn statistics in pg_stat_replication 📎 Masahiko Sawada 05:29
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 05:34
Re: speed up unicode normalization quick check Masahiko Sawada 05:43
Re: Resetting spilled txn statistics in pg_stat_replication Masahiko Sawada 06:22
Re: speed up unicode normalization quick check 📎 Michael Paquier 06:27
Re: Parallel INSERT (INTO ... SELECT ...) Amit Kapila 06:36
Re: speed up unicode normalization quick check Masahiko Sawada 06:39
Re: Add Information during standby recovery conflicts 📎 Drouvot, Bertrand 07:05
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 07:07
Re: Transactions involving multiple postgres foreign servers, take 2 Masahiko Sawada 07:10
RE: Transactions involving multiple postgres foreign servers, take 2 [email protected] 08:19
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Julien Rouhaud 08:20
Re: Wired if-statement in gen_partprune_steps_internal 📎 Amit Langote 08:36
Re: Remove some unnecessary if-condition Ashutosh Bapat 08:44
Re: Parallel INSERT (INTO ... SELECT ...) Amit Kapila 08:52
Re: [HACKERS] Custom compression methods 📎 Dilip Kumar 08:58
RE: Resetting spilled txn statistics in pg_stat_replication 📎 Shinoda, Noriyoshi (PN Japan A&PS Delivery) 09:29
RE: [Patch] Optimize dropping of relation buffers using dlist 📎 [email protected] 09:38
Re: speed up unicode normalization quick check 📎 John Naylor 09:46
Re: [HACKERS] Runtime Partition Pruning Ashutosh Bapat 09:47
Re: Logical replication CPU-bound with TRUNCATE/DROP/CREATE many tables Dilip Kumar 09:52
Re: Add primary keys to system catalogs John Naylor 10:19
Re: Resetting spilled txn statistics in pg_stat_replication Amit Kapila 10:25
Re: Improved Cost Calculation for IndexOnlyScan Hamid Akhtar 10:46
Re: Deleting older versions in unique indexes to avoid page splits Andrey Borodin 10:47
Re: [Patch] Optimize dropping of relation buffers using dlist Amit Kapila 10:49
Re: Resetting spilled txn statistics in pg_stat_replication Masahiko Sawada 11:11
Re: partition routing layering in nodeModifyTable.c 📎 Heikki Linnakangas 11:12
Re: Resetting spilled txn statistics in pg_stat_replication Amit Kapila 11:21
Re: speed up unicode normalization quick check Michael Paquier 11:29
Re: speed up unicode normalization quick check Michael Paquier 11:36
Re: Parallel INSERT (INTO ... SELECT ...) Thomas Munro 11:37
RE: Remove some unnecessary if-condition Hou, Zhijie 11:42
Re: Batching page logging during B-tree build Dmitry Dolgov 11:45
Re: archive status ".ready" files may be created too early Heikki Linnakangas 12:04
Re: [PATCH] Add features to pg_stat_statements Yuki Seino 12:18

Browse Archives

Prev | Next