pgsql-hackers since 2025-08-25 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)

Advanced Search

Browse Archives

Prev | Next

Aug. 25, 2025

Thread	Author	Time
minor refactor on src/test/modules/test_ddl_deparse/sql/alter_table.sql 📎	jian he	00:00
Re: Add support for specifying tables in pg_createsubscriber.	Peter Smith	00:08
Re: Add OID descriptions to dumped parse/query/plan trees	Chao Li	00:10
Fixes a trivial bug in dumped parse/query/plan trees	Chao Li	00:54
Re: minor refactor on src/test/modules/test_ddl_deparse/sql/alter_table.sql	Chao Li	01:05
Re: vacuumdb --missing-stats-only and permission issue 📎	Yugo Nagata	01:30
Re: Non-reproducible AIO failure	Thomas Munro	01:52
Re: disallow alter individual column if partition key contains wholerow reference 📎	jian he	02:22
Re: Non-reproducible AIO failure	Thomas Munro	02:41
Re: Non-reproducible AIO failure	Thomas Munro	02:42
Re: Identifying function-lookup failures due to argument name mismatches	Chao Li	02:43
Re: Memory leak of SMgrRelation object on standby	邱宇航	02:46
Re: bug: virtual generated column can be partition key	jian he	02:57
Re: Fixes a trivial bug in dumped parse/query/plan trees	Stepan Neretin	03:20
Re: disallow alter individual column if partition key contains wholerow reference	Chao Li	03:57
Re: Fixes a trivial bug in dumped parse/query/plan trees	Chao Li	03:59
Re: disallow alter individual column if partition key contains wholerow reference	jian he	04:07
RE: Conflict detection for update_deleted in logical replication 📎	Zhijie Hou (Fujitsu)	04:36
Re: [BUG?] check_exclusion_or_unique_constraint false negative	Amit Kapila	05:01
Re: [BUG?] check_exclusion_or_unique_constraint false negative	Amit Kapila	05:02
Re: Conflict detection for update_deleted in logical replication	shveta malik	06:39
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart	shveta malik	06:46
RE: Add support for specifying tables in pg_createsubscriber.	Zhijie Hou (Fujitsu)	07:17
RE: Add support for specifying tables in pg_createsubscriber.	Zhijie Hou (Fujitsu)	07:22
Problem in 'ORDER BY' of a column using a created collation? 📎	Nishant Sharma	07:51
Re: Fixes a trivial bug in dumped parse/query/plan trees	Daniel Gustafsson	08:02
Re: Improve error message for duplicate labels in enum types	Jim Jones	08:08
Re: Skipping schema changes in publication 📎	Shlok Kyal	08:08
Re: SQL:2023 JSON simplified accessor support	jian he	08:09
Re: Report reorder buffer size	Ashutosh Bapat	08:18
Re: Making WAL archiving faster — multi-file support and async ideas	Alyona Vinter	08:31
Re: Fixes a trivial bug in dumped parse/query/plan trees	Chao Li	08:57
Calling PGReserveSemaphores() from CreateOrAttachShmemStructs 📎	Ashutosh Bapat	09:10
Re: Making jsonb_agg() faster	Chao Li	09:19
Re: Generate GUC tables from .dat file 📎	Peter Eisentraut	09:36
Re: Calling PGReserveSemaphores() from CreateOrAttachShmemStructs	Thomas Munro	09:40
RE: [Patch] add new parameter to pg_replication_origin_session_setup	Hayato Kuroda (Fujitsu)	10:43
Re: [BUG?] check_exclusion_or_unique_constraint false negative	Mihail Nikalayeu	10:49
Debugging sudden increase in planning CPU time (possibly due to get_actual_variable_range)	Core Studios Inc.	10:54
Re: Conflict detection for update_deleted in logical replication	shveta malik	11:03
Re: Changing gssencmode default in Psycopg	Daniele Varrazzo	11:17
Re: Conflict detection for update_deleted in logical replication	Amit Kapila	11:35
Re: [PATCH] Generate random dates/times in a specified range	Damien Clochard	11:42
Re: [BUG?] check_exclusion_or_unique_constraint false negative	Amit Kapila	11:51
Re: pg_waldump: support decoding of WAL inside tarfile 📎	Amul Sul	12:28
Re: Report reorder buffer size	Bertrand Drouvot	12:58
Re: index prefetching	Tomas Vondra	13:00
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart	Shlok Kyal	13:02
Re: Fix ALTER TABLE DROP EXPRESSION with inheritance hierarchy 📎	Kirill Reshke	13:04
Re: Adding REPACK [concurrently]	Antonin Houska	13:09
Re: [BUG] Remove self joins causes 'variable not found in subplan target lists' error	Richard Guo	13:28
Re: Fix ALTER TABLE DROP EXPRESSION with inheritance hierarchy	Kirill Reshke	13:29
Re: [BUG?] check_exclusion_or_unique_constraint false negative	Mihail Nikalayeu	13:32
Re: [PATCH] Generate random dates/times in a specified range	Greg Sabino Mullane	13:33
Re: Making WAL archiving faster — multi-file support and async ideas	Greg Sabino Mullane	13:38
Re: [BUG] Remove self joins causes 'variable not found in subplan target lists' error	Andrei Lepikhov	13:59
Re: Adding REPACK [concurrently]	Mihail Nikalayeu	14:15
Re: index prefetching 📎	Tomas Vondra	14:18
Re: vacuumdb --missing-stats-only and permission issue	Nathan Bossart	14:29
use PqMsg macros in fe-protocol3.c 📎	Nathan Bossart	14:57
Re: VM corruption on standby	Nathan Bossart	15:07
Re: use PqMsg macros in fe-protocol3.c	Jacob Champion	15:11
Re: use PqMsg macros in fe-protocol3.c	Fabrízio de Royes Mello	15:13
Re: vacuumdb --missing-stats-only and permission issue	Yugo Nagata	15:24
Re: Changing gssencmode default in Psycopg	Jacob Champion	15:27
Re: Problem in 'ORDER BY' of a column using a created collation?	jian he	15:28
Re: Adding REPACK [concurrently]	Antonin Houska	15:42
Re: index prefetching	Thomas Munro	15:43
Re: Memory leak of SMgrRelation object on standby 📎	Jingtang Zhang	15:56
Re: Adding REPACK [concurrently]	Robert Treat	16:03
Re: use PqMsg macros in fe-protocol3.c	Nathan Bossart	16:10
Re: [BUG] Remove self joins causes 'variable not found in subplan target lists' error	Sergey Soloviev	16:14
Re: vacuumdb --missing-stats-only and permission issue	Nathan Bossart	16:20
Re: Adding REPACK [concurrently]	Mihail Nikalayeu	16:23
Re: [BUG] Remove self joins causes 'variable not found in subplan target lists' error	Tom Lane	16:25
Re: Adding REPACK [concurrently]	Robert Treat	16:36
pgsql: oauth: Add unit tests for multiplexer handling	Jacob Champion	16:42
Re: GetNamedLWLockTranche crashes on Windows in normal backend	Nathan Bossart	16:46
Re: Adding REPACK [concurrently]	Antonin Houska	16:54
Re: [BUG] Remove self joins causes 'variable not found in subplan target lists' error 📎	Sergey Soloviev	16:57
Re: use PqMsg macros in fe-protocol3.c 📎	Ranier Vilela	17:03
Re: index prefetching	Tomas Vondra	17:13
Re: Adding REPACK [concurrently]	Antonin Houska	17:22
Re: index prefetching	Tomas Vondra	17:50
Re: index prefetching	Peter Geoghegan	17:57
Re: GetNamedLWLockTranche crashes on Windows in normal backend	Sami Imseih	17:58
Re: Adding REPACK [concurrently]	Mihail Nikalayeu	18:18
Re: Support getrandom() for pg_strong_random() source	Masahiko Sawada	18:29
Re: GetNamedLWLockTranche crashes on Windows in normal backend	Nathan Bossart	18:31
Re: Changing the state of data checksums in a running cluster 📎	Daniel Gustafsson	18:32
Re: index prefetching	Tomas Vondra	18:33
Re: GetNamedLWLockTranche crashes on Windows in normal backend 📎	Sami Imseih	18:44
Re: GetNamedLWLockTranche crashes on Windows in normal backend	Sami Imseih	18:51
Re: GetNamedLWLockTranche crashes on Windows in normal backend	Nathan Bossart	19:02
Re: Eagerly evict bulkwrite strategy ring 📎	Melanie Plageman	19:03
Re: use PqMsg macros in fe-protocol3.c	Nathan Bossart	19:11
Re: use PqMsg macros in fe-protocol3.c	Ranier Vilela	19:13
Re: index prefetching	Peter Geoghegan	19:16
Re: [BUG] Remove self joins causes 'variable not found in subplan target lists' error 📎	Tom Lane	19:16
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart 📎	Masahiko Sawada	19:24
Re: GetNamedLWLockTranche crashes on Windows in normal backend	Sami Imseih	19:34
Re: RFC: extensible planner state 📎	Robert Haas	19:46
Re: making EXPLAIN extensible	Robert Haas	19:50
Re: Support getrandom() for pg_strong_random() source	Jacob Champion	20:06
Re: Improve LWLock tranche name visibility across backends	Nathan Bossart	20:33
Re: Report reorder buffer size	Masahiko Sawada	20:47
Re: [BUG] Remove self joins causes 'variable not found in subplan target lists' error	Tom Lane	20:58
Re: Improve LWLock tranche name visibility across backends	Nathan Bossart	21:04
Re: List TAP test files in makefiles	Andres Freund	21:10
Re: Test instability when pg_dump orders by OID	Andres Freund	21:15
Re: GetNamedLWLockTranche crashes on Windows in normal backend 📎	Sami Imseih	21:28
Re: Improve LWLock tranche name visibility across backends	Sami Imseih	21:37
Re: GetNamedLWLockTranche crashes on Windows in normal backend	Nathan Bossart	21:41
Re: Improve LWLock tranche name visibility across backends	Nathan Bossart	21:44
Re: Improve LWLock tranche name visibility across backends	Sami Imseih	21:59
Re: Support getrandom() for pg_strong_random() source	Masahiko Sawada	22:21
Use LW_SHARED in WakeupWalSummarizer() for WALSummarizerLock lock 📎	Masahiko Sawada	22:38
Re: Support getrandom() for pg_strong_random() source	Jacob Champion	22:38
END is not a reserved word	Vicky Vergara	22:48
Re: Per backend relation statistics tracking	Sami Imseih	22:51
Re: Changing the state of data checksums in a running cluster 📎	Tomas Vondra	23:06
Re: Per backend relation statistics tracking	Michael Paquier	23:12
Re: Explicitly enable meson features in CI 📎	Jacob Champion	23:36
Re: index prefetching	Andres Freund	23:48

Aug. 26, 2025

Thread	Author	Time
Re: Use LW_SHARED in WakeupWalSummarizer() for WALSummarizerLock lock	Nathan Bossart	00:08
Re: Improve LWLock tranche name visibility across backends	Nathan Bossart	00:14
Re: Per backend relation statistics tracking	Sami Imseih	00:22
Re: Per backend relation statistics tracking	Andres Freund	00:28
Re: Improve LWLock tranche name visibility across backends	Sami Imseih	00:37
Re: Non-reproducible AIO failure 📎	Andres Freund	00:37
Re: Parallel heap vacuum	Masahiko Sawada	00:37
Re: Non-reproducible AIO failure	Andres Freund	00:44
Re: Use LW_SHARED in WakeupWalSummarizer() for WALSummarizerLock lock 📎	Masahiko Sawada	00:48
Re: END is not a reserved word	David G. Johnston	00:53
Re: Test instability when pg_dump orders by OID	Noah Misch	00:57
Re: Test instability when pg_dump orders by OID	Tom Lane	01:06
Re: index prefetching	Peter Geoghegan	01:08
Re: Improve error message for duplicate labels in enum types 📎	Yugo Nagata	02:55
Re: Non-reproducible AIO failure	Thomas Munro	03:21
Re: [PATCH] no table rewrite when set column type to constrained domain 📎	jian he	03:26
Re: Non-reproducible AIO failure	Thomas Munro	03:45
Re: SQL:2023 JSON simplified accessor support 📎	Alexandra Wang	03:52
Re: Memory leak of SMgrRelation object on standby 📎	Jingtang Zhang	03:59
Re: Improve pg_sync_replication_slots() to wait for primary to advance 📎	Ajin Cherian	04:28
Re: CREATE SCHEMA ... CREATE DOMAIN support 📎	jian he	04:53
Optimize JsonbContainerTypeName by reordering type checks 📎	Chao Li	05:26
Re: Logical Replication of sequences	shveta malik	05:51
Re: Potential problem in commit f777d773878 and 4f7f7b03758	Dilip Kumar	06:01
Re: Per backend relation statistics tracking	Bertrand Drouvot	06:12
Re: Per backend relation statistics tracking	Bertrand Drouvot	06:15
Re: Potential problem in commit f777d773878 and 4f7f7b03758 📎	Dilip Kumar	06:26
Re: Improve error message for duplicate labels in enum types	Jim Jones	06:30
Re: Per backend relation statistics tracking	Bertrand Drouvot	06:38
Re: Conflict detection for update_deleted in logical replication 📎	Amit Kapila	06:44
Re: Calling PGReserveSemaphores() from CreateOrAttachShmemStructs 📎	Ashutosh Bapat	07:11
Re: Making WAL archiving faster — multi-file support and async ideas	Alyona Vinter	07:12
Re: Explicitly enable meson features in CI	Nazir Bilal Yavuz	07:27
Detoast iterators -take 2 📎	Nikita Malakhov	07:41
Re: Support getrandom() for pg_strong_random() source	Daniel Gustafsson	07:42
Feature request: A method to configure client-side TLS ciphers for streaming replication	xx Z	07:46
Re: Add SPLIT PARTITION/MERGE PARTITIONS commands 📎	Dmitry Koval	08:05
Re: Adding REPACK [concurrently]	Antonin Houska	08:46
Re: RFC: extensible planner state	Andrei Lepikhov	08:58
Re: Adding REPACK [concurrently]	Mihail Nikalayeu	09:02
Re: Conflict detection for update_deleted in logical replication	Dilip Kumar	09:02
Re: Report reorder buffer size	Ashutosh Bapat	09:26
Re: [BUG] Remove self joins causes 'variable not found in subplan target lists' error 📎	Richard Guo	09:30
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart	shveta malik	09:32
[WiP] B-tree page merge during vacuum to reduce index bloat 📎	Andrey Borodin	09:40
Re: Per backend relation statistics tracking 📎	Bertrand Drouvot	09:44
Re: Report reorder buffer size	Ashutosh Bapat	09:44
Re: Report reorder buffer size	Bertrand Drouvot	09:48
Re: [BUG] Remove self joins causes 'variable not found in subplan target lists' error	Richard Guo	09:50
Re: Report reorder buffer size	Ashutosh Bapat	09:53
Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access)	Kirill Reshke	09:58
Re: Per backend relation statistics tracking	Bertrand Drouvot	10:06
Re: [WiP] B-tree page merge during vacuum to reduce index bloat	Matthias van de Meent	10:33
Re: Conflict detection for update_deleted in logical replication	shveta malik	10:44
Re: Problem in 'ORDER BY' of a column using a created collation?	Nishant Sharma	11:04
Re: [BUG?] check_exclusion_or_unique_constraint false negative	Amit Kapila	11:08
Re: Per backend relation statistics tracking	Andres Freund	11:18
Re: pg_restore --no-policies should not restore policies' comment 📎	Fujii Masao	11:43
Re: pg_waldump: support decoding of WAL inside tarfile 📎	Amul Sul	11:52
How to configure client-side TLS ciphers for streaming replication?	xx Z	11:54
Re: vacuumdb --missing-stats-only and permission issue	Fujii Masao	12:00
Re: Non-reproducible AIO failure	Andres Freund	12:01
Re: index prefetching 📎	Tomas Vondra	12:56
Re: Detoast iterators -take 2	Aleksander Alekseev	13:10
Re: Adding REPACK [concurrently]	Antonin Houska	13:31
Re: postmaster uses more CPU in 18 beta1 with io_method=io_uring	Jakub Wartak	13:31
Re: Dead code in ps_status.c 📎	Michael Banck	13:55
Re: Non-reproducible AIO failure	Konstantin Knizhnik	13:59
Redundant parameter in the get_useful_pathkeys_for_relation 📎	Andrei Lepikhov	14:03
Re: Feature request: A method to configure client-side TLS ciphers for streaming replication	Tom Lane	14:09
Re: [WiP] B-tree page merge during vacuum to reduce index bloat	Kirk Wolak	14:11
Re: Non-reproducible AIO failure	Ken Marshall	14:15
Re: [PATCH] Generate random dates/times in a specified range 📎	Damien Clochard	14:17
Avoid overwiriting cache entry (src/backend/utils/cache/relcache.c) 📎	Ranier Vilela	14:17
Marking shared buffer lookup table as HASH_FIXED_SIZE 📎	Ashutosh Bapat	14:25
Re: plan shape work 📎	Robert Haas	14:58

Browse Archives

Prev | Next