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

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
Re: Improve explicit cursor handling in pg_stat_statements	Michael Paquier	04:26
Re: [PATCH] PGSERVICEFILE as part of a normal connection string	Michael Paquier	04:42
Re: Add --system-identifier / -s option to pg_resetwal	Peter Eisentraut	04:49
Re: fix notes about password encryption in pg_authid docs	Michael Paquier	05:11
Re: [PATCH] Proposal: Improvements to PDF stylesheet and table column widths 📎	Noboru Saito	05:37
Re: Add --system-identifier / -s option to pg_resetwal	Michael Paquier	05:40
Re: C11 / VS 2019 📎	Peter Eisentraut	06:15
Re: C11 / VS 2019	Peter Eisentraut	06:22
pg_probackup build issue with PostgreSQL 18beta1 due to pg_detoast_datum_packed() 📎	Japin Li	07:06
Re: encode/decode support for base64url 📎	Florents Tselai	08:12
Re: Add log_autovacuum_{vacuum|analyze}_min_duration	Shinya Kato	08:13
Re: like pg_shmem_allocations, but fine-grained for DSM registry ?	Florents Tselai	08:17
Re: Enhance pg_createsubscriber to create required standby.	Peter Eisentraut	09:09
Re: Custom Glibc collation version strings under LOCPATH	Peter Eisentraut	09:17
Re: Partitioned tables and [un]loggedness	Shinya Kato	09:55
Re: Enhance pg_createsubscriber to create required standby.	Amit Kapila	09:56
Re: Partitioned tables and [un]loggedness	Shinya Kato	10:05
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart	shveta malik	10:10
Re: Enable data checksums by default	Peter Eisentraut	10:16
Re: Proposal: Filter irrelevant change before reassemble transactions during logical decoding 📎	Ajin Cherian	10:22
Re: Conflict detection for update_deleted in logical replication	shveta malik	10:25
synchronized_standby_slots used in logical replication	Fabrice Chapuis	10:30
Re: Custom Glibc collation version strings under LOCPATH 📎	Thomas Munro	10:39
Re: pull-up subquery if JOIN-ON contains refs to upper-query 📎	Alena Rybakina	10:40
Re: Restrict publishing of partitioned table with a foreign table as partition	Ajin Cherian	10:41
RE: Conflict detection for update_deleted in logical replication 📎	Zhijie Hou (Fujitsu)	10:42
Re: Add SPLIT PARTITION/MERGE PARTITIONS commands	jian he	10:45
Re: Suggestions for improving \conninfo output in v18 📎	Fujii Masao	11:18
Re: postgres_fdw could deparse ArrayCoerceExpr	Alexander Korotkov	11:29
Re: strange perf regression with data checksums	Tomas Vondra	11:33
Some questions about gin index	Andy Fan	12:10
Re: Proposal: Limitations of palloc inside checkpointer	Xuneng Zhou	12:33
Re: MergeAppend could consider sorting cheapest child path	Andrei Lepikhov	12:52
RE: Suggestion to add --continue-client-on-abort option to pgbench	Hayato Kuroda (Fujitsu)	12:57
Request to Expedite Account Activation Cool-Off Period	Xuneng Zhou	12:59
Re: ABI Compliance Checker GSoC Project	Mankirat Singh	13:11
Re: Speedup truncations of temporary relation forks	Fujii Masao	13:18
Re: doc pg_constraint.convalidated column description need update	Peter Eisentraut	13:37
Re: ABI Compliance Checker GSoC Project	Álvaro Herrera	13:43
Re: [PATCH] Hex-coding optimizations using SVE on ARM.	Nathan Bossart	13:47
Re: [WIP]Vertical Clustered Index (columnar store extension) - take2 📎	Timur Magomedov	13:47
Re: Please update your contact list: It must be [email protected]	* Neustradamus *	13:47
Re: Custom Glibc collation version strings under LOCPATH	Joe Conway	13:52
Cluster.pm psql() undefined $$stderr 📎	Oleg Tselebrovskiy	14:01
Re: strange perf regression with data checksums	Peter Geoghegan	14:21
Add tab-completion for ALTER TABLE ADD NOT NULL 📎	Fujii Masao	14:26
Re: Add tab-completion for ALTER TABLE ADD NOT NULL	Álvaro Herrera	14:38
Re: Speedup truncations of temporary relation forks	Maxim Orlov	14:43
Re: fix notes about password encryption in pg_authid docs	Nathan Bossart	14:52
Re: ABI Compliance Checker GSoC Project	David E. Wheeler	15:15
Re: postgres_fdw could deparse ArrayCoerceExpr	Alexander Pyhalov	15:15
Re: PATCH: jsonpath string methods: lower, upper, initcap, l/r/btrim, replace, split_part 📎	David E. Wheeler	15:27
Re: [19] Proposal: function markers to indicate collation/ctype sensitivity	David E. Wheeler	15:33
Re: Add tab-completion for ALTER TABLE ADD NOT NULL	Fujii Masao	15:34
Re: Custom Glibc collation version strings under LOCPATH	Joe Conway	15:44
Re: ABI Compliance Checker GSoC Project	Mankirat Singh	15:45
Re: [19] Proposal: function markers to indicate collation/ctype sensitivity	Maciek Sakrejda	15:48
Re: [19] Proposal: function markers to indicate collation/ctype sensitivity	Jeff Davis	15:53
Re: ABI Compliance Checker GSoC Project	Andres Freund	16:10
Re: Partitioned tables and [un]loggedness	Nathan Bossart	16:15
Re: like pg_shmem_allocations, but fine-grained for DSM registry ?	Nathan Bossart	16:19
Re: Improve explicit cursor handling in pg_stat_statements 📎	Sami Imseih	16:51
Re: strange perf regression with data checksums 📎	Peter Geoghegan	17:39
Re: Fix slot synchronization with two_phase decoding enabled	Masahiko Sawada	17:46
Re: [WIP]Vertical Clustered Index (columnar store extension) - take2	Jim Nasby	17:59
Re: like pg_shmem_allocations, but fine-grained for DSM registry ? 📎	Florents Tselai	18:03
Re: Allow CI to only run the compiler warnings task	David G. Johnston	18:08
Re: [WIP]Vertical Clustered Index (columnar store extension) - take2	Tomas Vondra	18:15
Re: pgsql: postgres_fdw: Inherit the local transaction's access/deferrable	Robert Haas	18:39
Re: Add --system-identifier / -s option to pg_resetwal 📎	Nikolay Samokhvalov	18:46
Re: Add log_autovacuum_{vacuum|analyze}_min_duration	Sami Imseih	18:53
Re: gcc 15 "array subscript 0" warning at level -O3 📎	Andres Freund	19:00
Question Regarding Merge Append and Parallel Execution of Index Scans on Partitioned Table	Ayush Vatsa	19:31
Re: Add SPLIT PARTITION/MERGE PARTITIONS commands 📎	Dmitry Koval	19:44
Re: ABI Compliance Checker GSoC Project	David E. Wheeler	19:48
a couple of small cleanup patches for DSM-related code 📎	Nathan Bossart	19:48
Re: Non-reproducible AIO failure	Andres Freund	20:02
Re: pg_upgrade: warn about roles with md5 passwords	Peter Eisentraut	20:15
Re: Enhance pg_createsubscriber to create required standby.	Peter Eisentraut	20:20
Re: proposal: schema variables 📎	Pavel Stehule	20:22
Re: Add --system-identifier / -s option to pg_resetwal	Peter Eisentraut	20:23
Re: Non-reproducible AIO failure	Thomas Munro	20:32

Browse Archives

Prev | Next