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

Thread	Author	Time
Re: Changing shared_buffers without restart 📎	Tomas Vondra	00:06
Re: Speedup truncations of temporary relation forks	Fujii Masao	00:10
Re: parallel safety of correlated subquery	Andy Fan	00:26
Re: Pathify RHS unique-ification for semijoin planning	Richard Guo	01:41
Re: Improve error message for duplicate labels in enum types	Rahila Syed	02:12
Re: Inconsistent LSN format in pg_waldump output 📎	Japin Li	02:32
Re: Making pg_rewind faster	Japin Li	02:48
Re: Speedup truncations of temporary relation forks	Daniil Davydov	03:13
Re: Prevent internal error at concurrent CREATE OR REPLACE FUNCTION	Daniil Davydov	03:48
Re: Using failover slots for PG-non_PG logical replication	Amit Kapila	03:53
Fix deprecation warning with libxml2 2.14 in contrib/xml2/ 📎	Michael Paquier	04:03
Re: Fix deprecation warning with libxml2 2.14 in contrib/xml2/	Michael Paquier	04:36
Re: Fix deprecation warning with libxml2 2.14 in contrib/xml2/	Tom Lane	04:44
Re: Restrict publishing of partitioned table with a foreign table as partition 📎	Shlok Kyal	05:03
Re: proposal: plpgsql, new check for extra_errors - strict_expr_check 📎	Pavel Stehule	05:11
Re: Emitting JSON to file using COPY TO 📎	jian he	05:27
Re: [PATCH] Allow parallelism for plpgsql return expression after commit 556f7b7	Dilip Kumar	05:33
Re: Avoid possible dereference null pointer (contrib/postgres_fdw/postgres_fdw.c)	Etsuro Fujita	05:41
Re: TOAST versus toast	Peter Smith	05:44
Re: Improve error message for duplicate labels in enum types	Yugo Nagata	05:48
Re: Prevent internal error at concurrent CREATE OR REPLACE FUNCTION	Yugo Nagata	05:58
Re: [WIP]Vertical Clustered Index (columnar store extension) - take2	Japin Li	05:58
Re: A assert failure when initdb with track_commit_timestamp=on	Michael Paquier	06:13
Re: Add pg_get_injection_points() for information of injection points	Michael Paquier	06:29
Re: Conflict detection for update_deleted in logical replication	Dilip Kumar	06:31
Non-blocking archiver process	Ronan Dunklau	06:46
Re: Adding pg_dump flag for parallel export to pipes	Hannu Krosing	07:12
Re: Fix deprecation warning with libxml2 2.14 in contrib/xml2/	Jim Jones	07:12
RE: A assert failure when initdb with track_commit_timestamp=on	Hayato Kuroda (Fujitsu)	07:29
Re: Explicitly enable meson features in CI 📎	Nazir Bilal Yavuz	07:33
amcheck: Remove unused IndexCheckableCallback typedef 📎	Fujii Masao	07:50
Re: Inconsistent LSN format in pg_waldump output	Álvaro Herrera	08:10
Re: amcheck: Remove unused IndexCheckableCallback typedef	Andrey Borodin	08:25
Re: Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment 📎	Ilia Evdokimov	08:30
Re: Add 64-bit XIDs into PostgreSQL 15	Andrey Borodin	08:31
Assertion failure during initdb with transaction_timeout set	Fujii Masao	08:37
Re: A assert failure when initdb with track_commit_timestamp=on	Fujii Masao	08:45
Re: Add progressive backoff to XactLockTableWait functions	Xuneng Zhou	08:57
Wrong off type in smgrfd and mdfd 📎	邱宇航	09:22
Re: Add 64-bit XIDs into PostgreSQL 15	Yura Sokolov	09:25
Remove unused wait_event_info parameter in FileStartReadV() 📎	Bertrand Drouvot	09:46
Re: Remove unused wait_event_info parameter in FileStartReadV()	Aleksander Alekseev	10:16
Re: Logical Replication of sequences 📎	vignesh C	10:23
Re: Remove unused wait_event_info parameter in FileStartReadV()	Bertrand Drouvot	10:54
Re: Support for 8-byte TOAST values (aka the TOAST infinite loop problem)	Hannu Krosing	11:03
Re: Adding basic NUMA awareness	Jakub Wartak	11:05
RE: Conflict detection for update_deleted in logical replication 📎	Zhijie Hou (Fujitsu)	11:18
Re: Assertion failure in smgr.c when using pg_prewarm with partitioned tables 📎	Fujii Masao	11:32
Re: Support for 8-byte TOAST values (aka the TOAST infinite loop problem)	Nikita Malakhov	11:38
Re: alter check constraint enforceability 📎	jian he	11:59
Re: Binary operators for cubes	Kirill Panin	12:07
Re: cpluspluscheck vs ICU again	Andres Freund	12:39
RE: Suggestion to add --continue-client-on-abort option to pgbench	Hayato Kuroda (Fujitsu)	13:01
Re: Explicitly enable meson features in CI	Daniel Gustafsson	13:18
Re: Improve verification of recovery_target_timeline GUC.	David Steele	13:39
Re: Using failover slots for PG-non_PG logical replication 📎	Ashutosh Bapat	14:12
Re: POC: Parallel processing of indexes in autovacuum	Matheus Alcantara	14:21
Re: PG 18 beta1 release notes misses mention of pg_noreturn	Ashutosh Bapat	14:23
Re: amcheck: Remove unused IndexCheckableCallback typedef	Fujii Masao	14:29
Re: Changing shared_buffers without restart	Dmitry Dolgov	14:41
Re: Report replica identity in pg_publication_tables	Ashutosh Bapat	14:46
Re: Assertion failure during initdb with transaction_timeout set	Tom Lane	14:47
Re: Suggestion to add --continue-client-on-abort option to pgbench	Yugo Nagata	15:03
Re: cpluspluscheck vs ICU again	Tom Lane	15:11
Re: Suggestion to add --continue-client-on-abort option to pgbench	Yugo Nagata	15:22
Re: Changing shared_buffers without restart	Tomas Vondra	15:23
Re: A assert failure when initdb with track_commit_timestamp=on	Tom Lane	15:30
Re: Bloom Filter improvements in postgesql	Ross Heaney	15:42
Re: A assert failure when initdb with track_commit_timestamp=on	Fujii Masao	15:57
Re: Metadata and record block access stats for indexes 📎	Mircea Cadariu	16:00
Re: Assertion failure during initdb with transaction_timeout set	Fujii Masao	16:00
Re: Add progressive backoff to XactLockTableWait functions	Fujii Masao	16:14
Re: [HACKERS] pg_upgrade failed with error - ERROR: column "a" in child table must be marked NOT NULL	Álvaro Herrera	16:20
Re: [HACKERS] pg_upgrade failed with error - ERROR: column "a" in child table must be marked NOT NULL	Alvaro Herrera	16:21
Re: [PATCH] Allow parallelism for plpgsql return expression after commit 556f7b7	Tom Lane	16:26
Re: Add progressive backoff to XactLockTableWait functions	Andres Freund	16:36
Re: [HACKERS] pg_upgrade failed with error - ERROR: column "a" in child table must be marked NOT NULL	Alvaro Herrera	16:45
Re: A assert failure when initdb with track_commit_timestamp=on 📎	Tom Lane	17:17
Re: [HACKERS] pg_upgrade failed with error - ERROR: column "a" in child table must be marked NOT NULL 📎	Alvaro Herrera	17:19
Re: Bloom Filter improvements in postgesql	Matthias van de Meent	17:25
Re: [HACKERS] pg_upgrade failed with error - ERROR: column "a" in child table must be marked NOT NULL	Tom Lane	17:37
Re: Adding basic NUMA awareness	Tomas Vondra	18:12
Re: stats.sql might fail due to shared buffers also used by parallel tests	Alexander Lakhin	20:00

July 5, 2025

Thread	Author	Time
walwriter can set XLP_BKP_REMOVABLE wrongly: race w/ backup start 📎	Noah Misch	00:16
Re: Support for 8-byte TOAST values (aka the TOAST infinite loop problem)	Michael Paquier	01:11
Re: A assert failure when initdb with track_commit_timestamp=on	Michael Paquier	01:21
Re: A assert failure when initdb with track_commit_timestamp=on	Tom Lane	02:24
Re: Non-blocking archiver process	Noah Misch	03:01
Re: array_random 📎	jian he	03:35
Re: Get rid of WALBufMappingLock 📎	Noah Misch	04:15
Re: [PATCH] Allow parallelism for plpgsql return expression after commit 556f7b7	Dilip Kumar	05:26
Re: Adding basic NUMA awareness - Preliminary feedback and outline for an extensible approach	Cédric Villemain	07:09
Re: array_random	Vik Fearing	07:32
Re: [HACKERS] pg_upgrade failed with error - ERROR: column "a" in child table must be marked NOT NULL	Alvaro Herrera	08:07
Re: Conflict detection for update_deleted in logical replication	Dilip Kumar	08:56
Re: Adding support for SSLKEYLOGFILE in the frontend	Peter Eisentraut	08:56
Buildfarm animal prion can't complete tests in 4 hours nowadays	Alexander Lakhin	09:00
NegotiateProtocolVersion description	Tatsuo Ishii	10:30
Re: Changing shared_buffers without restart	Dmitry Dolgov	10:35
Re: Conflict detection for update_deleted in logical replication	Dilip Kumar	11:21
Re: Add \pset options for boolean value display	Vik Fearing	12:41
Re: Inconsistent LSN format in pg_waldump output	Masahiko Sawada	14:01
Re: Bloom Filter improvements in postgesql	Ross Heaney	14:18
Re: NegotiateProtocolVersion description	David G. Johnston	14:48
Re: Buildfarm animal prion can't complete tests in 4 hours nowadays	Andrew Dunstan	15:16
Re: NegotiateProtocolVersion description	Fujii Masao	15:18
024_add_drop_pub.pl might fail due to deadlock	Alexander Lakhin	16:00
Re: A assert failure when initdb with track_commit_timestamp=on	Fujii Masao	16:57
Re: [PATCH] initdb: Treat empty -U argument as unset username	Jianghua Yang	16:58
Re: A assert failure when initdb with track_commit_timestamp=on	Tom Lane	17:23
Re: [PATCH] initdb: Treat empty -U argument as unset username	Tom Lane	17:34
Re: Trim the heap free memory	shawn wang	17:47
Re: A assert failure when initdb with track_commit_timestamp=on 📎	Tom Lane	18:00
Re: amcheck support for BRIN indexes 📎	Arseniy Mukhin	20:19
Re: NegotiateProtocolVersion description	Tatsuo Ishii	22:07
Re: NegotiateProtocolVersion description	Tatsuo Ishii	22:08
Re: C11 / VS 2019	Tom Lane	22:27

July 6, 2025

Thread	Author	Time
Adding support for Row Compares to nbtree startikey optimization 📎	Peter Geoghegan	02:19
Re: POC: Parallel processing of indexes in autovacuum 📎	Daniil Davydov	08:00
Re: Avoid possible dereference null pointer (contrib/postgres_fdw/postgres_fdw.c)	Etsuro Fujita	08:29
Instability of pg_walsummary/002_blocks.pl due to timing	Alexander Lakhin	09:00
Re: Proposal to allow DELETE/UPDATE on partitioned tables with unsupported foreign partitions	Etsuro Fujita	09:04
RE: Conflict detection for update_deleted in logical replication	Hayato Kuroda (Fujitsu)	11:03
Re: [PATCH] Extending FK check skipping on replicas to ADD FK and TRUNCATE 📎	Hannu Krosing	11:48
Re: Horribly slow pg_upgrade performance with many Large Objects	Hannu Krosing	12:48
Re: Changing shared_buffers without restart	Dmitry Dolgov	13:01
Re: Changing shared_buffers without restart	Dmitry Dolgov	13:21
Re: [PATCH] Extending FK check skipping on replicas to ADD FK and TRUNCATE 📎	Hannu Krosing	14:30
Re: [PATCH] Extending FK check skipping on replicas to ADD FK and TRUNCATE 📎	Hannu Krosing	14:48
Re: Conflict detection for update_deleted in logical replication	Masahiko Sawada	14:50
Re: Conflict detection for update_deleted in logical replication	Masahiko Sawada	14:50
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart	Masahiko Sawada	15:03
Re: SQL Property Graph Queries (SQL/PGQ) 📎	Hannu Krosing	16:10
Re: [PATCH] Add support for displaying database service in psql prompt	Noah Misch	16:13
Re: Issues with 2PC at recovery: CLOG lookups and GlobalTransactionData	Noah Misch	18:07
Re: What is a typical precision of gettimeofday()? 📎	Hannu Krosing	18:22
Re: A recent message added to pg_upgade	Tom Lane	18:26
Set 1s WaitLatch timeout if standby limit has expired in ResolveRecoveryConflictWithBufferPin 📎	Anthony Hsu	18:55
Re: amcheck support for BRIN indexes 📎	Arseniy Mukhin	18:59
Re: amcheck support for BRIN indexes	Álvaro Herrera	19:49
Re: pgbench - adding pl/pgsql versions of tests 📎	Hannu Krosing	21:52
Re: Get rid of WALBufMappingLock	Alexander Korotkov	22:48

July 7, 2025

Thread	Author	Time
Re: Instability of pg_walsummary/002_blocks.pl due to timing 📎	Michael Paquier	00:18
Re: [WIP]Vertical Clustered Index (columnar store extension) - take2	Peter Smith	00:19
Re: Fix deprecation warning with libxml2 2.14 in contrib/xml2/	Michael Paquier	00:20
Saving stack space in nbtree's _bt_first function 📎	Peter Geoghegan	00:22
Re: [PATCH] Add support for displaying database service in psql prompt 📎	Michael Paquier	02:06
Re: Making pg_rewind faster	wenhui qiu	02:11
RE: Conflict detection for update_deleted in logical replication	Zhijie Hou (Fujitsu)	02:12
Re: support ALTER COLUMN SET EXPRESSION over virtual generated column with check constraint 📎	jian he	02:24
Re: [PATCH] Add support for displaying database service in psql prompt	Noah Misch	03:00
RE: Conflict detection for update_deleted in logical replication	Zhijie Hou (Fujitsu)	03:03
Documenting inlining SQL functions 📎	Paul Jungwirth	03:11
RE: Conflict detection for update_deleted in logical replication	Hayato Kuroda (Fujitsu)	03:29
Re: Issues with 2PC at recovery: CLOG lookups and GlobalTransactionData	Michael Paquier	04:16
Re: A recent message added to pg_upgade	Dilip Kumar	04:17
Re: Using failover slots for PG-non_PG logical replication 📎	shveta malik	04:22
Re: Instability of pg_walsummary/002_blocks.pl due to timing	Alexander Lakhin	05:00
Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options 📎	Tatsuo Ishii	05:37
Re: A recent message added to pg_upgade 📎	Dilip Kumar	05:40
Re: cpluspluscheck vs ICU again 📎	John Naylor	05:52
Re: Adding wait events statistics	Michael Paquier	05:56
Small optimization with expanding dynamic hash table 📎	cca5507	06:00
Re: Avoid circular header file dependency	John Naylor	06:58
Re: Avoid circular header file dependency	Michael Paquier	07:04
Move the injection_points extension to contrib?	Antonin Houska	07:04
Re: Binary operators for cubes	Dean Rasheed	07:29
Re: Consider explicit incremental sort for Append and MergeAppend 📎	Richard Guo	07:37
Re: array_random	Dean Rasheed	07:53
Re: Add 64-bit XIDs into PostgreSQL 15 📎	Evgeny Voropaev	08:17
Re: meson vs. llvm bitcode files 📎	Nazir Bilal Yavuz	08:45
RE: Move the injection_points extension to contrib?	Hayato Kuroda (Fujitsu)	09:02
Re: Logical Replication of sequences	shveta malik	09:07
Re: Proposal to allow DELETE/UPDATE on partitioned tables with unsupported foreign partitions	Shirisha Shirisha	09:46
Re: Add 64-bit XIDs into PostgreSQL 15	Yura Sokolov	09:49
Re: Logical Replication of sequences	shveta malik	10:00
Re: Limiting overshoot in nbtree's parallel SAOP index scans	Matthias van de Meent	10:12
Re: 024_add_drop_pub.pl might fail due to deadlock	Ajin Cherian	10:15
RE: Conflict detection for update_deleted in logical replication	Zhijie Hou (Fujitsu)	10:21
RE: Conflict detection for update_deleted in logical replication 📎	Zhijie Hou (Fujitsu)	10:31
Re: Allow ON CONFLICT DO UPDATE to return EXCLUDED values	Jim Jones	10:38
Re: [PATCH] Hex-coding optimizations using SVE on ARM. 📎	[email protected]	10:41
Re: C11 / VS 2019	Peter Eisentraut	10:51
Re: amcheck support for BRIN indexes 📎	Arseniy Mukhin	11:06
Re: Changing shared_buffers without restart	Tomas Vondra	11:57
Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements	Sergey Sargsyan	12:00
Re: Adding basic NUMA awareness - Preliminary feedback and outline for an extensible approach	Tomas Vondra	12:01
Re: amcheck support for BRIN indexes	Tomas Vondra	12:10
Re: Inconsistent LSN format in pg_waldump output	Álvaro Herrera	12:18
Re: amcheck support for BRIN indexes	Álvaro Herrera	12:21
Re: Adding basic NUMA awareness	Jakub Wartak	12:31
Re: [PATCH] Fix OAuth feature detection on OpenBSD+Meson 📎	Nazir Bilal Yavuz	12:41
Re: analyze-in-stages post upgrade questions	Mircea Cadariu	12:43
Re: Changing shared_buffers without restart	Dmitry Dolgov	13:06
Re: C11 / VS 2019	Nazir Bilal Yavuz	13:19
Re: Using failover slots for PG-non_PG logical replication 📎	Ashutosh Bapat	13:30
Re: Consider explicit incremental sort for Append and MergeAppend 📎	Andrei Lepikhov	13:38
Re: Changing shared_buffers without restart	Ashutosh Bapat	13:42
Re: Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment	Andrei Lepikhov	13:49
Re: Changing shared_buffers without restart	Dmitry Dolgov	13:58

Browse Archives

Prev | Next