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

May 28, 2025

Thread	Author	Time
Re: Clarification on warning when connecting to 'pgbouncer' database via Pgbouncer	Julien Rouhaud	00:03
Re: Fix slot synchronization with two_phase decoding enabled	Masahiko Sawada	00:40
Re: Assertion failure in smgr.c when using pg_prewarm with partitioned tables	Fujii Masao	01:10
Re: Pathify RHS unique-ification for semijoin planning 📎	Richard Guo	01:58
Re: Standardize the definition of the subtype field of AlterDomainStmt 📎	Quan Zongliang	02:26
Re: Standardize the definition of the subtype field of AlterDomainStmt	wenhui qiu	02:30
Re: Large expressions in indexes can't be stored (non-TOASTable)	Michael Paquier	02:43
Re: Speed up JSON escape processing with SIMD plus other optimisations	David Rowley	03:18
Re: queryId constant squashing does not support prepared statements	Michael Paquier	03:44
Re: Speed up JSON escape processing with SIMD plus other optimisations	John Naylor	03:49
RE: Replication slot is not able to sync up	Zhijie Hou (Fujitsu)	04:15
foreign key on virtual generated column 📎	jian he	05:13
Re: Replication slot is not able to sync up	Masahiko Sawada	06:25
Re: [PATCH] PGSERVICEFILE as part of a normal connection string	Michael Paquier	06:48
Re: finish TODOs in to_json_is_immutable, to_jsonb_is_immutable also add tests on it 📎	jian he	06:55
Re: ALTER DOMAIN ADD NOT NULL NOT VALID 📎	jian he	07:38
Foreign key validation failure in 18beta1	Antonin Houska	07:51
ALTER TABLE ALTER CONSTRAINT misleading error message	jian he	09:09
Re: ALTER TABLE ALTER CONSTRAINT misleading error message	Tender Wang	09:26
Re: Reduce "Var IS [NOT] NULL" quals during constant folding 📎	Richard Guo	09:28
Re: PG 18 release notes draft committed 📎	Dean Rasheed	09:55
Re: MERGE issues around inheritance	Dean Rasheed	10:26
Re: MERGE issues around inheritance	Tender Wang	10:37
Re: Foreign key validation failure in 18beta1	Tender Wang	10:54
Re: Standardize the definition of the subtype field of AlterDomainStmt	Peter Eisentraut	11:22
Re: Suggestion : support for environment variable in initdb to set the superuser password	Peter Eisentraut	11:26
Re: Standardize the definition of the subtype field of AlterDomainStmt	Tender Wang	11:30
Re: Add CHECK_FOR_INTERRUPTS in polling loop code path in XactLockTableWait	Fujii Masao	11:36
Re: ALTER TABLE ALTER CONSTRAINT misleading error message	Álvaro Herrera	11:59
Re: Foreign key validation failure in 18beta1	Tender Wang	12:12
Re: Foreign key validation failure in 18beta1 📎	Alvaro Herrera	12:26
Re: Foreign key validation failure in 18beta1 📎	Tender Wang	12:38
Re: wrong query results on bf leafhopper	Robins Tharakan	13:21
Re: PG 18 release notes draft committed 📎	Yugo Nagata	14:14
[PING] fallocate() causes btrfs to never compress postgresql files	Dimitrios Apostolou	14:22
Re: PG 18 release notes draft committed 📎	Yugo Nagata	14:25
Re: fix: propagate M4 env variable to flex subprocess	J. Javier Maestro	14:34
Re: wrong query results on bf leafhopper	Tom Lane	14:35
Re: pg16 && GSSAPI && Heimdal/Macos	Todd M. Kover	15:14
Re: Logical Replication of sequences	Nisha Moond	15:21
Re: [PING] fallocate() causes btrfs to never compress postgresql files	Tomas Vondra	15:27
Re: pg16 && GSSAPI && Heimdal/Macos	Tom Lane	15:53
Re: pg16 && GSSAPI && Heimdal/Macos	Jacob Champion	16:25
Re: PG 18 release notes draft committed	Bruce Momjian	16:34
Re: wrong query results on bf leafhopper	Andres Freund	17:02
Re: fix: propagate M4 env variable to flex subprocess	Andres Freund	17:08
Re: Expression push down from Join Node to below node.	Shubhankar Anand Kulkarni	18:23
Re: fix: propagate M4 env variable to flex subprocess 📎	J. Javier Maestro	18:42
Re: PG 18 release notes draft committed	Joe Conway	18:54
Re: Add CHECK_FOR_INTERRUPTS in polling loop code path in XactLockTableWait	Kevin K Biju	20:40
Re: Fixing memory leaks in postgres_fdw 📎	Tom Lane	20:56
Re: queryId constant squashing does not support prepared statements 📎	Sami Imseih	21:05
Re: pg16 && GSSAPI && Heimdal/Macos 📎	Jacob Champion	21:45
Re: pg16 && GSSAPI && Heimdal/Macos	Tom Lane	21:59
Re: pg16 && GSSAPI && Heimdal/Macos	Jacob Champion	22:01
Re: Standardize the definition of the subtype field of AlterDomainStmt 📎	Quan Zongliang	22:09
Re: Correct documentation for protocol version 📎	Dave Cramer	22:29
Re: PG 18 release notes draft committed	Bruce Momjian	22:44
Re: PG 18 release notes draft committed	Bruce Momjian	22:46
Re: Document How Commit Handles Aborted Transactions 📎	David G. Johnston	23:31

May 29, 2025

Thread	Author	Time
Re: PG 18 release notes draft committed	Melanie Plageman	00:07
Re: queryId constant squashing does not support prepared statements	Michael Paquier	02:30
Re: Assertion failure in smgr.c when using pg_prewarm with partitioned tables 📎	Masahiro Ikeda	02:46
Re: PG 18 release notes draft committed 📎	Bruce Momjian	02:49
Re: Virtual generated columns 📎	Richard Guo	03:06
Re: Replication slot is not able to sync up 📎	shveta malik	03:09
Re: Conflict detection for update_deleted in logical replication	Dilip Kumar	03:25
Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE	Fujii Masao	04:28
Re: Add AioUringCompletion in wait_event_names.txt and a safeguard in generate-wait_event_types.pl	Michael Paquier	04:31
Re: Foreign key validation failure in 18beta1	Tender Wang	04:35
Re: Add comment explaining why queryid is int64 in pg_stat_statements	Michael Paquier	04:53
backend_xmin is null in pg_stat_replication, although repl. slot change it	Pavel Stehule	05:11
Re: Clarification on warning when connecting to 'pgbouncer' database via Pgbouncer	Shaik Mohammad Mujeeb	05:20
Re: Logical Replication of sequences	Ajin Cherian	05:59
Re: [PATCH] Fix replica identity mismatch for partitioned tables with publish_via_partition_root 📎	Mikhail Kharitonov	06:30
Re: Foreign key validation failure in 18beta1 📎	jian he	07:08
Re: Persist injection points across server restarts	Rahila Syed	07:47
Re: [WIP]Vertical Clustered Index (columnar store extension) - take2 📎	Peter Smith	08:08
Warning -Wclobbered in PG_TRY(...)	m.litsarev	08:23
Re: Conflict detection for update_deleted in logical replication	shveta malik	09:00
Re: Fix slot synchronization with two_phase decoding enabled 📎	Nisha Moond	09:00
Re: Correct documentation for protocol version	Jelte Fennema-Nio	10:17
Re: Correct documentation for protocol version	Dave Cramer	11:12
Re: Warning -Wclobbered in PG_TRY(...)	Tom Lane	11:14
Re: Amcheck verification of GiST and GIN 📎	Arseniy Mukhin	11:53
Re: PG 18 release notes draft committed	Álvaro Herrera	11:53
Re: Slot's restart_lsn may point to removed WAL segment after hard restart unexpectedly	Alexander Korotkov	11:59
Re: Foreign key validation failure in 18beta1 📎	Amul Sul	12:12
Re: PG 18 release notes draft committed	Joe Conway	12:18
Re: Foreign key validation failure in 18beta1	jian he	12:26
Re: Replication slot is not able to sync up	Robert Haas	12:30
Re: Foreign key validation failure in 18beta1	Amul Sul	12:58
Re: Fixing memory leaks in postgres_fdw	Matheus Alcantara	13:07
Re: autoprewarm_dump_now 📎	Daria Shanina	13:16
Re: Fixing memory leaks in postgres_fdw	Tom Lane	13:17
Re: autoprewarm_dump_now	Tom Lane	13:21
Re: [WIP]Vertical Clustered Index (columnar store extension) - take2	Timur Magomedov	13:30
Re: PG 18 release notes draft committed	Melanie Plageman	13:42
Re: pg18: Virtual generated columns are not (yet) safe when superuser selects from them	Robert Haas	13:43
Re: autoprewarm_dump_now	Robert Haas	13:58
Re: Add comment explaining why queryid is int64 in pg_stat_statements	Nathan Bossart	14:28
POC: Carefully exposing information without authentication 📎	Greg Sabino Mullane	14:32
Re: Logical Replication of sequences 📎	vignesh C	14:39
Re: Logical Replication of sequences	vignesh C	14:41
Re: pg18: Virtual generated columns are not (yet) safe when superuser selects from them	David G. Johnston	14:43
Re: Warning -Wclobbered in PG_TRY(...) 📎	Maxim Orlov	14:45
Correcting freeze conflict horizon calculation 📎	Melanie Plageman	14:57
Re: Fixing memory leaks in postgres_fdw 📎	Tom Lane	14:59
Re: pg18: Virtual generated columns are not (yet) safe when superuser selects from them	Tom Lane	15:12
Re: Warning -Wclobbered in PG_TRY(...)	Tom Lane	15:20
Re: Warning -Wclobbered in PG_TRY(...)	Tom Lane	15:26
Re: Correcting freeze conflict horizon calculation	Peter Geoghegan	15:37
Re: [PING] fallocate() causes btrfs to never compress postgresql files	Dimitrios Apostolou	15:57
Re: PG 18 release notes draft committed 📎	Bruce Momjian	16:41
Re: Assertion failure in smgr.c when using pg_prewarm with partitioned tables	Fujii Masao	16:44
Re: Fixing memory leaks in postgres_fdw 📎	Tom Lane	17:02
Re: pg18: Virtual generated columns are not (yet) safe when superuser selects from them	Feike Steenbergen	18:01
Re: pg18: Virtual generated columns are not (yet) safe when superuser selects from them	Tom Lane	18:15
Re: pg18: Virtual generated columns are not (yet) safe when superuser selects from them	Matthias van de Meent	18:24
Re: pg18: Virtual generated columns are not (yet) safe when superuser selects from them	Tom Lane	18:30
Re: track generic and custom plans in pg_stat_statements 📎	Sami Imseih	18:55
get speed help	Dias Thomas	19:02
Re: pg18: Virtual generated columns are not (yet) safe when superuser selects from them	Matthias van de Meent	19:04
Re: track generic and custom plans in pg_stat_statements	Sami Imseih	19:07
get speed help	David G. Johnston	19:14
Re: Fix slot synchronization with two_phase decoding enabled	Masahiko Sawada	19:24
Re: Fixing memory leaks in postgres_fdw	Matheus Alcantara	20:49
Re: Improve explicit cursor handling in pg_stat_statements	Sami Imseih	21:31
Re: Extended Statistics set/restore/clear functions.	Corey Huinker	22:32
Re: [PATCH] Proposal: Improvements to PDF stylesheet and table column widths 📎	Noboru Saito	23:06
Re: Persist injection points across server restarts	Michael Paquier	23:30
Re: pg18: Virtual generated columns are not (yet) safe when superuser selects from them	Bruce Momjian	23:32
Re: Add comment explaining why queryid is int64 in pg_stat_statements	Michael Paquier	23:34
Re: Add comment explaining why queryid is int64 in pg_stat_statements	David Rowley	23:51

May 30, 2025

Thread	Author	Time
Re: Proposal: Job Scheduler	Nikolay Samokhvalov	01:17
Re: Proposal: Job Scheduler	Nikolay Samokhvalov	01:19
Re: Expression push down from Join Node to below node.	Andy Fan	01:23
Re: [WIP]Vertical Clustered Index (columnar store extension) - take2	Peter Smith	01:38
Re: Proposal: Make cfbot fail on patches not created by "git format-patch"	Ashutosh Bapat	04:18
RE: [PATCH] Proposal: Improvements to PDF stylesheet and table column widths	Hayato Kuroda (Fujitsu)	04:26
Re: Proposal: Make cfbot fail on patches not created by "git format-patch"	David G. Johnston	04:38
Re: queryId constant squashing does not support prepared statements 📎	Michael Paquier	05:03
Re: [PATCH] Proposal: Improvements to PDF stylesheet and table column widths	Noboru Saito	05:27
Re: ZStandard (with dictionaries) compression support for TOAST compression	Michael Paquier	07:20
Re: Suggestion : support for environment variable in initdb to set the superuser password	Reda Agaoua	07:21
Re: Persist injection points across server restarts	Rahila Syed	08:04
Re: Foreign key validation failure in 18beta1 📎	jian he	08:06
Re: Warning -Wclobbered in PG_TRY(...)	Maxim Orlov	08:12
Re: Replication slot is not able to sync up	Amit Kapila	08:49
Re: Correct documentation for protocol version	Jelte Fennema-Nio	09:00
Re: Proposal: Job Scheduler	Andrei Lepikhov	09:22
Re: Fix slot synchronization with two_phase decoding enabled	Nisha Moond	09:30
Re: autoprewarm_dump_now	Daria Shanina	10:07
RE: Replication slot is not able to sync up 📎	Zhijie Hou (Fujitsu)	10:07
Re: Add “FOR UPDATE NOWAIT” lock details to the log.	Peter Eisentraut	10:20
Re: Foreign key validation failure in 18beta1 📎	Amul Sul	10:31
Re: Replication slot is not able to sync up	Amul Sul	10:34
Speedup truncations of temporary relation forks 📎	Daniil Davydov	11:01
Re: Replication slot is not able to sync up	Amit Kapila	11:02
Re: Add comment explaining why queryid is int64 in pg_stat_statements	David Rowley	11:08
Re: Add comment explaining why queryid is int64 in pg_stat_statements	David Rowley	11:09
Re: Proposal: Filter irrelevant change before reassemble transactions during logical decoding 📎	Ajin Cherian	11:11
Re: Replication slot is not able to sync up	Amul Sul	11:24
Optimize shared LWLock acquisition for high-core-count systems 📎	Zhou, Zhiguo	11:30
Re: Add comment explaining why queryid is int64 in pg_stat_statements	Shaik Mohammad Mujeeb	11:34
Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE 📎	David Rowley	11:55
Re: Optimize shared LWLock acquisition for high-core-count systems	David Rowley	12:02
Reduce DEBUG level of catcache refreshing messages 📎	Jelte Fennema-Nio	12:33
Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE	Jelte Fennema-Nio	12:43
Re: Persist injection points across server restarts	Andrey Borodin	12:55
Re: Reduce DEBUG level of catcache refreshing messages	Fabrízio de Royes Mello	13:32
Re: Optimize shared LWLock acquisition for high-core-count systems	Zhou, Zhiguo	13:38
Re: Proposal: Job Scheduler	Nikolay Samokhvalov	14:11
Re: Proposal: Job Scheduler	Adam Brusselback	14:24
Re: Proposals for EXPLAIN: rename ANALYZE to EXECUTE and extend VERBOSE	Fujii Masao	14:36
Re: Reduce DEBUG level of catcache refreshing messages	Tom Lane	14:38
Re: POC: Carefully exposing information without authentication	Antonin Houska	15:02
Re: Add “FOR UPDATE NOWAIT” lock details to the log.	Fujii Masao	15:28
Re: Add CHECK_FOR_INTERRUPTS in polling loop code path in XactLockTableWait	Fujii Masao	15:31
Re: Add “FOR UPDATE NOWAIT” lock details to the log. 📎	Fujii Masao	16:12
CHECKPOINT unlogged data 📎	Christoph Berg	16:17
Re: CHECKPOINT unlogged data	Andres Freund	16:39
Re: CHECKPOINT unlogged data	Christoph Berg	16:55
Re: CHECKPOINT unlogged data	Andres Freund	17:02
Re: CHECKPOINT unlogged data	Nathan Bossart	17:07
Re: CHECKPOINT unlogged data	Christoph Berg	17:23
Re: CHECKPOINT unlogged data	Andres Freund	17:29
Re: regdatabase 📎	Nathan Bossart	18:17
Re: queryId constant squashing does not support prepared statements 📎	Sami Imseih	18:27
Re: Fixing memory leaks in postgres_fdw 📎	Tom Lane	18:31
pg_get_multixact_members not documented	Sami Imseih	19:23
RE: Review/Pull Request: Adding new CRC32C implementation for IBM S390X	Eduard Stefes	19:41
Re: regdatabase	Fabrízio de Royes Mello	20:07
Re: Large expressions in indexes can't be stored (non-TOASTable)	Nathan Bossart	20:19
Re: regdatabase	Tom Lane	20:55
Re: regdatabase	Nathan Bossart	20:59
Re: Correcting freeze conflict horizon calculation	Melanie Plageman	21:16
Re: pg_get_multixact_members not documented	Nathan Bossart	21:21
Re: pg_get_multixact_members not documented	Sami Imseih	21:24
Re: pg_get_multixact_members not documented	Nathan Bossart	21:28

Browse Archives

Prev | Next