pgsql-hackers since 2025-06-02 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 2, 2025

Thread	Author	Time
Re: pgsql: postgres_fdw: Inherit the local transaction's access/deferrable	Fujii Masao	03:03
Re: ALTER TABLE ALTER CONSTRAINT misleading error message 📎	jian he	03:13
Re: CREATE DOMAIN create two not null constraints	jian he	03:15
Re: Foreign key validation failure in 18beta1 📎	Amul Sul	03:26
Re: pgsql: postgres_fdw: Inherit the local transaction's access/deferrable	Michael Paquier	03:33
C11 / VS 2019	Peter Eisentraut	03:44
Re: Speedup truncations of temporary relation forks	Fujii Masao	03:45
Re: Speedup truncations of temporary relation forks	Dilip Kumar	04:14
Re: Review/Pull Request: Adding new CRC32C implementation for IBM S390X	John Naylor	04:48
Suggestions for improving \conninfo output in v18	Fujii Masao	04:48
Re: Add AioUringCompletion in wait_event_names.txt and a safeguard in generate-wait_event_types.pl	Bertrand Drouvot	04:59
Re: Suggestions for improving \conninfo output in v18	David G. Johnston	05:24
SQL:2011 Application Time Update & Delete 📎	Paul Jungwirth	05:24
Re: Fix slot synchronization with two_phase decoding enabled	Amit Kapila	05:25
Re: Virtual generated columns	jian he	05:30
Re: Add “FOR UPDATE NOWAIT” lock details to the log.	Peter Eisentraut	05:42
Re: Non-reproducible AIO failure 📎	Alexander Lakhin	06:00
Re: Batch TIDs lookup in ambulkdelete	John Naylor	06:01
Re: Speedup truncations of temporary relation forks	Daniil Davydov	06:23
Re: Conflict detection for update_deleted in logical replication	Amit Kapila	06:39
Re: Suggestions for improving \conninfo output in v18 📎	Fujii Masao	06:39
tab complete for ALTER TABLE ALTER CONSTRAINT 📎	jian he	06:49
Re: SQL:2011 application time	Peter Eisentraut	07:31
Re: Assertion failure in smgr.c when using pg_prewarm with partitioned tables 📎	Masahiro Ikeda	07:32
Re: [PING] fallocate() causes btrfs to never compress postgresql files	Jakub Wartak	07:49
Re: Missing pg_depend entries for constraints created by extensions (deptype 'e') 📎	Joel Jacobson	08:13
Re: Speedup truncations of temporary relation forks	Yura Sokolov	09:06
Re: Logical Replication of sequences	shveta malik	09:24
Re: support fast default for domain with constraints 📎	jian he	09:56
Re: [PING] fallocate() causes btrfs to never compress postgresql files	Dimitrios Apostolou	10:14
Re: Slot's restart_lsn may point to removed WAL segment after hard restart unexpectedly	Amit Kapila	11:53
Re: Proposal for enabling auto-vectorization for checksum calculations	John Naylor	12:11
Re: [PING] fallocate() causes btrfs to never compress postgresql files	Thomas Munro	12:35
Re: Suggestions for improving \conninfo output in v18	David G. Johnston	12:53
Re: RFC: Logging plan of the running query 📎	torikoshia	12:56
Re: [PING] fallocate() causes btrfs to never compress postgresql files	Bruce Momjian	13:14
Re: SQL:2011 application time	Tom Lane	13:50
Re: C11 / VS 2019	Nathan Bossart	13:52
alter check constraint enforceability 📎	jian he	13:57
Re: [PING] fallocate() causes btrfs to never compress postgresql files	Dimitrios Apostolou	13:57
Re: Avoid orphaned objects dependencies, take 3	Bertrand Drouvot	14:02
Re: Avoid orphaned objects dependencies, take 3	Bertrand Drouvot	14:06
fix notes about password encryption in pg_authid docs	Nathan Bossart	14:16
Re: Suggestion to add --continue-client-on-abort option to pgbench	ikedarintarof	14:21
Re: fix notes about password encryption in pg_authid docs 📎	Nathan Bossart	14:21
Re: RelationGetNumberOfBlocks called before vacuum_get_cutoffs 📎	Melanie Plageman	14:27
Re: RelationGetNumberOfBlocks called before vacuum_get_cutoffs	Peter Geoghegan	14:30
Re: Suggestion to add --continue-client-on-abort option to pgbench 📎	ikedarintarof	14:36
Re: RelationGetNumberOfBlocks called before vacuum_get_cutoffs	Melanie Plageman	14:56
pg_upgrade: warn about roles with md5 passwords 📎	Nathan Bossart	15:32
Re: track generic and custom plans in pg_stat_statements 📎	Sami Imseih	15:52
Re: Vacuum statistics	Alexander Korotkov	16:25
Re: Foreign key validation failure in 18beta1 📎	Alvaro Herrera	16:26
Re: pg_upgrade: warn about roles with md5 passwords	Jeff Davis	16:45
Re: Improve hash join's handling of tuples with null join keys 📎	Tom Lane	16:47
Re: Vacuum statistics	Alena Rybakina	16:50
Re: pg_upgrade: warn about roles with md5 passwords	Nathan Bossart	17:04
Re: pg_get_multixact_members not documented 📎	Sami Imseih	17:46
Re: tighten generic_option_name, or store more carefully in catalog? 📎	Tom Lane	18:13
Re: SpinLockAcquire and SpinLockRelease is broken on ARM/ARM64? (Re: sinvaladt.c: remove msgnumLock, use atomic operations on maxMsgNum) 📎	Yura Sokolov	18:20
Re: MergeAppend could consider sorting cheapest child path	Alexander Korotkov	18:21
Re: ARM/ARM64 SpinLockAcquire and SpinLockRelease are not full barriers	Yura Sokolov	18:28
Re: tighten generic_option_name, or store more carefully in catalog?	Chapman Flack	18:43
Re: Correcting freeze conflict horizon calculation	Melanie Plageman	18:50
Re: Proposal: Limitations of palloc inside checkpointer	Alexander Korotkov	19:03
Re: Correcting freeze conflict horizon calculation	Peter Geoghegan	19:05
ABI Compliance Checker GSoC Project	David E. Wheeler	19:06
Re: tighten generic_option_name, or store more carefully in catalog?	Tom Lane	19:23
Re: Correcting freeze conflict horizon calculation	Melanie Plageman	19:30
Re: Correcting freeze conflict horizon calculation	Peter Geoghegan	19:40
Re: Correcting freeze conflict horizon calculation	Melanie Plageman	19:40
Re: pg_upgrade: warn about roles with md5 passwords	Jeff Davis	19:41
Re: Persist injection points across server restarts	Jeff Davis	19:42
Re: Improve explicit cursor handling in pg_stat_statements 📎	Sami Imseih	19:44
Re: Correcting freeze conflict horizon calculation	Peter Geoghegan	19:49
Re: pg_upgrade: warn about roles with md5 passwords	Nathan Bossart	19:55
Re: Vacuum statistics 📎	Alena Rybakina	19:56
Re: Correcting freeze conflict horizon calculation	Melanie Plageman	19:59
Re: pg_get_multixact_members not documented	Nathan Bossart	20:03
Re: Correcting freeze conflict horizon calculation	Peter Geoghegan	20:05
Re: pg_get_multixact_members not documented	Sami Imseih	20:33
Improve the performance of Unicode Normalization Forms. 📎	Alexander Borisov	21:51

June 3, 2025

Thread	Author	Time
Re: Periodic FSM vacuum doesn't happen in one-pass strategy vacuum. 📎	Masahiko Sawada	00:14
Re: pg18: Virtual generated columns are not (yet) safe when superuser selects from them	Jeff Davis	00:23
Re: bt_index_parent_check and concurrently build indexes	Donghang Lin	00:40
Re: Add “FOR UPDATE NOWAIT” lock details to the log.	Fujii Masao	01:05
Re: wrong query results on bf leafhopper	Robins Tharakan	01:15
Re: pg18: Virtual generated columns are not (yet) safe when superuser selects from them	Tom Lane	01:19
Re: pg18: Virtual generated columns are not (yet) safe when superuser selects from them	Jeff Davis	01:41
Re: Issues with 2PC at recovery: CLOG lookups and GlobalTransactionData	Noah Misch	01:48
Re: pg18: Virtual generated columns are not (yet) safe when superuser selects from them	jian he	02:51
Re: pg18: Virtual generated columns are not (yet) safe when superuser selects from them	Isaac Morland	03:03
Re: pg18: Virtual generated columns are not (yet) safe when superuser selects from them	Tom Lane	03:30
Re: track generic and custom plans in pg_stat_statements 📎	Sami Imseih	03:31
Re: Add CHECK_FOR_INTERRUPTS in polling loop code path in XactLockTableWait 📎	Xuneng Zhou	03:32
Re: Persist injection points across server restarts	Michael Paquier	04:13
Re: Foreign key validation failure in 18beta1 📎	Amul Sul	04:14
Encapsulate io_uring process count calculation 📎	Japin Li	04:16
Re: bt_index_parent_check and concurrently build indexes	Michael Paquier	04:24
Re: Encapsulate io_uring process count calculation	Michael Paquier	04:27
Re: Add CHECK_FOR_INTERRUPTS in polling loop code path in XactLockTableWait 📎	Xuneng Zhou	04:35
Re: pg_upgrade: warn about roles with md5 passwords	Michael Paquier	04:38
Re: fix notes about password encryption in pg_authid docs	Michael Paquier	04:43
Re: C11 / VS 2019	Michael Paquier	04:51
Re: Non-reproducible AIO failure 📎	Alexander Lakhin	05:00
Re: Fix slot synchronization with two_phase decoding enabled 📎	Nisha Moond	05:35
Re: Proposal: Filter irrelevant change before reassemble transactions during logical decoding	Amit Kapila	05:54
Re: Proposal: Filter irrelevant change before reassemble transactions during logical decoding 📎	Ajin Cherian	06:25
Add log_autovacuum_{vacuum|analyze}_min_duration 📎	Shinya Kato	06:35
Re: Add CHECK_FOR_INTERRUPTS in polling loop code path in XactLockTableWait	Fujii Masao	06:55
Re: proposal: schema variables 📎	Pavel Stehule	07:26
Re: Add log_autovacuum_{vacuum|analyze}_min_duration	Michael Banck	07:42
macos exported symbols list not used for loadable modules 📎	Peter Eisentraut	07:47
Re: Pathify RHS unique-ification for semijoin planning 📎	Richard Guo	07:52
Re: C11 / VS 2019	Yura Sokolov	08:01
Re: Improve explicit cursor handling in pg_stat_statements	Michael Paquier	08:09
Re: Add log_autovacuum_{vacuum|analyze}_min_duration	Shinya Kato	08:25
Re: Suggestions for improving \conninfo output in v18 📎	Fujii Masao	08:28
Re: Prevent internal error at concurrent CREATE OR REPLACE FUNCTION	Yugo Nagata	08:39
Re: Add log_autovacuum_{vacuum|analyze}_min_duration	Michael Banck	08:57
Re: Improve tab completion for COPY	Yugo Nagata	08:58
Re: pg_upgrade: warn about roles with md5 passwords	Laurenz Albe	09:37
Re: Add SPLIT PARTITION/MERGE PARTITIONS commands	Alexander Korotkov	09:58
Re: Add SPLIT PARTITION/MERGE PARTITIONS commands	Alexander Korotkov	10:12
Re: Proposal: Limitations of palloc inside checkpointer	Xuneng Zhou	10:16
Re: [PATCH] Allow parallelism for plpgsql return expression after commit 556f7b7	Dilip Kumar	10:39
Re: Add CHECK_FOR_INTERRUPTS in polling loop code path in XactLockTableWait	Xuneng Zhou	10:44
Re: pgsql: postgres_fdw: Inherit the local transaction's access/deferrable	Etsuro Fujita	10:45
Re: Proposal: Limitations of palloc inside checkpointer	Alexander Korotkov	11:04
Re: Add SPLIT PARTITION/MERGE PARTITIONS commands	Dmitry Koval	11:06
Re: Suggestions for improving \conninfo output in v18	Robert Treat	11:22
Re: Improve explicit cursor handling in pg_stat_statements	Sami Imseih	11:40
Re: Logical Replication of sequences	Amit Kapila	11:41
Re: proposal: schema variables 📎	Pavel Stehule	11:43
Re: Vacuum statistics 📎	Alena Rybakina	12:27
Re: A modest proposal: make parser/rewriter/planner inputs read-only	Amit Langote	12:58
Re: pg18: Virtual generated columns are not (yet) safe when superuser selects from them	Robert Haas	12:58
Re: pg18: Virtual generated columns are not (yet) safe when superuser selects from them	Isaac Morland	13:15
Re: Slot's restart_lsn may point to removed WAL segment after hard restart unexpectedly 📎	Alexander Korotkov	13:21
Re: MergeAppend could consider sorting cheapest child path 📎	Andrei Lepikhov	13:23
Re: MergeAppend could consider sorting cheapest child path	Alexander Korotkov	13:38
Re: like pg_shmem_allocations, but fine-grained for DSM registry ?	Nathan Bossart	13:52
Re: MergeAppend could consider sorting cheapest child path	Andrei Lepikhov	13:53
Re: C11 / VS 2019	Tom Lane	14:01
Re: Incremental Sort Cost Estimation Instability	Alexander Korotkov	14:02
Re: MergeAppend could consider sorting cheapest child path	Alexander Korotkov	14:05
Re: pg18: Virtual generated columns are not (yet) safe when superuser selects from them	Bruce Momjian	14:11
Re: pg_upgrade: warn about roles with md5 passwords	Nathan Bossart	14:12
Re: pg_upgrade: warn about roles with md5 passwords	Heikki Linnakangas	14:25
Re: ABI Compliance Checker GSoC Project	Mankirat Singh	14:30
Re: pg_upgrade: warn about roles with md5 passwords	Tom Lane	14:34
Re: MergeAppend could consider sorting cheapest child path	Andrei Lepikhov	14:35
Re: pg_upgrade: warn about roles with md5 passwords	Nathan Bossart	14:43
Re: ABI Compliance Checker GSoC Project	Álvaro Herrera	15:19
Re: pg18: Virtual generated columns are not (yet) safe when superuser selects from them	Robert Haas	15:27
PoC: Compute a histogram of prune_xid to support autovacuum improvements 📎	Renan Alves Fonseca	16:39
Re: Replication slot is not able to sync up	Robert Haas	16:47
Re: pg_upgrade: warn about roles with md5 passwords 📎	Nathan Bossart	17:09
Re: pg18: Virtual generated columns are not (yet) safe when superuser selects from them	Jeff Davis	17:11
Re: Persist injection points across server restarts	Jeff Davis	17:17
Re: autoprewarm_dump_now	Robert Haas	17:17
Re: PG 18 release notes draft committed	Noah Misch	17:21
Re: ABI Compliance Checker GSoC Project	Mankirat Singh	17:23
Re: autoprewarm_dump_now	Tom Lane	17:24
Re: Avoid orphaned objects dependencies, take 3	Robert Haas	17:27
Re: autoprewarm_dump_now	Robert Haas	17:56
Re: Correcting freeze conflict horizon calculation	Peter Geoghegan	17:59
Re: fix notes about password encryption in pg_authid docs 📎	Nathan Bossart	18:01
Re: Improve explicit cursor handling in pg_stat_statements 📎	Sami Imseih	18:04
Re: Correcting freeze conflict horizon calculation	Peter Geoghegan	18:05
Re: ABI Compliance Checker GSoC Project	Álvaro Herrera	18:12
Re: ABI Compliance Checker GSoC Project	David E. Wheeler	18:19
Re: Add log_autovacuum_{vacuum|analyze}_min_duration	Nathan Bossart	18:47
Re: autoprewarm_dump_now	Andres Freund	18:58
Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part 📎	David E. Wheeler	19:02
Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part 📎	David E. Wheeler	19:10
postmaster uses more CPU in 18 beta1 with io_method=io_uring	MARK CALLAGHAN	19:24
Re: Add log_autovacuum_{vacuum|analyze}_min_duration	Sami Imseih	19:32
Re: Persist injection points across server restarts	Andres Freund	19:34
Re: like pg_shmem_allocations, but fine-grained for DSM registry ? 📎	Florents Tselai	19:39
Re: like pg_shmem_allocations, but fine-grained for DSM registry ?	Nathan Bossart	19:53
Re: like pg_shmem_allocations, but fine-grained for DSM registry ? 📎	Florents Tselai	20:07
Re: like pg_shmem_allocations, but fine-grained for DSM registry ?	Nathan Bossart	20:23
Re: bt_index_parent_check and concurrently build indexes 📎	Mihail Nikalayeu	20:26
Re: C11 / VS 2019	Thomas Munro	20:46
Re: Add SPLIT PARTITION/MERGE PARTITIONS commands 📎	Dmitry Koval	20:53
Re: SpinLockAcquire and SpinLockRelease is broken on ARM/ARM64? (Re: sinvaladt.c: remove msgnumLock, use atomic operations on maxMsgNum)	Andres Freund	21:04
Re: MergeAppend could consider sorting cheapest child path	Alexander Korotkov	22:41
Re: Correcting freeze conflict horizon calculation	Melanie Plageman	22:51
Re: Add log_autovacuum_{vacuum|analyze}_min_duration	Fujii Masao	23:15

June 4, 2025

Thread	Author	Time
Re: Persist injection points across server restarts	Michael Paquier	00:15
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart 📎	Masahiko Sawada	01:10
Re: Add log_autovacuum_{vacuum|analyze}_min_duration	wenhui qiu	01:30
Re: Proposal: Limitations of palloc inside checkpointer	Xuneng Zhou	03:11
Re: Encapsulate io_uring process count calculation	Japin Li	03:12
Re: Foreign key validation failure in 18beta1	jian he	03:18
[19] Proposal: function markers to indicate collation/ctype sensitivity	Jeff Davis	03:22
Enhance pg_createsubscriber to create required standby. 📎	Shubham Khanna	03:56
Custom Glibc collation version strings under LOCPATH 📎	Thomas Munro	04:03
Re: pgsql: postgres_fdw: Inherit the local transaction's access/deferrable	Fujii Masao	04:14

Browse Archives

Prev | Next