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

July 3, 2025

Thread Author Time
Re: BackendKeyData is mandatory? Jacob Champion 00:03
Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements 📎 Mihail Nikalayeu 00:23
Re: A assert failure when initdb with track_commit_timestamp=on Michael Paquier 00:28
Re: Reduce "Var IS [NOT] NULL" quals during constant folding Richard Guo 00:30
Re: A assert failure when initdb with track_commit_timestamp=on Fujii Masao 00:48
Re: A assert failure when initdb with track_commit_timestamp=on Michael Paquier 01:13
Re: Inconsistent LSN format in pg_waldump output Masahiko Sawada 01:16
Re: libpq: Process buffered SSL read bytes to support records >8kB on async API Merlin Moncure 01:19
RE: A assert failure when initdb with track_commit_timestamp=on Hayato Kuroda (Fujitsu) 01:30
Re: Add progressive backoff to XactLockTableWait functions Xuneng Zhou 01:30
Re: Making pg_rewind faster Japin Li 01:39
Re: Fix outdated comments for IndexInfo Japin Li 01:44
Re: MergeJoin beats HashJoin in the case of multiple hash clauses 📎 Tender Wang 02:02
Re: Extend COPY FROM with HEADER <integer> to skip multiple lines 📎 Shinya Kato 02:08
Re: PG18 protocol version 📎 Tatsuo Ishii 02:11
Re: Add progressive backoff to XactLockTableWait functions Xuneng Zhou 02:19
Re: Improve verification of recovery_target_timeline GUC. Michael Paquier 02:24
Re: Improve tab completion for COPY 📎 Masahiko Sawada 02:37
Re: Using failover slots for PG-non_PG logical replication Amit Kapila 04:02
Re: Proposal: Global Index for PostgreSQL Dilip Kumar 04:23
Re: Conflict detection for update_deleted in logical replication Dilip Kumar 04:56
Re: Problem with transition tables on partitioned tables with foreign-table partitions Etsuro Fujita 05:04
Re: Conflict detection for update_deleted in logical replication Amit Kapila 05:13
Re: Inconsistent LSN format in pg_waldump output 📎 Japin Li 05:21
Re: Conflict detection for update_deleted in logical replication Dilip Kumar 05:26
Re: PG18 protocol version Jelte Fennema-Nio 05:50
Re: BackendKeyData is mandatory? 📎 Jelte Fennema-Nio 06:13
Re: Add pg_get_injection_points() for information of injection points 📎 Michael Paquier 06:14
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart shveta malik 06:32
Re: Extend COPY FROM with HEADER <integer> to skip multiple lines Fujii Masao 06:32
Re: Using failover slots for PG-non_PG logical replication shveta malik 06:34
Re: BackendKeyData is mandatory? Jelte Fennema-Nio 06:37
Re: Extend COPY FROM with HEADER <integer> to skip multiple lines Shinya Kato 06:40
Re: Add pg_get_injection_points() for information of injection points Rahila Syed 06:44
Re: stats.sql might fail due to shared buffers also used by parallel tests Shlok Kyal 06:54
Re: Explicitly enable meson features in CI 📎 Nazir Bilal Yavuz 07:27
Re: Standardize the definition of the subtype field of AlterDomainStmt Michael Paquier 07:37
Re: Replace magic numbers with strategy numbers for B-tree indexes 📎 Daniil Davydov 07:50
Re: Inconsistent LSN format in pg_waldump output Álvaro Herrera 08:19
use radix tree for bitmap heap scan 📎 John Naylor 08:43
Re: Reduce "Var IS [NOT] NULL" quals during constant folding Andrei Lepikhov 09:08
Re: MergeJoin beats HashJoin in the case of multiple hash clauses Andrei Lepikhov 09:23
Re: ALTER TABLE ALTER CONSTRAINT misleading error message Álvaro Herrera 09:31
Re: Logical Replication of sequences shveta malik 09:37
Re: MergeJoin beats HashJoin in the case of multiple hash clauses Tender Wang 09:48
Re: CREATE DOMAIN create two not null constraints Álvaro Herrera 09:52
Re: Pathify RHS unique-ification for semijoin planning 📎 Richard Guo 10:06
Re: Inconsistent LSN format in pg_waldump output Japin Li 10:19
Re: Conflict detection for update_deleted in logical replication Amit Kapila 10:51
Re: Don't keep closed WAL segment in page cache after replay 📎 Anthonin Bonnefoy 12:57
Re: Explicitly enable meson features in CI Daniel Gustafsson 13:21
Re: Improve tab completion for COPY torikoshia 13:30
Re: A assert failure when initdb with track_commit_timestamp=on 📎 Andy Fan 13:31
Re: Using failover slots for PG-non_PG logical replication Ashutosh Bapat 13:37
Re: Explicitly enable meson features in CI Nazir Bilal Yavuz 13:50
Re: Parallelize correlated subqueries that execute within each worker Andy Fan 14:04
Re: Explicitly enable meson features in CI Daniel Gustafsson 14:06
Re: Adding basic NUMA awareness Ashutosh Bapat 14:07
Re: Prevent internal error at concurrent CREATE OR REPLACE FUNCTION 📎 Yugo Nagata 14:18
Re: pg_restore --no-policies should not restore policies' comment 📎 jian he 14:31
Re: PG 18 beta1 release notes misses mention of pg_noreturn Steve Chavez 14:38
Re: Adding basic NUMA awareness Dmitry Dolgov 14:49
Re: Invalid pointer access in logical decoding after error 📎 vignesh C 14:54
Re: add tab-complete for ALTER DOMAIN ADD... Álvaro Herrera 14:54
Re: Add tab-completion for ALTER TABLE ADD NOT NULL Álvaro Herrera 14:55
Re: Please update your contact list: It must be [email protected] Álvaro Herrera 14:58
Bloom Filter improvements in postgesql 📎 Ross Heaney 15:00
Improve error message for duplicate labels in enum types 📎 Yugo Nagata 15:04
Re: Prevent internal error at concurrent CREATE OR REPLACE FUNCTION Yugo Nagata 15:06
Re: Optimize LWLock scalability via ReadBiasedLWLock for heavily-shared locks Zhou, Zhiguo 15:38
Re: Bloom Filter improvements in postgesql David E. Wheeler 15:59
Re: libpq OpenSSL and multithreading 📎 Daniel Gustafsson 16:01
Re: Inconsistent LSN format in pg_waldump output Álvaro Herrera 16:07
Re: A assert failure when initdb with track_commit_timestamp=on Fujii Masao 16:26
Re: [HACKERS] pg_upgrade failed with error - ERROR: column "a" in child table must be marked NOT NULL 📎 Alvaro Herrera 18:53
Re: [PATCH] Fix hostaddr crash during non-blocking cancellation Tom Lane 18:54
Re: [HACKERS] pg_upgrade failed with error - ERROR: column "a" in child table must be marked NOT NULL Justin Pryzby 18:58
Re: Cross-type index comparison support in contrib/btree_gin Arseniy Mukhin 19:07
Re: Cross-type index comparison support in contrib/btree_gin Tom Lane 19:21
Re: Cross-type index comparison support in contrib/btree_gin Arseniy Mukhin 19:35
Re: [PATCH] Allow parallelism for plpgsql return expression after commit 556f7b7 Tom Lane 19:52
Re: [HACKERS] pg_upgrade failed with error - ERROR: column "a" in child table must be marked NOT NULL Alvaro Herrera 19:59
Re: Making pg_rewind faster 📎 John H 19:59
Re: [HACKERS] pg_upgrade failed with error - ERROR: column "a" in child table must be marked NOT NULL Tom Lane 20:07
Re: Cross-type index comparison support in contrib/btree_gin Tom Lane 20:31
Re: COALESCE with single argument looks like identity function Tom Lane 21:45

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

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 31