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

Oct. 10, 2025

Thread Author Time
Re: Support getrandom() for pg_strong_random() source Jacob Champion 00:11
Re: Replace O_EXCL with O_TRUNC for creation of state.tmp in SaveSlotToPath Michael Paquier 00:52
Re: speedup COPY TO for partitioned table. Chao Li 01:02
Re: Potential deadlock in pgaio_io_wait() Thomas Munro 01:44
Re: [PROPOSAL] Termination of Background Workers for ALTER/DROP DATABASE Chao Li 02:03
Re: [PATCH TEST] Fix logical replication setup in subscription test `t/009_matviews.pl` Michael Paquier 02:32
Re: get rid of RM_HEAP2_ID Michael Paquier 02:46
Re: speedup COPY TO for partitioned table. jian he 02:54
Re: GNU/Hurd portability patches Thomas Munro 02:59
Re: speedup COPY TO for partitioned table. Chao Li 03:29
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart shveta malik 04:02
Re: new environment variable INITDB_LOCALE_PROVIDER Chao Li 04:13
Re: Invalid primary_slot_name triggers warnings in all processes on reload 📎 Fujii Masao 05:52
Improved TAP tests by replacing sub-optimal uses of ok() with better Test::More functions 📎 Sadhuprasad Patro 05:52
Re: Executing pg_createsubscriber with a non-compatible control file 📎 Michael Paquier 06:07
Incorrect version number given to sync_pgdata() in pg_combinebackup.c 📎 Michael Paquier 06:21
Re: Add support for specifying tables in pg_createsubscriber. 📎 Shubham Khanna 06:26
Re: Incorrect version number given to sync_pgdata() in pg_combinebackup.c Chao Li 06:39
Re: Batching in executor 📎 Amit Langote 06:40
URLs in rbtree.c are broken Chao Li 07:00
Re: psql: Count all table footer lines in pager setup 📎 BharatDB 07:04
Re: speedup COPY TO for partitioned table. 📎 jian he 07:10
Re: Logical Replication of sequences Amit Kapila 07:33
Re: URLs in rbtree.c are broken Daniel Gustafsson 07:33
Re: [PATCH TEST] Fix logical replication setup in subscription test `t/009_matviews.pl` Amit Kapila 07:36
Re: Support getrandom() for pg_strong_random() source Daniel Gustafsson 07:36
Preserve index stats during ALTER TABLE ... TYPE ... 📎 Bertrand Drouvot 07:39
Re: Making pg_rewind faster Srinath Reddy Sadipiralla 07:44
Re: [PATCH] ecpg: check return value of replace_variables() Daniel Gustafsson 07:48
RE: [PATCH TEST] Fix logical replication setup in subscription test `t/009_matviews.pl` Hayato Kuroda (Fujitsu) 07:49
Re: URLs in rbtree.c are broken 📎 Chao Li 08:08
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart shveta malik 08:54
RE: [PROPOSAL] Termination of Background Workers for ALTER/DROP DATABASE 📎 Aya Iwata (Fujitsu) 09:04
Re: speedup COPY TO for partitioned table. Álvaro Herrera 09:26
Re: new environment variable INITDB_LOCALE_PROVIDER Peter Eisentraut 09:32
Re: [PATCH TEST] Fix logical replication setup in subscription test `t/009_matviews.pl` Ashutosh Bapat 10:29
Re: Patch for migration of the pg_commit_ts directory Maxim Orlov 10:55
Re: [PROPOSAL] Termination of Background Workers for ALTER/DROP DATABASE Andrei Lepikhov 11:05
Re: [PATCH] jit: fix build with LLVM-21 Holger Hoffstätte 11:10
Re: pull-up subquery if JOIN-ON contains refs to upper-query 📎 Alena Rybakina 11:15
Re: CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions 📎 jian he 12:23
Re: Preserve index stats during ALTER TABLE ... TYPE ... Sami Imseih 12:37
Re: Thoughts on a "global" client configuration? Robert Haas 13:24
Re: Improved TAP tests by replacing sub-optimal uses of ok() with better Test::More functions Andrew Dunstan 13:33
Re: Adding REPACK [concurrently] 📎 Alvaro Herrera 14:11
Re: Patch for migration of the pg_commit_ts directory 📎 ls7777 14:19
Re: make ALTER DOMAIN VALIDATE CONSTRAINT no-op when constraint is validated 📎 jian he 14:42
[PATCH] Remove make_temptable_name_n() 📎 Aleksander Alekseev 15:22
Re: [PATCH] Remove make_temptable_name_n() Nathan Bossart 15:46
Re: Preserve index stats during ALTER TABLE ... TYPE ... Bertrand Drouvot 15:52
Re: RFC: extensible planner state Tom Lane 15:58
Re: ReadRecentBuffer() doesn't scale well Andres Freund 16:08
Re: ReadRecentBuffer() doesn't scale well Amit Langote 16:24
Re: Clarification on Role Access Rights to Table Indexes 📎 Nathan Bossart 16:26
Re: Fix array access (src/bin/pg_dump/pg_dump.c) Ranier Vilela 16:41
Re: Should we update the random_page_cost default value? Tomas Vondra 17:22
Re: another autovacuum scheduling thread 📎 Nathan Bossart 17:31
Re: pg_waldump: support decoding of WAL inside tarfile Robert Haas 18:01
Re: RFC: extensible planner state Robert Haas 18:02
Re: new environment variable INITDB_LOCALE_PROVIDER 📎 Jeff Davis 18:09
Re: new environment variable INITDB_LOCALE_PROVIDER Jeff Davis 18:28
Re: Clarification on Role Access Rights to Table Indexes Jeff Davis 18:31
Re: another autovacuum scheduling thread Robert Haas 18:42
Re: Optimize LISTEN/NOTIFY 📎 Joel Jacobson 18:46
Re: Remove custom redundant full page write description from GIN Andrey Borodin 18:59
Re: Bypassing cursors in postgres_fdw to enable parallel plans Robert Haas 19:35
Re: another autovacuum scheduling thread Nathan Bossart 19:44
Re: Bypassing cursors in postgres_fdw to enable parallel plans Robert Haas 20:02
Re: another autovacuum scheduling thread Robert Haas 20:24
Re: [PING] [PATCH v2] parallel pg_restore: avoid disk seeks when jumping short distance forward 📎 Tom Lane 20:26
Re: Buf fix: update-po for PGXS does not work Bryan Green 21:20
Re: Parameter name standby_mode Mario González Troncoso 21:34
Re: another autovacuum scheduling thread Jeremy Schneider 21:59

Oct. 11, 2025

Thread Author Time
Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options 📎 Tatsuo Ishii 00:07
Re: new environment variable INITDB_LOCALE_PROVIDER Chao Li 00:30
Change initdb default to the builtin collation provider Jeff Davis 00:48
Re: new environment variable INITDB_LOCALE_PROVIDER Jeff Davis 02:06
Re: [PING] [PATCH v2] parallel pg_restore: avoid disk seeks when jumping short distance forward 📎 Tom Lane 02:22
Re: Improve read_local_xlog_page_guts by replacing polling with latch-based waiting 📎 Xuneng Zhou 03:02
Re: create table like including storage parameter 📎 jian he 05:08
Re: Fix array access (src/bin/pg_dump/pg_dump.c) 📎 Chao Li 05:24
Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options 📎 Tatsuo Ishii 05:42
Re: new environment variable INITDB_LOCALE_PROVIDER Chao Li 05:53
Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options Chao Li 05:57
Re: [PATCH TEST] Fix logical replication setup in subscription test `t/009_matviews.pl` Amit Kapila 06:04
Re: Optimize LISTEN/NOTIFY 📎 Joel Jacobson 06:43
Re: Optimize LISTEN/NOTIFY 📎 Joel Jacobson 07:43
Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options Tatsuo Ishii 09:11
Re: Fix array access (src/bin/pg_dump/pg_dump.c) Ranier Vilela 10:10
Re: Fix array access (src/bin/pg_dump/pg_dump.c) Chao Li 11:59
Re: GNU/Hurd portability patches Alexander Lakhin 12:00
IO in wrong state on riscv64 Alexander Lakhin 13:00
Re: Logical Replication of sequences 📎 vignesh C 14:12
Re: Invalid pointer access in logical decoding after error vignesh C 14:19
Re: memory leak in dbase_redo() Álvaro Herrera 14:48
Re: Add support for specifying tables in pg_createsubscriber. Peter Smith 22:55

Oct. 12, 2025

Thread Author Time
Re: GNU/Hurd portability patches Thomas Munro 00:42
Re: [PING] [PATCH v2] parallel pg_restore: avoid disk seeks when jumping short distance forward 📎 Tom Lane 01:25
Re: IO in wrong state on riscv64 Thomas Munro 03:35
Re: IO in wrong state on riscv64 Thomas Munro 03:58
Re: proposal: schema variables 📎 Pavel Stehule 04:57
Re: IO in wrong state on riscv64 📎 Alexander Lakhin 05:00
RE: [PATCH TEST] Fix logical replication setup in subscription test `t/009_matviews.pl` 📎 Hayato Kuroda (Fujitsu) 05:59
Re: another autovacuum scheduling thread David Rowley 06:27
Re: GNU/Hurd portability patches Michael Banck 08:31
Re: remove unnecessary include in src/backend/commands/policy.c Álvaro Herrera 08:31
Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options 📎 Tatsuo Ishii 08:39
Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options Tatsuo Ishii 12:05
Re: GNU/Hurd portability patches Alexander Lakhin 13:00
Re: IO in wrong state on riscv64 Greg Burd 13:10
Re: GNU/Hurd portability patches Michael Banck 13:20
Re: foreign key on virtual generated column Srinath Reddy Sadipiralla 14:12
Re: Finalizing read stream users' flag choices Arseniy Mukhin 14:55
Is there public API to fetch errcode? Sergey Fukanchik 16:04
Re: Add LZ4 compression in pg_dump Tom Lane 17:24
Re: Is there public API to fetch errcode? Tom Lane 17:27
Re: Is there public API to fetch errcode? David G. Johnston 17:37
Implementing IF NOT EXISTS clause for all CREATE TYPE variants Bram Hagens 17:45
Re: Implementing IF NOT EXISTS clause for all CREATE TYPE variants David G. Johnston 17:59
Re: Potential deadlock in pgaio_io_wait() Alexander Lakhin 18:00
Re: Is there public API to fetch errcode? Tom Lane 18:03
Re: Implementing IF NOT EXISTS clause for all CREATE TYPE variants Tom Lane 18:09
Re: index prefetching 📎 Peter Geoghegan 18:52
Re: GNU/Hurd portability patches Michael Banck 19:24
Re: Is there public API to fetch errcode? Sergey Fukanchik 19:41
Re: Is there public API to fetch errcode? Tom Lane 20:09
Re: [PROPOSAL] Termination of Background Workers for ALTER/DROP DATABASE Peter Smith 22:28
Re: Is there public API to fetch errcode? Sergey Fukanchik 22:39
Re: IO in wrong state on riscv64 Thomas Munro 22:44
Re: Improve docs for n_distinct_inherited 📎 David Rowley 23:42
Re: Adding basic NUMA awareness Alexey Makhmutov 23:58

Oct. 13, 2025

Thread Author Time
Re: Adding REPACK [concurrently] Robert Treat 00:03
Re: Logical Replication of sequences Peter Smith 00:59
Failure building libpq v18.0 on old aarch64 Daniele Varrazzo 01:06
Core dumps from recovery/017_shm Thomas Munro 01:07
Re: [PROPOSAL] Termination of Background Workers for ALTER/DROP DATABASE Peter Smith 01:20
Re: Improve docs for n_distinct_inherited David G. Johnston 01:27
Re: finish TODOs in to_json_is_immutable, to_jsonb_is_immutable also add tests on it 📎 jian he 01:47
Re: Improve docs for n_distinct_inherited Chao Li 01:47
Re: Failure building libpq v18.0 on old aarch64 Tom Lane 01:54
pgstattuple: Use streaming read API in pgstatindex functions 📎 Xuneng Zhou 02:07
Re: pgstattuple: Use streaming read API in pgstatindex functions 📎 Xuneng Zhou 03:20
Re: [PING] [PATCH v2] parallel pg_restore: avoid disk seeks when jumping short distance forward Chao Li 03:33
Re: [PATCH v1] parallel pg_restore: avoid disk seeks when jumping short distance forward David G. Johnston 03:39
Re: [PATCH v1] parallel pg_restore: avoid disk seeks when jumping short distance forward David G. Johnston 03:40
Re: [PATCH v1] parallel pg_restore: avoid disk seeks when jumping short distance forward Chao Li 03:41
Re: Improve docs for n_distinct_inherited David Rowley 03:43
Re: Improve docs for n_distinct_inherited 📎 David Rowley 03:48
Re: IO in wrong state on riscv64 📎 Alexander Lakhin 04:00
Re: Improve docs for n_distinct_inherited Chao Li 04:01
Improve docs for n_distinct_inherited David G. Johnston 04:09
Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options 📎 Tatsuo Ishii 04:43
Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options 📎 Tatsuo Ishii 04:49
Re: Add support for specifying tables in pg_createsubscriber. 📎 Shubham Khanna 05:18
commit_baseurl is broken in postgres.sgml Chao Li 05:34
Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options 📎 Tatsuo Ishii 05:39
Re: IO in wrong state on riscv64 Thomas Munro 05:40
Re: Add support for specifying tables in pg_createsubscriber. Peter Smith 05:44
Re: Question about InvalidatePossiblyObsoleteSlot() 📎 Bertrand Drouvot 06:27
Re: SQL:2011 Application Time Update & Delete 📎 Paul A Jungwirth 06:43
Re: Logical Replication of sequences Amit Kapila 06:59
Re: pgstattuple: Use streaming read API in pgstatindex functions Nazir Bilal Yavuz 07:00
Re: commit_baseurl is broken in postgres.sgml Daniel Gustafsson 07:18
Re: commit_baseurl is broken in postgres.sgml Chao Li 07:24
Re: Use streaming read I/O in BRIN vacuuming Nazir Bilal Yavuz 07:24
Re: Logical Replication of sequences shveta malik 07:27
Visibility bug in tuple lock 📎 Jasper Smit 07:48
Re: Improve pg_sync_replication_slots() to wait for primary to advance 📎 Ajin Cherian 07:57
Re: bug, ALTER TABLE call ATPostAlterTypeCleanup twice for the same relation 📎 jian he 08:08
Re: Improve docs for n_distinct_inherited 📎 David Rowley 08:31
Re: pgstattuple: Use streaming read API in pgstatindex functions 📎 Xuneng Zhou 08:42
Re: pgstattuple: Use streaming read API in pgstatindex functions wenhui qiu 09:41
Re: pgstattuple: Use streaming read API in pgstatindex functions Nazir Bilal Yavuz 09:42
Re: Reorganize GUC structs John Naylor 09:59
Re: Use merge-based matching for MCVs in eqjoinsel 📎 Ilia Evdokimov 10:08
Re: Adding basic NUMA awareness Tomas Vondra 11:09
Re: pgstattuple: Use streaming read API in pgstatindex functions Xuneng Zhou 11:14
Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options Álvaro Herrera 11:22
Re: doc: Improve description of io_combine_limit and io_max_combine_limit GUCs Karina Litskevich 11:33
Re: Reorganize GUC structs Álvaro Herrera 11:39
Re: pgstattuple: Use streaming read API in pgstatindex functions 📎 Xuneng Zhou 11:41
Re: [PATCH TEST] Fix logical replication setup in subscription test `t/009_matviews.pl` Amit Kapila 11:48
Re: Improve docs for n_distinct_inherited David G. Johnston 11:55
Build failure with Meson >= 1.8.3 on Windows Dave Page 12:30
Re: another autovacuum scheduling thread Robert Haas 12:32
Re: [PATCH TEST] Fix logical replication setup in subscription test `t/009_matviews.pl` Ashutosh Bapat 12:42
Upgrade Debian CI image from Bookworm to Trixie 📎 Nazir Bilal Yavuz 12:49
Re: Problem in 'ORDER BY' of a column using a created collation? Nishant Sharma 13:19
Re: doc: Improve description of io_combine_limit and io_max_combine_limit GUCs Chao Li 13:32
Re: add function argument name to substring and substr 📎 jian he 14:22
Re: Use streaming read I/O in BRIN vacuuming 📎 Arseniy Mukhin 14:54
Re: Build failure with Meson >= 1.8.3 on Windows Nazir Bilal Yavuz 14:57
Re: add function argument name to substring and substr Andrew Dunstan 14:58
Re: Question about InvalidatePossiblyObsoleteSlot() suyu.cmj 15:03
Re: Add notification on BEGIN ATOMIC SQL functions using temp relations 📎 Jim Jones 15:16
Re: add function argument name to substring and substr jian he 15:26
[PATCH] Fix incorrect fprintf usage in log_error FRONTEND path 📎 Bryan Green 15:32
Re: [PATCH] Fix incorrect fprintf usage in log_error FRONTEND path Tom Lane 15:48
Re: Add notification on BEGIN ATOMIC SQL functions using temp relations 📎 Jim Jones 15:49
Re: Build failure with Meson >= 1.8.3 on Windows Dave Page 15:49

Browse Archives

Prev | Next