Mailing lists [pgsql-hackers]

24 March

• 00:16   Re: Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment David Rowley
• 00:20   Re: Add missing tab completion for VACUUM and ANALYZE with ONLY option Tom Lane
• 00:27   Add mention in docs about locking all partitions for generic plans David Rowley
• 01:21   Re: System views for versions reporting Tom Lane
• 02:23   Re: [PoC] Reducing planning time when tables have many partitions Yuya Watari
• 02:41   Re: Fwd: [BUG]: the walsender does not update its IO statistics until it exits Michael Paquier
• 02:52   Re: Proposal - Allow extensions to set a Plan Identifier Michael Paquier
• 03:29   Re: AIO v2.5 Noah Misch
• 03:50   Re: Fix infinite loop from setting scram_iterations to INT_MAX Richard Guo
• 03:54   Re: Fix infinite loop from setting scram_iterations to INT_MAX Michael Paquier
• 03:59   Re: Fix infinite loop from setting scram_iterations to INT_MAX Richard Guo
• 04:11   Re: AIO v2.5 Thomas Munro
• 04:21   Re: Add semi-join pushdown to postgres_fdw Alexander Korotkov
• 04:27   Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints jian he
• 04:43   Re: Doc: fix the rewrite condition when executing ALTER TABLE ADD COLUMN jian he
• 05:21   RE: pg_recvlogical requires -d but not described on the documentation Hayato Kuroda (Fujitsu)
• 05:22   Re: Query ID Calculation Fix for DISTINCT / ORDER BY and LIMIT / OFFSET Michael Paquier
• 06:26   Re: support virtual generated column not null constraint jian he
• 06:38   Re: Parallel safety for extern params Amit Kapila
• 07:37   Re: Commit fest 2025-03 vignesh C
• 07:43   Re: Proposal - Allow extensions to set a Plan Identifier Michael Paquier
• 07:54   RE: Fix 035_standby_logical_decoding.pl race conditions Hayato Kuroda (Fujitsu)
• 08:38   Re: [PoC] Reducing planning time when tables have many partitions David Rowley
• 09:18   Re: Orphaned users in PG16 and above can only be managed by Superusers Ashutosh Sharma
• 09:33   Re: Patch: Cover POSITION(bytea,bytea) with tests David Rowley
• 09:42   Re: Query ID Calculation Fix for DISTINCT / ORDER BY and LIMIT / OFFSET David Rowley
• 09:50   Re: Add mention in docs about locking all partitions for generic plans Tender Wang
• 09:50   Re: Query ID Calculation Fix for DISTINCT / ORDER BY and LIMIT / OFFSET Michael Paquier
• 09:59   RE: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided. Hayato Kuroda (Fujitsu)
• 10:07   Re: Add semi-join pushdown to postgres_fdw Alexander Pyhalov
• 10:50   Re: Change COPY ... ON_ERROR ignore to ON_ERROR ignore_row jian he
• 11:36   Re: FSM doesn't recover after zeroing damaged page. Anton A. Melnikov
• 11:49   Re: Add semi-join pushdown to postgres_fdw Alexander Korotkov
• 11:50   Re: Add mention in docs about locking all partitions for generic plans David Rowley
• 12:19   Re: Add mention in docs about locking all partitions for generic plans Tender Wang
• 12:24   Re: doc: Mention clock synchronization recommendation for hot_standby_feedback Jakub Wartak
• 12:33   Re: Restrict publishing of partitioned table with a foreign table as partition Shlok Kyal
• 12:37   High memory usage in CachedPlan for large IN clauses in partitioned table updates 赵庭海(庭章)
• 12:40   Re: Conflict detection for multiple_unique_conflicts in logical replication Amit Kapila
• 12:54   Re: Test to dump and restore objects left behind by regression Ashutosh Bapat
• 12:55   Re: Next commitfest app release is planned for March 18th Peter Eisentraut
• 12:59   Re: Test to dump and restore objects left behind by regression Daniel Gustafsson
• 13:10   Re: POC, WIP: OR-clause support for indexes Andrei Lepikhov
• 13:20   Re: CREATE SUBSCRIPTION - add missing test case Heikki Linnakangas
• 13:26   Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided. Shubham Khanna
• 13:27   [PATCH] Add a new pattern for zero-based months for Date/Time Formatting Vincent Moreau
• 13:37   Re: Doc: fix the rewrite condition when executing ALTER TABLE ADD COLUMN Álvaro Herrera
• 13:41   Re: sinvaladt.c: remove msgnumLock, use atomic operations on maxMsgNum Yura Sokolov
• 13:45   [PATCH] Add a new pattern for zero-based months for Date/Time Formatting Vincent Moreau
• 13:46   Re: POC, WIP: OR-clause support for indexes Pavel Borisov
• 14:14   Re: support fast default for domain with constraints jian he
• 14:34   Re: [PATCH] SVE popcount support John Naylor
• 14:37   Re: Improve CRC32C performance on SSE4.2 John Naylor
• 14:41   pg_restore documentation and --create/--single-transaction limitation Ashutosh Bapat
• 15:10   Re: Allow default \watch interval in psql to be configured Daniel Gustafsson
• 15:11   Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided. Shlok Kyal
• 15:14   Re: Test to dump and restore objects left behind by regression Alvaro Herrera
• 15:27   vacuum_truncate configuration parameter and isset_offset Nikolay Shaplov
• 15:38   Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided. Ashutosh Bapat
• 15:39   Re: Add pg_buffercache_evict_all() and pg_buffercache_mark_dirty[_all]() functions Nazir Bilal Yavuz
• 15:39   Re: Add pg_buffercache_evict_all() and pg_buffercache_mark_dirty[_all]() functions Nazir Bilal Yavuz
• 15:40   Re: Add pg_buffercache_evict_all() and pg_buffercache_mark_dirty[_all]() functions Nazir Bilal Yavuz
• 15:42   Re: vacuum_truncate configuration parameter and isset_offset Nikolay Shaplov
• 15:42   Re: Allow default \watch interval in psql to be configured Ashutosh Bapat
• 15:46   Re: POC, WIP: OR-clause support for indexes Alena Rybakina
• 15:55   Re: Add pg_buffercache_evict_all() and pg_buffercache_mark_dirty[_all]() functions Nazir Bilal Yavuz
• 15:56   Re: [18] CREATE SUBSCRIPTION ... SERVER vignesh C
• 16:08   Re: sinvaladt.c: remove msgnumLock, use atomic operations on maxMsgNum Andres Freund
• 16:24   Re: Improve monitoring of shared memory allocations Tomas Vondra
• 16:43   Re: Adding extension default version to \dx Magnus Hagander
• 16:52   Re: Reducing memory consumed by RestrictInfo list translations in partitionwise join planning Amit Langote
• 17:11   Re: Add Postgres module info Andrei Lepikhov
• 17:18   Re: Change log level for notifying hot standby is waiting non-overflowed snapshot torikoshia
• 17:22   Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints Robert Haas
• 17:31   Re: Add Postgres module info Robert Haas
• 17:43   Re: vacuum_truncate configuration parameter and isset_offset Nathan Bossart
• 17:48   Re: vacuum_truncate configuration parameter and isset_offset Robert Haas
• 17:56   Re: Snapshot related assert failure on skink Tomas Vondra
• 18:11   Re: vacuum_truncate configuration parameter and isset_offset Nikolay Shaplov
• 18:12   Re: vacuum_truncate configuration parameter and isset_offset Nikolay Shaplov
• 18:25   Re: vacuum_truncate configuration parameter and isset_offset Robert Haas
• 18:25   Re: Snapshot related assert failure on skink Heikki Linnakangas
• 18:30   Re: vacuum_truncate configuration parameter and isset_offset David G. Johnston
• 18:41   Re: query_id: jumble names of temp tables for better pg_stat_statement UX Christoph Berg
• 18:43   Re: AIO v2.5 Andres Freund
• 18:44   Re: High memory usage in CachedPlan for large IN clauses in partitioned table updates Tom Lane
• 18:45   Re: vacuum_truncate configuration parameter and isset_offset Nikolay Shaplov
• 18:45   Modify SHOW to display reloptions by accepting table-qualified names. David G. Johnston
• 18:47   Re: Restrict publishing of partitioned table with a foreign table as partition Álvaro Herrera
• 18:49   Re: vacuum_truncate configuration parameter and isset_offset David G. Johnston
• 18:54   Re: Add Postgres module info Tom Lane
• 18:55   Re: Change log level for notifying hot standby is waiting non-overflowed snapshot Fujii Masao
• 18:56   Re: pg_recvlogical requires -d but not described on the documentation Fujii Masao
• 18:58   Re: Modify SHOW to display reloptions by accepting table-qualified names. Tom Lane
• 19:00   Re: vacuum_truncate configuration parameter and isset_offset Álvaro Herrera
• 19:06   Re: vacuum_truncate configuration parameter and isset_offset Nikolay Shaplov
• 19:08   Re: vacuum_truncate configuration parameter and isset_offset David G. Johnston
• 19:14   Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman
• 19:16   Re: dblink: Add SCRAM pass-through authentication Peter Eisentraut
• 19:29   Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints Alvaro Herrera
• 19:29   Re: vacuum_truncate configuration parameter and isset_offset David G. Johnston
• 19:40   Re: vacuum_truncate configuration parameter and isset_offset David G. Johnston
• 19:41   Re: vacuum_truncate configuration parameter and isset_offset Nathan Bossart
• 19:53   Re: vacuum_truncate configuration parameter and isset_offset Nikolay Shaplov
• 19:54   Re: vacuum_truncate configuration parameter and isset_offset David G. Johnston
• 19:56   Re: Add semi-join pushdown to postgres_fdw Alexander Pyhalov
• 19:58   Re: vacuum_truncate configuration parameter and isset_offset Nathan Bossart
• 20:03   Re: vacuum_truncate configuration parameter and isset_offset Nikolay Shaplov
• 20:09   Re: vacuum_truncate configuration parameter and isset_offset Nathan Bossart
• 20:27   Re: vacuum_truncate configuration parameter and isset_offset Nikolay Shaplov
• 20:31   Re: Add Postgres module info Robert Haas
• 20:37   Re: vacuum_truncate configuration parameter and isset_offset David G. Johnston
• 20:43   Re: vacuum_truncate configuration parameter and isset_offset Robert Haas
• 20:47   Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints Robert Haas
• 20:48   Re: vacuum_truncate configuration parameter and isset_offset Nathan Bossart
• 20:49   Re: [PoC] Reducing planning time when tables have many partitions Tom Lane
• 20:51   Re: getting "shell command argument contains a newline or carriage return:" error with pg_dumpall when db name have new line in double quote Mahendra Singh Thalor
• 20:57   Re: vacuum_truncate configuration parameter and isset_offset Nikolay Shaplov
• 21:03   Re: vacuum_truncate configuration parameter and isset_offset Nikolay Shaplov
• 21:14   Re: Add Postgres module info Euler Taveira
• 21:24   Re: Add Postgres module info Tom Lane
• 21:45   Re: vacuum_truncate configuration parameter and isset_offset Nathan Bossart
• 21:47   Re: Proposal - Allow extensions to set a Plan Identifier Lukas Fittl
• 22:06   Re: [PATCH] SVE popcount support Nathan Bossart
• 22:11   Re: vacuum_truncate configuration parameter and isset_offset Robert Haas
• 22:12   Re: vacuum_truncate configuration parameter and isset_offset Nikolay Shaplov
• 22:21   Re: Proposal - Allow extensions to set a Plan Identifier Alena Rybakina
• 22:26   Re: vacuum_truncate configuration parameter and isset_offset Nathan Bossart
• 22:30   Re: vacuum_truncate configuration parameter and isset_offset Nikolay Shaplov
• 22:31   Re: Proposal - Allow extensions to set a Plan Identifier Sami Imseih
• 22:31   Re: Prevent an error on attaching/creating a DSM/DSA from an interrupt handler. Rahila Syed
• 22:35   Re: vacuum_truncate configuration parameter and isset_offset Nikolay Shaplov
• 22:36   Re: Proposal - Allow extensions to set a Plan Identifier Sami Imseih
• 23:04   Re: vacuum_truncate configuration parameter and isset_offset Nathan Bossart
• 23:27   Re: vacuum_truncate configuration parameter and isset_offset Nikolay Shaplov
• 23:33   Re: dblink: Add SCRAM pass-through authentication Matheus Alcantara
• 23:44   Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman
• 23:47   Re: Disabling vacuum truncate for autovacuum Nathan Bossart
• 23:59   Re: Logging which local address was connected to in log_line_prefix Tom Lane