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

July 26, 2025

Thread	Author	Time
Re: [PATCH] Avoid unnecessary code execution in Instrument.c when TIMING is FALSE	Michael Paquier	00:29
Pushing down a subquery relation's ppi_clauses, and more ...	Richard Guo	03:09
Re: Asynchronous MergeAppend 📎	Alexander Pyhalov	07:56
Re: [PATCH] Avoid unnecessary code execution in Instrument.c when TIMING is FALSE	Hironobu SUZUKI	08:16
Re: stats.sql might fail due to shared buffers also used by parallel tests 📎	Alexander Lakhin	09:00
Re: Logical replication launcher did not automatically restart when got SIGKILL	cca5507	09:27
Re: Document transition table triggers are not allowed on views/foreign tables 📎	Etsuro Fujita	11:29
Re: Fixing memory leaks in postgres_fdw	Etsuro Fujita	11:36
Re: Logical replication prefetch 📎	Konstantin Knizhnik	13:27
Re: vacuumdb changes for stats import/export	Bruce Momjian	14:22
Re: vacuumdb changes for stats import/export	David G. Johnston	14:47
Re: vacuumdb changes for stats import/export	Bruce Momjian	16:06
Re: IPC/MultixactCreation on the Standby server	Álvaro Herrera	17:44
Re: vacuumdb changes for stats import/export	Corey Huinker	19:38
Adding REPACK [concurrently] 📎	Alvaro Herrera	21:56
Re: MergeAppend could consider sorting cheapest child path 📎	Alexander Korotkov	22:51

July 27, 2025

Thread	Author	Time
Re: Adding REPACK [concurrently]	Robert Treat	01:59
Re: Logical replication launcher did not automatically restart when got SIGKILL 📎	Fujii Masao	05:06
Re: Adding REPACK [concurrently]	Fujii Masao	06:00
Re: Logical replication launcher did not automatically restart when got SIGKILL	cca5507	06:13
Re: Tab completion for large objects 📎	Fujii Masao	07:00
A little cosmetic to convert_VALUES_to_ANY() 📎	Tender Wang	07:53
Re: IndexAmRoutine aminsertcleanup function can be NULL?	Michael Paquier	08:51
Bogus bitmasking in heap2_desc 📎	Julien Rouhaud	09:19
Re: [(known) BUG] DELETE/UPDATE more than one row in partitioned foreign table	Etsuro Fujita	10:35
Re: vacuumdb changes for stats import/export	Frédéric Yhuel	10:46
Re: IPC/MultixactCreation on the Standby server	Andrey Borodin	11:53
Re: Returning nbtree posting list TIDs in DESC order during backwards scans	Andy Fan	13:42
Re: [PATCH] Let's get rid of the freelist and the buffer_strategy_lock 📎	Greg Burd	14:12
implement CAST(expr AS type FORMAT 'template') 📎	jian he	15:43
Re: Non-blocking archiver process 📎	Patrick Stählin	15:45
Re: DSA overflow in hash join	Konstantin Knizhnik	17:24
Re: XMLSerialize: version and explicit XML declaration 📎	Jim Jones	18:07
Re: implement CAST(expr AS type FORMAT 'template')	Vik Fearing	18:31
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc? 📎	Lukas Fittl	19:50
Changes in inline behavior on O2 optimization level for GCC 10+ 📎	Alexey Makhmutov	21:48
Re: Extension security improvement: Add support for extensions with an owned schema	Sadeq Dousti	22:03
Re: psql \dh: List High-Level (Root) Tables and Indexes 📎	Sadeq Dousti	23:15
Re: Custom pgstat support performance regression for simple queries	Michael Paquier	23:18
Re: Non-text mode for pg_dumpall	Noah Misch	23:56

July 28, 2025

Thread	Author	Time
Re: Extension security improvement: Add support for extensions with an owned schema	David G. Johnston	00:27
Re: Extension security improvement: Add support for extensions with an owned schema	Sadeq Dousti	00:45
Re: DOCS: What SGML markup to use for user objects like tables, columns, etc? 📎	Peter Smith	01:21
Re: speedup COPY TO for partitioned table.	torikoshia	01:22
Re: Regression with large XML data input	Michael Paquier	02:09
Re: Regression with large XML data input	Tom Lane	02:16
Re: Regression with large XML data input	Michael Paquier	02:47
Re: Regression with large XML data input	David G. Johnston	02:58
Re: Fix bug with accessing to temporary tables of other sessions 📎	Stepan Neretin	03:42
Re: [Proposal] Expose internal MultiXact member count function for efficient monitoring	Michael Paquier	04:22
RE: Add support for specifying tables in pg_createsubscriber.	Hayato Kuroda (Fujitsu)	05:07
Re: Document transition table triggers are not allowed on views/foreign tables	Ashutosh Bapat	05:14
Re: Bogus bitmasking in heap2_desc	Michael Paquier	05:27
Re: Bogus bitmasking in heap2_desc	Julien Rouhaud	05:31
Re: [Proposal] Expose internal MultiXact member count function for efficient monitoring 📎	Ashutosh Bapat	06:00
Re: track generic and custom plans in pg_stat_statements 📎	Michael Paquier	06:18
Re: [PATCH] avoid double scanning in function byteain	Stepan Neretin	06:28
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc?	Michael Paquier	06:38
Re: [PATCH] avoid double scanning in function byteain	David G. Johnston	06:41
Re: track generic and custom plans in pg_stat_statements	Andrei Lepikhov	06:41
Re: track generic and custom plans in pg_stat_statements	Michael Paquier	06:46
Re: [PATCH] avoid double scanning in function byteain	Stepan Neretin	06:57
[PATCH] avoid double scanning in function byteain	David G. Johnston	07:11
Re: track generic and custom plans in pg_stat_statements	Andrei Lepikhov	07:11
Re: Regression with large XML data input	Jim Jones	07:45
Re: Add os_page_num to pg_buffercache	Mircea Cadariu	07:52
RE: Logical Replication of sequences	Hayato Kuroda (Fujitsu)	07:56
Re: Extension security improvement: Add support for extensions with an owned schema	Jelte Fennema-Nio	08:01
Re: restore_command return code behaviour 📎	Jean-Christophe Arnu	08:01
A performance regression issue with Memoize	Richard Guo	08:13
Re: restore_command return code behaviour 📎	Jean-Christophe Arnu	08:23
Re: implement CAST(expr AS type FORMAT 'template') 📎	jian he	08:41
Re: Conflict detection for update_deleted in logical replication	Amit Kapila	09:54
Re: Logical Replication of sequences 📎	vignesh C	10:06
Re: restore_command return code behaviour	Jehan-Guillaume de Rorthais	10:32
Re: implement CAST(expr AS type FORMAT 'template')	Vik Fearing	10:47
Re: Regression with large XML data input	Erik Wienhold	10:49
Re: Conflict detection for update_deleted in logical replication	shveta malik	11:08
Re: Add progressive backoff to XactLockTableWait functions 📎	Xuneng Zhou	11:14
Re: Add progressive backoff to XactLockTableWait functions 📎	Xuneng Zhou	11:29
Re: Support getrandom() for pg_strong_random() source	Daniel Gustafsson	11:36
Re: Conflict detection for update_deleted in logical replication	shveta malik	11:43
Re: Non-text mode for pg_dumpall	Andrew Dunstan	12:04
Re: 024_add_drop_pub.pl might fail due to deadlock 📎	Ajin Cherian	12:06
Re: Explicitly enable meson features in CI	Daniel Gustafsson	12:08
Re: 024_add_drop_pub.pl might fail due to deadlock	Ajin Cherian	12:21
Re: Improve error reporting in 027_stream_regress test 📎	Nazir Bilal Yavuz	12:34
RE: POC: enable logical decoding when wal_level = 'replica' without a server restart	Hayato Kuroda (Fujitsu)	12:34
Re: Adding wait events statistics	Bertrand Drouvot	12:35
Re: IPC/MultixactCreation on the Standby server 📎	Andrey Borodin	12:49
Re: ICU warnings during make installcheck and text_extensions test 📎	Alexander Korotkov	13:04
Re: PG 18 beta1 release notes misses mention of pg_noreturn	Daniel Gustafsson	13:06
Re: Explicitly enable meson features in CI	Andrew Dunstan	13:27
Re: Pushing down a subquery relation's ppi_clauses, and more ...	Andrei Lepikhov	13:29
Re: [PING] [PATCH v2] parallel pg_restore: avoid disk seeks when jumping short distance forward	Dimitrios Apostolou	13:34
Re: [PATCH] avoid double scanning in function byteain	Tom Lane	13:58
Re: libxml2 author overwhelmed with security requests	Bruce Momjian	14:13
Re: libxml2 author overwhelmed with security requests	Tom Lane	14:15
Re: Adding basic NUMA awareness 📎	Tomas Vondra	14:19
Re: vacuumdb changes for stats import/export	Nathan Bossart	14:47
Making pgfdw_report_error statically analyzable	Tom Lane	14:54
Re: vacuumdb changes for stats import/export	Frédéric Yhuel	15:09
Re: restore_command return code behaviour 📎	Jean-Christophe Arnu	15:18
Re: Better HINT message for "unexpected data beyond EOF"	Robert Haas	15:22
Re: Support getrandom() for pg_strong_random() source	Jacob Champion	15:29
Re: Explicitly enable meson features in CI	Jacob Champion	16:03
Re: roles management problem after upgrading in PG 17	Bruce Momjian	16:11
Re: roles management problem after upgrading in PG 17	Bruce Momjian	16:12
Re: Support getrandom() for pg_strong_random() source	Daniel Gustafsson	16:14
Re: vacuumdb changes for stats import/export	David G. Johnston	16:22
Re: MultiXact\SLRU buffers configuration	Andrey Borodin	17:23
Re: Explicitly enable meson features in CI	Andres Freund	17:47
Re: restore_command return code behaviour	Jacob Champion	18:14
Re: Explicitly enable meson features in CI	Jacob Champion	18:20
Re: Changes in inline behavior on O2 optimization level for GCC 10+	Peter Geoghegan	18:27
Re: Regression with large XML data input	Tom Lane	18:28
Re: vacuumdb changes for stats import/export	Nathan Bossart	18:34
Re: Doc update proposal for the note on log_statement in the runtime config for logging page	Bruce Momjian	18:37
Re: Better HINT message for "unexpected data beyond EOF"	Nathan Bossart	18:42
Re: vacuumdb changes for stats import/export	Nathan Bossart	18:46
Re: PG 18 beta1 release notes misses mention of pg_noreturn	Bruce Momjian	18:54
Re: More protocol.h replacements this time into walsender.c 📎	Dave Cramer	19:15
Re: Make COPY format extendable: Extract COPY TO format implementations	Masahiko Sawada	19:33
Re: should we have a fast-path planning for OLTP starjoins? 📎	Tomas Vondra	19:44
Re: refactor backend type lists 📎	Euler Taveira	19:53
Re: Making pgfdw_report_error statically analyzable	Robert Haas	20:01
Re: Making pgfdw_report_error statically analyzable	Tom Lane	20:08
Re: Regression with large XML data input 📎	Tom Lane	20:16
Re: [PING] fallocate() causes btrfs to never compress postgresql files	Dimitrios Apostolou	20:41
Re: [PATCH] OAuth: fix performance bug with stuck multiplexer events 📎	Jacob Champion	20:52
Re: track generic and custom plans in pg_stat_statements	Sami Imseih	20:57
Re: [WIP]Vertical Clustered Index (columnar store extension) - take2 📎	Peter Smith	20:57
Re: restore_command return code behaviour	Jean-Christophe Arnu	20:57
Re: [WIP]Vertical Clustered Index (columnar store extension) - take2	Peter Smith	21:00
Re: track generic and custom plans in pg_stat_statements	Sami Imseih	21:02
Re: [WIP]Vertical Clustered Index (columnar store extension) - take2	Peter Smith	21:03
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart	Masahiko Sawada	21:11
Re: [Patch] add new parameter to pg_replication_origin_session_setup	Doruk Yilmaz	21:13
Re: refactor backend type lists 📎	Álvaro Herrera	21:13
Re: restore_command return code behaviour	Jacob Champion	21:21
Re: Making pgfdw_report_error statically analyzable	Álvaro Herrera	21:25
Re: Making pgfdw_report_error statically analyzable	Tom Lane	21:30
Re: A performance regression issue with Memoize	David Rowley	21:30
Re: restore_command return code behaviour	David G. Johnston	21:42
Re: restore_command return code behaviour	Jacob Champion	21:58
Re: restore_command return code behaviour	David G. Johnston	22:38
Re: Unnecessary delay in streaming replication due to replay lag	Huansong Fu	22:41
Re: Doc update proposal for the note on log_statement in the runtime config for logging page	Daniel Bauman	23:24
Re: Doc update proposal for the note on log_statement in the runtime config for logging page	Bruce Momjian	23:35
Re: Doc update proposal for the note on log_statement in the runtime config for logging page	David G. Johnston	23:53

July 29, 2025

Thread	Author	Time
Re: Proposal: QUALIFY clause	Matheus Alcantara	00:10
Re: Doc update proposal for the note on log_statement in the runtime config for logging page	Daniel Bauman	00:27
Re: Proposal: QUALIFY clause	David Rowley	00:46
Re: Regression with large XML data input	Michael Paquier	01:23
Re: Support getrandom() for pg_strong_random() source	Michael Paquier	01:30
Re: Improve error reporting in 027_stream_regress test	Michael Paquier	01:46
RE: 024_add_drop_pub.pl might fail due to deadlock	Hayato Kuroda (Fujitsu)	01:53
Re: Improve error reporting in 027_stream_regress test	Andres Freund	01:56
Broken ./configure checks for __cpuid() and __cpuidex()	Michael Paquier	02:21
Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc?	Michael Paquier	02:30
Re: Broken ./configure checks for __cpuid() and __cpuidex() 📎	Michael Paquier	02:36
Re: PG 18 beta1 release notes misses mention of pg_noreturn	Michael Paquier	02:52
Re: Broken ./configure checks for __cpuid() and __cpuidex()	Tom Lane	03:01
Re: Broken ./configure checks for __cpuid() and __cpuidex()	Michael Paquier	03:07
Re: Bogus bitmasking in heap2_desc	Michael Paquier	03:07
Re: 024_add_drop_pub.pl might fail due to deadlock	Amit Kapila	03:13
Re: implement CAST(expr AS type FORMAT 'template') 📎	jian he	03:13
Re: Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment	David Rowley	03:25
Re: Broken ./configure checks for __cpuid() and __cpuidex()	Tom Lane	03:40
Re: Broken ./configure checks for __cpuid() and __cpuidex()	Lukas Fittl	03:53
Re: implement CAST(expr AS type FORMAT 'template')	David G. Johnston	03:54
Re: Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment	Lukas Fittl	03:59
Re: Improve error reporting in 027_stream_regress test	Alexander Lakhin	04:00
Re: A performance regression issue with Memoize	Richard Guo	04:01
Re: A performance regression issue with Memoize	David Rowley	04:30
Re: Improve error reporting in 027_stream_regress test	Tom Lane	04:41
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart	vignesh C	04:44
delimiter inconsistency in generate-wait_event_types.pl 📎	Kyotaro Horiguchi	04:56
Re: A performance regression issue with Memoize	Tom Lane	04:57
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart	shveta malik	05:02
Re: SQL Property Graph Queries (SQL/PGQ)	Ashutosh Bapat	05:03
Re: Support tid range scan in parallel? 📎	David Rowley	05:11
Re: [Patch] add new parameter to pg_replication_origin_session_setup	Amit Kapila	05:13
Re: Make COPY format extendable: Extract COPY TO format implementations	Masahiko Sawada	05:19
RE: Conflict detection for update_deleted in logical replication 📎	Zhijie Hou (Fujitsu)	05:20
RE: Conflict detection for update_deleted in logical replication	Zhijie Hou (Fujitsu)	05:21
Re: Broken ./configure checks for __cpuid() and __cpuidex() 📎	Michael Paquier	05:30
Re: Improve error reporting in 027_stream_regress test 📎	Michael Paquier	06:06
Re: split func.sgml to separated individual sgml files	jian he	06:15
Re: Improve error reporting in 027_stream_regress test	Nazir Bilal Yavuz	06:33
Re: IPC/MultixactCreation on the Standby server	Dmitry	06:36
Re: Improve error reporting in 027_stream_regress test	Nazir Bilal Yavuz	06:45
Re: [PING] fallocate() causes btrfs to never compress postgresql files	Magnus Hagander	06:52
Re: IPC/MultixactCreation on the Standby server	Dmitry	07:17
Re: Broken ./configure checks for __cpuid() and __cpuidex()	Lukas Fittl	07:21
pg_basebackup and pg_switch_wal()	Fabrice Chapuis	07:48
Re: delimiter inconsistency in generate-wait_event_types.pl 📎	Daniel Gustafsson	08:08
Re: A performance regression issue with Memoize	Andrei Lepikhov	08:52
Making WAL archiving faster — multi-file support and async ideas 📎	Stepan Neretin	08:56
Re: 024_add_drop_pub.pl might fail due to deadlock 📎	Ajin Cherian	09:16

Browse Archives

Prev | Next