pgsql-hackers since 2025-06-26 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
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

June 26, 2025

Thread Author Time
Re: Inefficient nbtree behavior with row-comparison quals Peter Geoghegan 00:29
Re: display hot standby state in psql prompt Greg Sabino Mullane 00:52
Re: pg_logical_slot_get_changes waits continously for a partial WAL record spanning across 2 pages Michael Paquier 00:52
Re: speedup COPY TO for partitioned table. torikoshia 01:43
Re: Eager aggregation, take 3 📎 Richard Guo 02:01
RE: pg_logical_slot_get_changes waits continously for a partial WAL record spanning across 2 pages Hayato Kuroda (Fujitsu) 02:20
RE: Conflict detection for update_deleted in logical replication Zhijie Hou (Fujitsu) 03:01
RE: Conflict detection for update_deleted in logical replication 📎 Zhijie Hou (Fujitsu) 03:02
Re: Adding OLD/NEW support to RETURNING Robert Treat 03:04
Re: pg_logical_slot_get_changes waits continously for a partial WAL record spanning across 2 pages Dilip Kumar 03:18
Re: Skipping schema changes in publication Peter Smith 03:36
Re: Virtual generated columns Richard Guo 03:38
RE: Slot's restart_lsn may point to removed WAL segment after hard restart unexpectedly Hayato Kuroda (Fujitsu) 03:46
Re: Unnecessary scan from non-overlapping range predicates Ajit Awekar 04:15
Optimize LWLock scalability via ReadBiasedLWLock for heavily-shared locks 📎 Zhou, Zhiguo 05:07
DOCS: ALTER PUBLICATION - Synopsis for DROP is a bit misleading 📎 Peter Smith 05:17
Re: pgsql: Introduce pg_shmem_allocations_numa view Bertrand Drouvot 05:28
Re: Extend COPY FROM with HEADER <integer> to skip multiple lines 📎 Shinya Kato 05:35
Re: Removing unneeded self joins Michael Paquier 05:40
RE: Suggestion to add --continue-client-on-abort option to pgbench Hayato Kuroda (Fujitsu) 05:45
Re: [PATCH] Proposal: Improvements to PDF stylesheet and table column widths Tatsuo Ishii 05:57
Re: pgsql: Introduce pg_shmem_allocations_numa view Bertrand Drouvot 06:00
RE: [PATCH] Proposal: Improvements to PDF stylesheet and table column widths Hayato Kuroda (Fujitsu) 06:01
Re: pg_logical_slot_get_changes waits continously for a partial WAL record spanning across 2 pages Michael Paquier 06:17
Re: [PATCH] Proposal: Improvements to PDF stylesheet and table column widths Tatsuo Ishii 06:47
Re: Removing unneeded self joins Andrei Lepikhov 06:54
PG18 protocol version Tatsuo Ishii 06:56
Re: pg_logical_slot_get_changes waits continously for a partial WAL record spanning across 2 pages Dilip Kumar 07:01
Re: display hot standby state in psql prompt 📎 Jim Jones 07:22
Re: Extend COPY FROM with HEADER <integer> to skip multiple lines Fujii Masao 07:36
Re: PG18 protocol version 📎 Jelte Fennema-Nio 08:14
Re: Conflict detection for update_deleted in logical replication shveta malik 08:28
Re: MERGE docs: indentation in synopsis section Dean Rasheed 08:47
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart shveta malik 08:50
Re: pgsql: Introduce pg_shmem_allocations_numa view Tomas Vondra 08:53
Documentation fix on pgbench \aset command 📎 Yugo Nagata 09:01
Re: Adding OLD/NEW support to RETURNING Dean Rasheed 09:23
Re: IPC/MultixactCreation on the Standby server Dmitry 09:33
RE: pg_logical_slot_get_changes waits continously for a partial WAL record spanning across 2 pages Hayato Kuroda (Fujitsu) 09:40
Re: Suggestion to add --continue-client-on-abort option to pgbench Yugo Nagata 09:47
Re: Skipping schema changes in publication shveta malik 09:57
Re: pg_dump misses comments on NOT NULL constraints Fujii Masao 10:04
Re: Extend COPY FROM with HEADER <integer> to skip multiple lines 📎 Shinya Kato 10:12
Re: PG18 protocol version Tatsuo Ishii 10:16
[PATCH] Use binaryheap_* macro where appropriate 📎 Aleksander Alekseev 10:18
Re: PG18 protocol version Jelte Fennema-Nio 10:43
Re: pg_dump misses comments on NOT NULL constraints Fujii Masao 11:29
Re: NUMA shared memory interleaving 📎 Jakub Wartak 11:31
Re: PG18 protocol version Tatsuo Ishii 11:34
Re: NUMA shared memory interleaving 📎 Jakub Wartak 11:36
Re: pg_logical_slot_get_changes waits continously for a partial WAL record spanning across 2 pages 📎 vignesh C 11:55
Re: Remove HeapTupleheaderSetXmin{Committed,Invalid} functions Álvaro Herrera 12:06
Re: No error checking when reading from file using zstd in pg_dump 📎 Daniel Gustafsson 12:19
Re: PG18 protocol version Aleksander Alekseev 12:46
Re: IPC/MultixactCreation on the Standby server Andrey Borodin 12:59
Re: Simplify VM counters in vacuum code Melanie Plageman 13:01
Re: Proposal: Limitations of palloc inside checkpointer 📎 Xuneng Zhou 13:31
Re: PG18 protocol version Jelte Fennema-Nio 13:32
Re: No error checking when reading from file using zstd in pg_dump Tom Lane 13:33
Re: SCRAM pass-through authentication for postgres_fdw Peter Eisentraut 13:57
Re: [WIP]Vertical Clustered Index (columnar store extension) - take2 Timur Magomedov 14:11
Re: Simplify VM counters in vacuum code Masahiko Sawada 14:25
Re: Slot's restart_lsn may point to removed WAL segment after hard restart unexpectedly Alexander Korotkov 14:48
Re: Extend COPY FROM with HEADER <integer> to skip multiple lines 📎 Fujii Masao 15:03
Bug with concurrent CREATE OR REPLACE (?) Daniil Davydov 15:08
Re: SCRAM pass-through authentication for postgres_fdw 📎 Matheus Alcantara 15:10
[PATCH] Add tests for binaryheap.c 📎 Aleksander Alekseev 15:16
Re: Bug with concurrent CREATE OR REPLACE (?) Jim Jones 15:27
Re: pull-up subquery if JOIN-ON contains refs to upper-query solaimurugan vellaipandiyan 15:40
Re: Documentation fix on pgbench \aset command Fujii Masao 16:05
Re: IPC/MultixactCreation on the Standby server 📎 Andrey Borodin 16:24
Re: pg_dump misses comments on NOT NULL constraints Álvaro Herrera 16:31
Re: Documentation fix on pgbench \aset command Yugo Nagata 16:31
Re: queryId constant squashing does not support prepared statements Álvaro Herrera 16:42
Re: Documentation fix on pgbench \aset command Fujii Masao 16:45
Re: Bug with concurrent CREATE OR REPLACE (?) Tom Lane 17:05
Re: Bug with concurrent CREATE OR REPLACE (?) Daniil Davydov 17:23
Re: No error checking when reading from file using zstd in pg_dump 📎 Daniel Gustafsson 18:01
Re: Simplify VM counters in vacuum code Melanie Plageman 18:27
Re: Remove unneeded check for XLH_INSERT_ALL_FROZEN in heap_xlog_insert Melanie Plageman 19:12
[PATCH] Use DatumGetUInt32() for dsm_attach() in test_shm_mq_main() 📎 Jianghua Yang 19:51
Re: Fix some inconsistencies with open-coded visibilitymap_set() callers 📎 Melanie Plageman 19:56
Re: [PATCH] Use binaryheap_* macro where appropriate Nathan Bossart 20:16
Re: [PATCH] Use DatumGetUInt32() for dsm_attach() in test_shm_mq_main() Nathan Bossart 20:30
Re: [PATCH] Use DatumGetUInt32() for dsm_attach() in test_shm_mq_main() Jianghua Yang 20:46
Re: [PATCH] Add tests for binaryheap.c Nathan Bossart 20:46
Re: Adding support for SSLKEYLOGFILE in the frontend Peter Eisentraut 20:49
Re: Adding support for SSLKEYLOGFILE in the frontend Daniel Gustafsson 21:06
Re: [PATCH] Use DatumGetUInt32() for dsm_attach() in test_shm_mq_main() Nathan Bossart 21:34
Re: Correct documentation for protocol version 📎 Jelte Fennema-Nio 22:04
Re: eliminate xl_heap_visible to reduce WAL (and eventually set VM on-access) 📎 Melanie Plageman 22:04
[PATCH] OAuth: fix performance bug with stuck multiplexer events 📎 Jacob Champion 23:33

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

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30