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

June 27, 2025

Thread Author Time
Re: Remove HeapTupleheaderSetXmin{Committed,Invalid} functions Andy Fan 00:02
Re: Removing unneeded self joins Michael Paquier 00:26
Re: [PATCH] Correct src/backend/lib/README Michael Paquier 00:34
Re: pg_logical_slot_get_changes waits continously for a partial WAL record spanning across 2 pages Michael Paquier 01:11
Re: pg_logical_slot_get_changes waits continously for a partial WAL record spanning across 2 pages Michael Paquier 01:34
Re: Documentation fix on pgbench \aset command 📎 Yugo Nagata 01:36
Re: SQL:2023 JSON simplified accessor support 📎 jian he 02:09
RE: Slot's restart_lsn may point to removed WAL segment after hard restart unexpectedly Hayato Kuroda (Fujitsu) 02:22
RE: Conflict detection for update_deleted in logical replication 📎 Zhijie Hou (Fujitsu) 02:28
Re: Extend COPY FROM with HEADER <integer> to skip multiple lines Shinya Kato 02:55
Re: Logical Replication of sequences shveta malik 03:20
Re: Extend COPY FROM with HEADER <integer> to skip multiple lines Fujii Masao 03:22
pg_restore --no-policies should not restore policies' comment 📎 jian he 04:08
Re: Extend COPY FROM with HEADER <integer> to skip multiple lines Yugo Nagata 04:09
Re: Slot's restart_lsn may point to removed WAL segment after hard restart unexpectedly Dilip Kumar 04:17
Re: Suggestion to add --continue-client-on-abort option to pgbench ikedarintarof 05:06
Re: pg_restore --no-policies should not restore policies' comment Fujii Masao 05:34
Re: ALTER TABLE ALTER CONSTRAINT misleading error message 📎 Fujii Masao 06:11
Re: Suggestion to add --continue-client-on-abort option to pgbench Yugo Nagata 06:17
Re: IPC/MultixactCreation on the Standby server Dmitry 06:41
Re: Removing unneeded self joins Andrei Lepikhov 06:46
Re: speedup COPY TO for partitioned table. 📎 jian he 07:14
Re: JIT works only partially with meson build? 📎 Yugo Nagata 07:19
[PATCH] Prevent replacement of a function if it's used in an index expression and is not IMMUTABLE 📎 sundayjiang (蒋浩天) 07:32
Check for existing replication slot in pg_createsubscriber Zane Duffield 07:42
Re: Conflict detection for update_deleted in logical replication shveta malik 08:07
Re: ALTER TABLE ALTER CONSTRAINT misleading error message jian he 08:11
Re: Adding support for SSLKEYLOGFILE in the frontend 📎 Daniel Gustafsson 09:15
Backpatching injection point core facilities to REL_17_STABLE 📎 Michael Paquier 09:25
Re: Backpatching injection point core facilities to REL_17_STABLE Andrey Borodin 09:45
Re: Memory consumed by paths during partitionwise join planning 📎 Andrei Lepikhov 10:01
Re: Skipping schema changes in publication 📎 Shlok Kyal 10:11
Re: Skipping schema changes in publication Shlok Kyal 10:14
Re: Historic snapshot doesn't track txns committed in BUILDING_SNAPSHOT state Ajin Cherian 10:29
RE: Suggestion to add --continue-client-on-abort option to pgbench Hayato Kuroda (Fujitsu) 10:59
Re: [PATCH] Add tests for binaryheap.c 📎 Aleksander Alekseev 11:02
Re: Correct documentation for protocol version Dave Cramer 11:20
vacuumlazy: Modernize count_nondeletable_pages 📎 Matthias van de Meent 11:34
Re: Prevent internal error at concurrent CREATE OR REPLACE FUNCTION Daniil Davydov 11:53
Re: [PATCH] Use DatumGetUInt32() for dsm_attach() in test_shm_mq_main() Tom Lane 12:03
Re: [PATCH] PGSERVICEFILE as part of a normal connection string 📎 Ryo Kanbayashi 12:25
Re: Decompression bug in astreamer_lz4 📎 Mikhail Gribkov 12:28
Re: Removing unneeded self joins Alexander Korotkov 12:55
Re: PG18 protocol version Tatsuo Ishii 13:14
Re: ALTER TABLE ALTER CONSTRAINT misleading error message Álvaro Herrera 13:30
analyze-in-stages post upgrade questions Zechman, Derek S 13:35
Re: analyze-in-stages post upgrade questions Ron Johnson 13:41
Re: [WIP]Vertical Clustered Index (columnar store extension) - take2 Timur Magomedov 14:24
Re: ALTER TABLE ALTER CONSTRAINT misleading error message Fujii Masao 14:34
Re: pgsql: Introduce pg_shmem_allocations_numa view 📎 Tomas Vondra 14:52
Re: Fixes inconsistent behavior in vacuum when it processes multiple relations shihao zhong 15:26
Re: analyze-in-stages post upgrade questions Adrian Klaver 15:31
Re: Extend COPY FROM with HEADER <integer> to skip multiple lines Fujii Masao 15:33
Re: pg_logical_slot_get_changes waits continously for a partial WAL record spanning across 2 pages 📎 vignesh C 15:58
Re: NUMA shared memory interleaving Tomas Vondra 16:41
libpq OpenSSL and multithreading 📎 Daniel Gustafsson 17:24
Re: pgsql: Introduce pg_shmem_allocations_numa view Bertrand Drouvot 17:33
Re: [PATCH] Use DatumGetUInt32() for dsm_attach() in test_shm_mq_main() Nathan Bossart 18:44
Re: [PATCH] Use DatumGetUInt32() for dsm_attach() in test_shm_mq_main() Jianghua Yang 19:01
Re: Cluster.pm psql() undefined $$stderr Andrew Dunstan 19:33
Re: IPC/MultixactCreation on the Standby server 📎 Andrey Borodin 19:37
Re: Making Row Comparison NULL row member handling more robust during skip scans 📎 Peter Geoghegan 21:35
Re: analyze-in-stages post upgrade questions Laurenz Albe 21:39
Re: Support tid range scan in parallel? Cary Huang 22:07
Re: pg_get_multixact_members not documented 📎 Nathan Bossart 22:32
Re: Proposal to add page headers to SLRU pages 📎 Rishu Bagga 22:43

June 28, 2025

Thread Author Time
RE: analyze-in-stages post upgrade questions Zechman, Derek S 01:11
RE: analyze-in-stages post upgrade questions Zechman, Derek S 01:23
Re: Backpatching injection point core facilities to REL_17_STABLE Michael Paquier 02:38
Re: Historic snapshot doesn't track txns committed in BUILDING_SNAPSHOT state cca5507 03:44
Re: Remove HeapTupleheaderSetXmin{Committed,Invalid} functions 📎 Andy Fan 05:00
Re: analyze-in-stages post upgrade questions 📎 Laurenz Albe 05:25
Re: IPC/MultixactCreation on the Standby server 📎 Andrey Borodin 18:24
Patch review marketplace Noah Misch 20:45
Re: SQL:2023 JSON simplified accessor support Jelte Fennema-Nio 23:52

June 29, 2025

Thread Author Time
Re: regdatabase Ian Lawrence Barwick 02:16
RE: Slot's restart_lsn may point to removed WAL segment after hard restart unexpectedly 📎 Hayato Kuroda (Fujitsu) 06:22
Re: Collation & ctype method table, and extension hooks Peter Eisentraut 10:43
Re: Adding support for SSLKEYLOGFILE in the frontend Peter Eisentraut 10:56
Re: [PATCH] Support for basic ALTER TABLE progress reporting. 📎 Jiří Kavalík 16:05
Re: pg_recvlogical cannot create slots with failover=true Peter Eisentraut 17:37

June 30, 2025

Thread Author Time
Re: MergeJoin beats HashJoin in the case of multiple hash clauses Tender Wang 02:38
Re: Check for existing replication slot in pg_createsubscriber Amit Kapila 03:01
Re: Check for existing replication slot in pg_createsubscriber Zane Duffield 03:07
Re: Check for existing replication slot in pg_createsubscriber Amit Kapila 03:15
Replace magic numbers with strategy numbers for B-tree indexes 📎 Daniil Davydov 03:21
Re: Check for existing replication slot in pg_createsubscriber Zane Duffield 03:23
Re: Replace magic numbers with strategy numbers for B-tree indexes Dilip Kumar 03:25
Re: pg_recvlogical cannot create slots with failover=true Masahiko Sawada 03:41
Re: pg_logical_slot_get_changes waits continously for a partial WAL record spanning across 2 pages vignesh C 04:13
Re: pg_get_multixact_members not documented Ashutosh Bapat 04:29
Typo in pg_stat_activity definition 📎 Daisuke Higuchi 04:44
Re: Typo in pg_stat_activity definition Michael Paquier 04:51
Re: Typo in pg_stat_activity definition Tom Lane 04:54
Re: Addition of %b/backend_type in log_line_prefix of TAP test logs Michael Paquier 05:12
Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options 📎 Tatsuo Ishii 05:25
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart Masahiko Sawada 05:45
Re: Make COPY format extendable: Extract COPY TO format implementations Masahiko Sawada 06:00
Re: Suggestion to add --continue-client-on-abort option to pgbench Yugo Nagata 06:02
Re: Skipping schema changes in publication Peter Smith 06:07
Re: Skipping schema changes in publication Peter Smith 06:23
Re: Fixes inconsistent behavior in vacuum when it processes multiple relations Michael Paquier 06:49
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart shveta malik 06:51
Re: AIO v2.5 📎 Antonin Houska 06:58
Re: Skipping schema changes in publication shveta malik 06:58
Re: Typo in pg_stat_activity definition Daisuke Higuchi 07:03
Re: Extend COPY FROM with HEADER <integer> to skip multiple lines Yugo Nagata 07:24
Re: Reduce "Var IS [NOT] NULL" quals during constant folding 📎 Richard Guo 07:26
Re: Error with DEFAULT VALUE in temp table 📎 Антуан Виолин 07:36
Re: Error with DEFAULT VALUE in temp table 📎 Антуан Виолин 07:46
Re: pg_logical_slot_get_changes waits continously for a partial WAL record spanning across 2 pages Dilip Kumar 07:51
Re: speedup COPY TO for partitioned table. torikoshia 07:57
Re: add function for creating/attaching hash table in DSM registry Rahila Syed 07:59
Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options Krasiyan Andreev 08:08
Re: doc: Some copy-editing around prefix operators Peter Eisentraut 08:39
Re: Prevent internal error at concurrent CREATE OR REPLACE FUNCTION 📎 Yugo Nagata 08:47
Re: Missing program_XXX calling in pgbench tests Peter Eisentraut 08:51
Re: doc: explain pgstatindex fragmentation Peter Eisentraut 09:35
Re: tab complete for COPY populated materialized view TO Fujii Masao 09:39
A concurrent VACUUM FULL? Erik Nordström 09:49
Re: Logical Replication of sequences Nisha Moond 09:50
Re: Logical Replication of sequences 📎 Nisha Moond 09:50
Re: Logical Replication of sequences Nisha Moond 09:51
Re: Logical Replication of sequences Nisha Moond 09:53
Report bytes and transactions actually sent downtream 📎 Ashutosh Bapat 09:53
Re: A concurrent VACUUM FULL? Antonin Houska 10:03
Re: [PATCH] Remove unused #include's in src/backend/utils/adt/* Peter Eisentraut 10:12
Report replica identity in pg_publication_tables Ashutosh Bapat 10:13
Re: fix: propagate M4 env variable to flex subprocess Peter Eisentraut 10:25
Re: NUMA shared memory interleaving Jakub Wartak 10:55
Re: Skipping schema changes in publication shveta malik 10:55
Re: IPC/MultixactCreation on the Standby server 📎 Andrey Borodin 10:58
Re: Conflict detection for update_deleted in logical replication Amit Kapila 11:22
Re: A concurrent VACUUM FULL? Erik Nordström 11:29
Re: Prevent internal error at concurrent CREATE OR REPLACE FUNCTION Daniil Davydov 11:32
amcheck: support for GiST 📎 Andrey Borodin 11:34
Re: track generic and custom plans in pg_stat_statements 📎 Sami Imseih 11:45
Re: A concurrent VACUUM FULL? Álvaro Herrera 11:46
Re: Report replica identity in pg_publication_tables Amit Kapila 11:46
Re: A concurrent VACUUM FULL? Erik Nordström 11:55
Re: NUMA shared memory interleaving Jakub Wartak 12:02
Re: A concurrent VACUUM FULL? Antonin Houska 12:03
Re: Report replica identity in pg_publication_tables 📎 Ashutosh Bapat 12:08
RE: pg_logical_slot_get_changes waits continously for a partial WAL record spanning across 2 pages Hayato Kuroda (Fujitsu) 12:11
Re: pg_logical_slot_get_changes waits continously for a partial WAL record spanning across 2 pages 📎 vignesh C 12:21
Re: Improve explicit cursor handling in pg_stat_statements 📎 Sami Imseih 12:37
RE: Check for existing replication slot in pg_createsubscriber Hayato Kuroda (Fujitsu) 12:43
Improve error reporting in 027_stream_regress test 📎 Nazir Bilal Yavuz 13:01
Re: pg_get_multixact_members not documented Sami Imseih 13:08
Re: Periodic FSM vacuum doesn't happen in one-pass strategy vacuum. Melanie Plageman 13:20
Re: pg_get_multixact_members not documented Nathan Bossart 13:25
RE: Conflict detection for update_deleted in logical replication 📎 Zhijie Hou (Fujitsu) 13:28
Re: add function for creating/attaching hash table in DSM registry Nathan Bossart 13:31
Adding wait events statistics 📎 Bertrand Drouvot 13:36
Re: Parallel heap vacuum 📎 Masahiko Sawada 13:40
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart Bertrand Drouvot 13:41
Re: Periodic FSM vacuum doesn't happen in one-pass strategy vacuum. Masahiko Sawada 13:41
Re: A concurrent VACUUM FULL? wenhui qiu 13:46
Re: Add 64-bit XIDs into PostgreSQL 15 📎 Maxim Orlov 14:39
Re: AIO v2.5 Andres Freund 14:44
Re: [PATCH] Fix OAuth feature detection on OpenBSD+Meson Jacob Champion 14:45
Re: Improve error reporting in 027_stream_regress test Andres Freund 15:01
array_random 📎 jian he 15:04
Re: [PATCH] Fix OAuth feature detection on OpenBSD+Meson Nazir Bilal Yavuz 15:15
Re: New function normal_rand_array function to contrib/tablefunc. jian he 15:17
Re: pg_get_multixact_members not documented Sami Imseih 15:19
Re: A concurrent VACUUM FULL? DINESH NAIR 15:23
Re: Issue with custom operator in simple case Maxim Orlov 15:49
Re: pg_get_multixact_members not documented Sami Imseih 15:56
Re: postmaster uses more CPU in 18 beta1 with io_method=io_uring Andres Freund 16:27
Re: A concurrent VACUUM FULL? Álvaro Herrera 16:37
Re: Issue with custom operator in simple case David G. Johnston 16:52
Re: ALTER TABLE ALTER CONSTRAINT misleading error message 📎 Álvaro Herrera 16:56
Re: [PoC] Federated Authn/z with OAUTHBEARER Andres Freund 16:58
Re: fix: propagate M4 env variable to flex subprocess J. Javier Maestro 17:01
Re: [PoC] Federated Authn/z with OAUTHBEARER Daniel Gustafsson 17:01
Re: Allow ON CONFLICT DO UPDATE to return EXCLUDED values 📎 Dean Rasheed 17:18
Re: Proposal to allow DELETE/UPDATE on partitioned tables with unsupported foreign partitions Shirisha Shirisha 17:24
Re: BackendKeyData is mandatory? Jacob Champion 17:58
Re: why there is not VACUUM FULL CONCURRENTLY? 📎 Antonin Houska 18:22
Re: ALTER TABLE ALTER CONSTRAINT misleading error message 📎 Álvaro Herrera 18:27
Re: [PoC] Federated Authn/z with OAUTHBEARER Jacob Champion 18:33
Re: BackendKeyData is mandatory? Jelte Fennema-Nio 18:44
Re: pgsql: Introduce pg_shmem_allocations_numa view 📎 Tomas Vondra 18:56
Re: postmaster uses more CPU in 18 beta1 with io_method=io_uring Jim Nasby 18:57
Re: Fix some inconsistencies with open-coded visibilitymap_set() callers Robert Haas 19:01
Re: Collation & ctype method table, and extension hooks Jeff Davis 19:21
Re: NUMA shared memory interleaving Tomas Vondra 19:23
Re: Improve the performance of Unicode Normalization Forms. Jeff Davis 19:28
Re: postmaster uses more CPU in 18 beta1 with io_method=io_uring Burd, Greg 19:31
GNU/Hurd portability patches 📎 Michael Banck 19:43
Re: pg_get_multixact_members not documented Nathan Bossart 19:54
Re: Tags in the commitfest app: How to use them and what tags to add? Jacob Champion 20:20
Re: pg_dump --with-* options Jeff Davis 20:28
Re: regdatabase Nathan Bossart 20:41
Re: pg_dumpall dumps global objects with --statistics-only or --no-schema Corey Huinker 20:44
Re: Tags in the commitfest app: How to use them and what tags to add? Jacob Champion 20:47
Re: Tags in the commitfest app: How to use them and what tags to add? Jelte Fennema-Nio 21:00
Re: Sanding down some edge cases for PL/pgSQL reserved words Tom Lane 21:08
back-patch documentation for age() and mxid_age() 📎 Nathan Bossart 21:33

Browse Archives

Prev | Next