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

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
Re: pg_get_multixact_members not documented Nathan Bossart 21:36
Re: Inline non-SQL SRFs using SupportRequestSimplify 📎 Paul Jungwirth 21:42
Re: BackendKeyData is mandatory? Jacob Champion 22:23
Re: [PoC] Federated Authn/z with OAUTHBEARER Daniel Gustafsson 22:52
Exposing some hidden serializable transaction costs Christophe Pettus 23:00
Re: [PoC] Federated Authn/z with OAUTHBEARER Andres Freund 23:42

July 1, 2025

Thread Author Time
Re: On disable_cost Michael Paquier 00:14
Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options Tatsuo Ishii 00:19
Re: On disable_cost Robert Haas 01:08
Fix typo in commens on ExecInsertIndexTuples 📎 Yugo Nagata 02:02
Re: back-patch documentation for age() and mxid_age() Robert Haas 02:15
Re: Fix typo in commens on ExecInsertIndexTuples Amit Langote 02:42
Re: Restrict publishing of partitioned table with a foreign table as partition Ajin Cherian 02:50
Problem with transition tables on partitioned tables with foreign-table partitions 📎 Etsuro Fujita 02:55
Re: Pathify RHS unique-ification for semijoin planning 📎 Richard Guo 02:57
Re: [WIP]Vertical Clustered Index (columnar store extension) - take2 Peter Smith 03:17
implicit casts from void* 📎 John Naylor 03:20
Re: Tags in the commitfest app: How to use them and what tags to add? Tom Lane 03:21
Re: implicit casts from void* Tom Lane 03:36
Correct comment atop PublicationPartOpt 📎 shveta malik 03:50
Re: Periodic FSM vacuum doesn't happen in one-pass strategy vacuum. 📎 Masahiko Sawada 04:01
Re: Correct comment atop PublicationPartOpt Amit Kapila 04:04
Re: pgsql: Introduce pg_shmem_allocations_numa view Bertrand Drouvot 04:06
Re: Logical Replication of sequences shveta malik 04:21
Re: Fix typo in commens on ExecInsertIndexTuples Amit Langote 04:29
Re: Typo in pg_stat_activity definition Michael Paquier 04:54
Re: Fix typo in commens on ExecInsertIndexTuples Yugo Nagata 04:54
Re: Conflict detection for update_deleted in logical replication Dilip Kumar 05:01
Re: Improve tab completion for COPY Masahiko Sawada 05:20
Re: Conflict detection for update_deleted in logical replication Dilip Kumar 05:23
Re: implicit casts from void* John Naylor 05:56
Re: CREATE INDEX CONCURRENTLY on partitioned index 📎 Alexander Pyhalov 06:43
Re: Tags in the commitfest app: How to use them and what tags to add? Jelte Fennema-Nio 07:33
Re: Problem with transition tables on partitioned tables with foreign-table partitions Amit Langote 07:42
Re: Tags in the commitfest app: How to use them and what tags to add? Daniel Gustafsson 07:52
Re: Improve error reporting in 027_stream_regress test 📎 Nazir Bilal Yavuz 07:57
Re: Add XMLNamespaces to XMLElement 📎 Jim Jones 08:01
Re: BackendKeyData is mandatory? Jelte Fennema-Nio 08:14
Re: TOAST versus toast Peter Eisentraut 08:29
Re: C11 / VS 2019 Peter Eisentraut 08:31
Re: Suggestion to add --continue-client-on-abort option to pgbench 📎 Rintaro Ikeda 08:43
Re: Adding support for SSLKEYLOGFILE in the frontend 📎 Daniel Gustafsson 08:47
Re: Conflict detection for update_deleted in logical replication Amit Kapila 08:54
Re: NUMA shared memory interleaving Jakub Wartak 09:04
Re: Conflict detection for update_deleted in logical replication Dilip Kumar 09:07
Re: mention unused_oids script in pg_proc.dat Peter Eisentraut 09:25
Re: Proposal: Global Index for PostgreSQL 📎 Dilip Kumar 09:27
Re: Cross-type index comparison support in contrib/btree_gin Arseniy Mukhin 09:35
Inconsistent LSN format in pg_waldump output 📎 Japin Li 09:45
Re: Logical Replication of sequences shveta malik 09:50
RE: Conflict detection for update_deleted in logical replication 📎 Zhijie Hou (Fujitsu) 10:09
Re: confusing message in check_tuple Peter Eisentraut 10:28
Re: Prevent internal error at concurrent CREATE OR REPLACE FUNCTION 📎 Yugo Nagata 10:47
Re: Report bytes and transactions actually sent downtream Amit Kapila 10:52
Re: back-patch documentation for age() and mxid_age() Álvaro Herrera 10:54
Re: Adding error messages to a few slash commands Dean Rasheed 11:03
Re: pgsql: Introduce pg_shmem_allocations_numa view Tomas Vondra 11:03
Re: Add 64-bit XIDs into PostgreSQL 15 📎 Evgeny Voropaev 11:08
Re: Inconsistent LSN format in pg_waldump output Álvaro Herrera 11:39
Re: Prevent internal error at concurrent CREATE OR REPLACE FUNCTION Daniil Davydov 11:56
Re: Optimize LWLock scalability via ReadBiasedLWLock for heavily-shared locks 📎 Zhou, Zhiguo 13:30
Re: Proposal: Global Index for PostgreSQL Amit Langote 13:42
Re: Add os_page_num to pg_buffercache 📎 Bertrand Drouvot 13:45
Re: Reduce "Var IS [NOT] NULL" quals during constant folding Andrei Lepikhov 13:57
Re: Optimize LWLock scalability via ReadBiasedLWLock for heavily-shared locks Andres Freund 13:57
Re: Inconsistent LSN format in pg_waldump output Japin Li 14:00
Re: NUMA shared memory interleaving Tomas Vondra 14:02
Re: Report bytes and transactions actually sent downtream Ashutosh Bapat 14:05
Re: Optimize LWLock scalability via ReadBiasedLWLock for heavily-shared locks Andres Freund 14:06
Re: implicit casts from void* Tom Lane 14:24
Re: No error checking when reading from file using zstd in pg_dump 📎 Daniel Gustafsson 14:24
Re: Report replica identity in pg_publication_tables Melih Mutlu 14:28
Re: Add os_page_num to pg_buffercache Tomas Vondra 14:31
Re: Change COPY ... ON_ERROR ignore to ON_ERROR ignore_row torikoshia 14:54
Re: Remaining dependency on setlocale() 📎 Jeff Davis 15:06

Browse Archives

Prev | Next