Mailing lists [pgsql-hackers]

26 March

• 00:03   Re: optimize file transfer in pg_upgrade Nathan Bossart
• 00:23   Re: Proposal - Allow extensions to set a Plan Identifier Sami Imseih
• 00:24   Re: Squash constant lists in query jumbling by default Laurenz Albe
• 00:33   Re: Cannot find a working 64-bit integer type on Illumos Nathan Bossart
• 00:39   Re: Cannot find a working 64-bit integer type on Illumos Thomas Munro
• 01:44   Re: AIO v2.5 Noah Misch
• 01:56   Re: Query ID Calculation Fix for DISTINCT / ORDER BY and LIMIT / OFFSET David Rowley
• 02:01   Re: Cannot find a working 64-bit integer type on Illumos Tom Lane
• 02:06   Re: Cannot find a working 64-bit integer type on Illumos Daniel Gustafsson
• 02:10   Re: query_id: jumble names of temp tables for better pg_stat_statement UX Michael Paquier
• 02:24   Re: query_id: jumble names of temp tables for better pg_stat_statement UX Tom Lane
• 02:36   Re: Cannot find a working 64-bit integer type on Illumos Tom Lane
• 02:45   Re: Adding skip scan (including MDAM style range skip scan) to nbtree Peter Geoghegan
• 03:17   Re: AIO v2.5 Andres Freund
• 03:19   Re: AIO v2.5 Noah Misch
• 03:34   Re: query_id: jumble names of temp tables for better pg_stat_statement UX Michael Paquier
• 03:43   Re: AIO v2.5 Noah Misch
• 03:52   Re: Proposal: Progressive explain Rafael Thofehrn Castro
• 03:56   Re: query_id: jumble names of temp tables for better pg_stat_statement UX Sami Imseih
• 04:04   Re: Query ID Calculation Fix for DISTINCT / ORDER BY and LIMIT / OFFSET Michael Paquier
• 04:41   Re: Statistics Import and Export Corey Huinker
• 05:16   Re: Reduce "Var IS [NOT] NULL" quals during constant folding Richard Guo
• 05:43   Re: Proposal - Allow extensions to set a Plan Identifier Michael Paquier
• 06:07   Possibly hard-to-read message Kyotaro Horiguchi
• 06:12   Re: Proposal - Allow extensions to set a Plan Identifier Sami Imseih
• 06:52   Re: Possibly hard-to-read message David G. Johnston
• 07:02   Re: NOT ENFORCED constraint feature Amul Sul
• 07:31   Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided. vignesh C
• 07:32   Re: UUID v7 Masahiko Sawada
• 07:51   Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided. Amit Kapila
• 07:54   Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided. Amit Kapila
• 08:01   ALTER COLUMN SET DATA TYPE does not change the generation expression's collation jian he
• 08:07   RE: BUG #18815: Logical replication worker Segmentation fault Zhijie Hou (Fujitsu)
• 08:10   Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided. Amit Kapila
• 08:42   Re: a pool for parallel worker Kirill Reshke
• 08:43   Re: [Patch] remove duplicated smgrclose Masahiko Sawada
• 09:06   Re: Reduce "Var IS [NOT] NULL" quals during constant folding Tender Wang
• 09:10   Re: a pool for parallel worker Andy Fan
• 09:17   Doc: Add Table of Contents to psql Reference Page David G. Johnston
• 09:24   Re: query_id: jumble names of temp tables for better pg_stat_statement UX Michael Paquier
• 09:30   Re: a pool for parallel worker Andy Fan
• 09:31   Re: Reduce "Var IS [NOT] NULL" quals during constant folding Richard Guo
• 09:41   Re: Fix infinite loop from setting scram_iterations to INT_MAX Richard Guo
• 09:41   Re: Update LDAP Protocol in fe-connect.c to v3 Peter Eisentraut
• 09:59   Re: Allow default \watch interval in psql to be configured Pavel Stehule
• 09:59   Re: NOT ENFORCED constraint feature Álvaro Herrera
• 10:04   Re: getting "shell command argument contains a newline or carriage return:" error with pg_dumpall when db name have new line in double quote Srinath Reddy
• 10:11   Re: a pool for parallel worker Kirill Reshke
• 10:14   Re: Accessing an invalid pointer in BufferManagerRelation structure Stepan Neretin
• 10:15   support create index on virtual generated column. jian he
• 10:17   [PATCH] avoid double scanning in function byteain Steven Niu
• 10:42   Re: Allow default \watch interval in psql to be configured Pavel Stehule
• 10:47   RE: Fix 035_standby_logical_decoding.pl race conditions Hayato Kuroda (Fujitsu)
• 11:05   Re: Allow default \watch interval in psql to be configured Daniel Gustafsson
• 11:18   Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows vignesh C
• 11:37   Re: [PATCH] avoid double scanning in function byteain Kirill Reshke
• 11:53   Re: Windows: openssl & gssapi dislike each other vignesh C
• 11:59   Better HINT message for "unexpected data beyond EOF" Jakub Wartak
• 12:10   Re: Possibly hard-to-read message Daniel Gustafsson
• 12:12   Re: race condition when writing pg_control vignesh C
• 12:12   Re: Allow default \watch interval in psql to be configured Pavel Stehule
• 12:18   Re: [PATCH] Add a new pattern for zero-based months for Date/Time Formatting Peter Eisentraut
• 12:31   RE: Query ID Calculation Fix for DISTINCT / ORDER BY and LIMIT / OFFSET Bykov Ivan
• 12:36   Re: support create index on virtual generated column. Kirill Reshke
• 12:44   Re: Reduce "Var IS [NOT] NULL" quals during constant folding David Rowley
• 12:45   Re: [fixed] Trigger test Dmitrii Bondar
• 12:49   Re: gamma() and lgamma() functions Dean Rasheed
• 13:15   Re: Historic snapshot doesn't track txns committed in BUILDING_SNAPSHOT state Ajin Cherian
• 13:32   Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided. Shubham Khanna
• 13:34   Re: Enhancing Memory Context Statistics Reporting Rahila Syed
• 13:41   Re: dblink: Add SCRAM pass-through authentication Peter Eisentraut
• 13:47   RE: Conflict detection for update_deleted in logical replication Zhijie Hou (Fujitsu)
• 13:56   RE: Fix 035_standby_logical_decoding.pl race conditions Hayato Kuroda (Fujitsu)
• 14:11   Re: Windows: openssl & gssapi dislike each other Andrew Dunstan
• 14:21   Re: Recovering from detoast-related catcache invalidations Andres Freund
• 14:29   Re: Reducing memory consumed by RestrictInfo list translations in partitionwise join planning Ashutosh Bapat
• 14:39   Re: dblink: Add SCRAM pass-through authentication Matheus Alcantara
• 14:39   Re: why there is not VACUUM FULL CONCURRENTLY? Antonin Houska
• 14:55   Re: simplifying grammar for ALTER CONSTRAINT .. SET [NO] INHERIT Peter Eisentraut
• 14:58   Re: gamma() and lgamma() functions Marcos Pegoraro
• 15:02   Re: gamma() and lgamma() functions Marcos Pegoraro
• 15:24   Re: Allow default \watch interval in psql to be configured Daniel Gustafsson
• 15:25   Re: getting "shell command argument contains a newline or carriage return:" error with pg_dumpall when db name have new line in double quote Andrew Dunstan
• 15:35   Re: Allow default \watch interval in psql to be configured Pavel Stehule
• 15:36   Re: getting "shell command argument contains a newline or carriage return:" error with pg_dumpall when db name have new line in double quote Srinath Reddy
• 15:51   Re: Historic snapshot doesn't track txns committed in BUILDING_SNAPSHOT state cca5507
• 15:52   Re: getting "shell command argument contains a newline or carriage return:" error with pg_dumpall when db name have new line in double quote Srinath Reddy
• 16:00   Re: UUID v7 Andrey Borodin
• 16:10   Re: Proposal: Progressive explain Rafael Thofehrn Castro
• 16:44   Re: Proposal: Progressive explain Robert Haas
• 16:52   Re: vacuum_truncate configuration parameter and isset_offset Robert Haas
• 16:59   Re: [PATCH] Add a new pattern for zero-based months for Date/Time Formatting Christoph Berg
• 17:17   Re: vacuum_truncate configuration parameter and isset_offset David G. Johnston
• 17:17   sync_standbys_defined read/write race on startup Maksim.Melnikov
• 17:23   Re: simplifying grammar for ALTER CONSTRAINT .. SET [NO] INHERIT Suraj Kharage
• 17:27   Remote partitionwise doesn't work for varchar join keys Anton Ratundalov
• 17:30   Re: vacuum_truncate configuration parameter and isset_offset Álvaro Herrera
• 17:39   Re: [PATCH] avoid double scanning in function byteain Steven Niu
• 17:39   Re: Add 64-bit XIDs into PostgreSQL 15 Evgeny Voropaev
• 17:39   Re: vacuum_truncate configuration parameter and isset_offset Nikolay Shaplov
• 17:40   Re: vacuum_truncate configuration parameter and isset_offset Nathan Bossart
• 17:42   Re: vacuum_truncate configuration parameter and isset_offset Robert Haas
• 17:43   Re: Fix infinite loop from setting scram_iterations to INT_MAX Daniel Gustafsson
• 17:47   Re: Windows: openssl & gssapi dislike each other Daniel Gustafsson
• 17:53   Re: vacuum_truncate configuration parameter and isset_offset Robert Haas
• 17:53   Current master hangs under the debugger after Parallel Seq Scan (Linux, MacOS) Vladlen Popolitov
• 17:54   Re: vacuum_truncate configuration parameter and isset_offset Nikolay Shaplov
• 18:01   Re: Better HINT message for "unexpected data beyond EOF" Robert Haas
• 18:01   Re: Remove useless casts to (char *) Vladlen Popolitov
• 18:09   Re: vacuum_truncate configuration parameter and isset_offset David G. Johnston
• 18:15   Re: Add Postgres module info Tom Lane
• 18:19   Partition pruning on parameters grouped into an array does not prune properly Andrei Lepikhov
• 18:26   Assertion with aborted UPDATE in subtransaction Jasper Smit
• 18:28   Re: vacuum_truncate configuration parameter and isset_offset Nathan Bossart
• 18:38   Re: Current master hangs under the debugger after Parallel Seq Scan (Linux, MacOS) Tom Lane
• 18:41   Re: vacuum_truncate configuration parameter and isset_offset Robert Haas
• 18:42   Re: [PATCH] Add a new pattern for zero-based months for Date/Time Formatting Tom Lane
• 18:57   Re: Current master hangs under the debugger after Parallel Seq Scan (Linux, MacOS) Vladlen Popolitov
• 19:14   Re: vacuum_truncate configuration parameter and isset_offset Nathan Bossart
• 19:15   Re: Windows: openssl & gssapi dislike each other Tom Lane
• 19:26   Re: vacuum_truncate configuration parameter and isset_offset David G. Johnston
• 19:32   Re: Windows: openssl & gssapi dislike each other Daniel Gustafsson
• 19:32   Re: Current master hangs under the debugger after Parallel Seq Scan (Linux, MacOS) Nikita Malakhov
• 19:49   Re: vacuum_truncate configuration parameter and isset_offset David G. Johnston
• 20:06   Re: UUID v7 Masahiko Sawada
• 20:06   Deadlock detected while executing concurrent insert queries on same table Sri Keerthi
• 20:14   Re: Logging which local address was connected to in log_line_prefix Greg Sabino Mullane
• 20:29   Re: vacuum_truncate configuration parameter and isset_offset Nikolay Shaplov
• 20:40   Re: Current master hangs under the debugger after Parallel Seq Scan (Linux, MacOS) Robert Haas
• 20:54   Re: vacuum_truncate configuration parameter and isset_offset David G. Johnston
• 21:09   Re: making EXPLAIN extensible Robert Haas
• 21:14   Use CLOCK_MONOTONIC_COARSE for instr_time when available 杨江华
• 21:14   GSoC 2025 - Looking for Beginner-Friendly PostgreSQL Project Kruti Popat
• 21:15   Re: [PROPOSAL] : Disallow use of empty column name in (column_name '') in ALTER or CREATE of foreign table. Robert Haas
• 21:16   Re: vacuum_truncate configuration parameter and isset_offset Robert Haas
• 21:21   Re: Use CLOCK_MONOTONIC_COARSE for instr_time when available 杨江华
• 21:22   Re: Current master hangs under the debugger after Parallel Seq Scan (Linux, MacOS) Andres Freund
• 21:31   Re: AIO v2.5 Noah Misch
• 21:34   Re: vacuum_truncate configuration parameter and isset_offset Nikolay Shaplov
• 21:43   Re: vacuum_truncate configuration parameter and isset_offset Robert Haas
• 22:04   Re: in BeginCopyTo make materialized view using COPY TO instead of COPY (query). Kirill Reshke
• 22:05   Re: vacuum_truncate configuration parameter and isset_offset Nikolay Shaplov
• 22:09   Re: [PoC] Federated Authn/z with OAUTHBEARER Jacob Champion
• 22:21   Re: vacuum_truncate configuration parameter and isset_offset Álvaro Herrera
• 22:37   Re: Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment Robert Haas
• 22:48   Re: sync_standbys_defined read/write race on startup Kirill Reshke
• 22:55   RE: Improve CRC32C performance on SSE4.2 Devulapalli, Raghuveer
• 23:00   Re: Parallel heap vacuum Melanie Plageman
• 23:33   Re: AIO v2.5 Andres Freund