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

March 25, 2025

Thread	Author	Time
Re: AIO v2.5	Thomas Munro	00:07
Re: AIO v2.5	Andres Freund	00:18
Re: Make COPY format extendable: Extract COPY TO format implementations	Masahiko Sawada	00:45
Re: AIO v2.5	Noah Misch	00:45
Re: AIO v2.5 📎	Andres Freund	01:18
Re: RFC: Allow EXPLAIN to Output Page Fault Information	torikoshia	01:27
Re: AIO v2.5	Andres Freund	01:40
Re: query_id: jumble names of temp tables for better pg_stat_statement UX	Sami Imseih	01:51
Re: pg_atomic_compare_exchange_*() and memory barriers	James Hunter	02:08
RE: pg_recvlogical requires -d but not described on the documentation	Hayato Kuroda (Fujitsu)	02:10
Re: AIO v2.5	Noah Misch	02:20
Re: a pool for parallel worker	James Hunter	02:23
Re: query_id: jumble names of temp tables for better pg_stat_statement UX	Tom Lane	02:27
Re: [18] CREATE SUBSCRIPTION ... SERVER	vignesh C	02:29
Re: AIO v2.5	Andres Freund	02:30
Re: query_id: jumble names of temp tables for better pg_stat_statement UX	Sami Imseih	02:38
Re: AIO v2.5	Andres Freund	02:52
Re: query_id: jumble names of temp tables for better pg_stat_statement UX	Tom Lane	02:56
pgoutput: comment atop rel_sync_cache_publication_cb() has an inconsistency 📎	Hayato Kuroda (Fujitsu)	03:01
RE: Improve error reporting for few options in pg_createsubscriber	Hayato Kuroda (Fujitsu)	03:18
Re: Conflict detection for multiple_unique_conflicts in logical replication 📎	vignesh C	03:21
Re: query_id: jumble names of temp tables for better pg_stat_statement UX	Sami Imseih	03:30
Re: Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment	David Rowley	03:32
Re: pgoutput: comment atop rel_sync_cache_publication_cb() has an inconsistency	Amit Kapila	03:35
Re: Conflict detection for multiple_unique_conflicts in logical replication	Amit Kapila	03:42
Re: Fix 035_standby_logical_decoding.pl race conditions	Bertrand Drouvot	03:44
Re: query_id: jumble names of temp tables for better pg_stat_statement UX	Michael Paquier	03:47
Re: query_id: jumble names of temp tables for better pg_stat_statement UX	Michael Paquier	03:51
Selectively invalidate caches in pgoutput when pg_namespace is modified 📎	Hayato Kuroda (Fujitsu)	03:52
Re: query_id: jumble names of temp tables for better pg_stat_statement UX	Michael Paquier	03:53
Re: vacuum_truncate configuration parameter and isset_offset	David G. Johnston	03:57
Re: AIO v2.5 📎	Thomas Munro	04:10
Re: query_id: jumble names of temp tables for better pg_stat_statement UX	Sami Imseih	04:30
Re: query_id: jumble names of temp tables for better pg_stat_statement UX	Tom Lane	04:32
Re: gamma() and lgamma() functions 📎	Alexandra Wang	05:01
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided. 📎	Shubham Khanna	05:06
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Shubham Khanna	05:07
Re: query_id: jumble names of temp tables for better pg_stat_statement UX	Julien Rouhaud	05:09
Re: query_id: jumble names of temp tables for better pg_stat_statement UX	Tom Lane	05:17
Re: query_id: jumble names of temp tables for better pg_stat_statement UX	Julien Rouhaud	05:28
Re: Statistics Import and Export	Jeff Davis	05:32
Fix slot synchronization with two_phase decoding enabled 📎	Zhijie Hou (Fujitsu)	05:35
Re: Logical Replication of sequences 📎	vignesh C	05:35
Re: query_id: jumble names of temp tables for better pg_stat_statement UX	Lukas Fittl	06:09
Re: Vacuum statistics 📎	Alena Rybakina	06:12
Re: Reduce TupleHashEntryData struct size by half 📎	Jeff Davis	06:14
Re: Reducing memory consumed by RestrictInfo list translations in partitionwise join planning 📎	Ashutosh Bapat	06:16
Re: Use XLOG_CONTROL_FILE macro everywhere? 📎	Anton A. Melnikov	06:20
Re: a pool for parallel worker	Andy Fan	06:29
Re: Change COPY ... ON_ERROR ignore to ON_ERROR ignore_row	vignesh C	06:31
Re: Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment	Andrei Lepikhov	06:40
Re: Fix slot synchronization with two_phase decoding enabled	Amit Kapila	06:44
Re: Query ID Calculation Fix for DISTINCT / ORDER BY and LIMIT / OFFSET 📎	David Rowley	06:47
Re: Statistics Import and Export 📎	Jeff Davis	06:53
Re: query_id: jumble names of temp tables for better pg_stat_statement UX 📎	Michael Paquier	07:02
Re: Add semi-join pushdown to postgres_fdw	Tender Wang	07:04
Re: Proposal - Allow extensions to set a Plan Identifier	Michael Paquier	07:13
Re: Reducing memory consumed by RestrictInfo list translations in partitionwise join planning 📎	Amit Langote	07:28
Re: Proposal - Allow extensions to set a Plan Identifier	Lukas Fittl	07:45
RE: Query ID Calculation Fix for DISTINCT / ORDER BY and LIMIT / OFFSET	Bykov Ivan	08:14
Re: Cannot find a working 64-bit integer type on Illumos	Thomas Munro	08:41
Re: Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment	Andrei Lepikhov	09:32
Re: Reducing memory consumed by RestrictInfo list translations in partitionwise join planning 📎	Ashutosh Bapat	09:35
Re: Proposal - Allow extensions to set a Plan Identifier	Andrei Lepikhov	09:42
RE: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Hayato Kuroda (Fujitsu)	09:52
Re: Support for NO INHERIT to INHERIT state change with named NOT NULL constraints	Peter Eisentraut	10:22
Re: Options to control remote transactions’ access/deferrable modes in postgres_fdw 📎	Etsuro Fujita	10:31
Re: Test to dump and restore objects left behind by regression 📎	Ashutosh Bapat	10:39
Re: Options to control remote transactions’ access/deferrable modes in postgres_fdw	Etsuro Fujita	10:44
Re: sinvaladt.c: remove msgnumLock, use atomic operations on maxMsgNum 📎	Yura Sokolov	10:52
Re: Add semi-join pushdown to postgres_fdw	Alexander Korotkov	10:55
Re: Remove an unnecessary check on semijoin_target_ok() on postgres_fdw.c	Alexander Korotkov	10:57
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Shubham Khanna	10:58
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Ashutosh Bapat	11:01
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided. 📎	Shubham Khanna	11:07
Re: Remove an unnecessary check on semijoin_target_ok() on postgres_fdw.c	Tender Wang	11:07
[PATCH] Split varlena.c into varlena.c and bytea.c 📎	Aleksander Alekseev	11:17
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Ashutosh Bapat	11:25
Re: Fix 035_standby_logical_decoding.pl race conditions	Amit Kapila	11:34
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Ashutosh Bapat	11:38
Re: sinvaladt.c: remove msgnumLock, use atomic operations on maxMsgNum	Yura Sokolov	11:45
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Amit Kapila	11:45
Re: CREATE DATABASE with filesystem cloning 📎	Nazir Bilal Yavuz	11:47
Re: Expanding HOT updates for expression and partial indexes 📎	Burd, Greg	11:47
Re: Reducing memory consumed by RestrictInfo list translations in partitionwise join planning 📎	Amit Langote	11:50
Re: Support for NO INHERIT to INHERIT state change with named NOT NULL constraints	Alvaro Herrera	11:52
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Ashutosh Bapat	11:54
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Ashutosh Bapat	12:00
RE: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Hayato Kuroda (Fujitsu)	12:07
Re: Reducing memory consumed by RestrictInfo list translations in partitionwise join planning	Ashutosh Bapat	12:09
Re: Query ID Calculation Fix for DISTINCT / ORDER BY and LIMIT / OFFSET 📎	David Rowley	12:11
Re: Improve CRC32C performance on SSE4.2 📎	John Naylor	13:04
Re: Improve CRC32C performance on SSE4.2	John Naylor	13:18
Re: AIO v2.5	Noah Misch	13:33
Re: Support for NO INHERIT to INHERIT state change with named NOT NULL constraints	Peter Eisentraut	13:39
Re: AIO v2.5	Noah Misch	14:11
Re: Enhancing Memory Context Statistics Reporting 📎	Daniel Gustafsson	14:14
Re: Expanding HOT updates for expression and partial indexes 📎	Burd, Greg	14:21
Re: why there is not VACUUM FULL CONCURRENTLY? 📎	Alvaro Herrera	14:32
Re: Statistics Import and Export	Corey Huinker	14:53
Re: vacuum_truncate configuration parameter and isset_offset 📎	Nathan Bossart	14:57
Re: query_id: jumble names of temp tables for better pg_stat_statement UX	Sami Imseih	14:59
Re: AIO v2.5	Andres Freund	15:26
Re: AIO v2.5	Andres Freund	15:33
Re: query_id: jumble names of temp tables for better pg_stat_statement UX	Christoph Berg	15:41
Re: AIO v2.5	Andres Freund	15:57
Re: AIO v2.5	Noah Misch	15:58
simplifying grammar for ALTER CONSTRAINT .. SET [NO] INHERIT	Álvaro Herrera	16:02
Re: simplifying grammar for ALTER CONSTRAINT .. SET [NO] INHERIT 📎	Álvaro Herrera	16:05
Re: AIO v2.5	Noah Misch	16:15
Squash constant lists in query jumbling by default	Christoph Berg	16:28
Re: vacuum_truncate configuration parameter and isset_offset	Nikolay Shaplov	16:35
Re: Add missing PQclear for StreamLogicalLog function	Daniel Gustafsson	16:46
Re: NOT ENFORCED constraint feature	Peter Eisentraut	16:48
Re: Squash constant lists in query jumbling by default	Tom Lane	16:53
Re: query_id: jumble names of temp tables for better pg_stat_statement UX	Sami Imseih	16:58
Re: Squash constant lists in query jumbling by default	Álvaro Herrera	17:27
Re: Statistics Import and Export	Robert Treat	17:51
Re: Squash constant lists in query jumbling by default	Sami Imseih	17:55
Re: Squash constant lists in query jumbling by default	Dmitry Dolgov	18:40
Re: Statistics Import and Export	Jeff Davis	18:42
Re: why there is not VACUUM FULL CONCURRENTLY?	Robert Haas	18:47
Re: AIO v2.5	Andres Freund	18:58
Re: Allow default \watch interval in psql to be configured	Daniel Gustafsson	19:08
Re: Squash constant lists in query jumbling by default 📎	Sami Imseih	19:33
Re: AIO v2.5	Noah Misch	19:39
Re: Statistics Import and Export	Corey Huinker	19:59
Re: Squash constant lists in query jumbling by default	Dmitry Dolgov	20:05
Re: AIO v2.5	Andres Freund	20:07
Re: AIO v2.5	Noah Misch	20:18
Re: SQL function which allows to distinguish a server being in point in time recovery mode and an ordinary replica 📎	m.litsarev	20:26
Re: Advanced Patch Feedback Session / pgconf.dev 2025	Tomas Vondra	20:31
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Euler Taveira	20:34
Re: [fixed] Trigger test	Lilian Ontowhee	20:48
Re: AIO v2.5 📎	Andres Freund	20:56
Re: optimize file transfer in pg_upgrade	Nathan Bossart	21:03
Re: Proposal - Allow extensions to set a Plan Identifier	Sami Imseih	21:23
Re: Squash constant lists in query jumbling by default	Laurenz Albe	21:24
Re: Cannot find a working 64-bit integer type on Illumos	Nathan Bossart	21:33
Re: Cannot find a working 64-bit integer type on Illumos	Thomas Munro	21:39
Re: AIO v2.5	Noah Misch	22:44
Re: Query ID Calculation Fix for DISTINCT / ORDER BY and LIMIT / OFFSET 📎	David Rowley	22:56
Re: Cannot find a working 64-bit integer type on Illumos	Tom Lane	23:01
Re: Cannot find a working 64-bit integer type on Illumos	Daniel Gustafsson	23:06
Re: query_id: jumble names of temp tables for better pg_stat_statement UX 📎	Michael Paquier	23:10
Re: query_id: jumble names of temp tables for better pg_stat_statement UX	Tom Lane	23:24
Re: Cannot find a working 64-bit integer type on Illumos	Tom Lane	23:36
Re: Adding skip scan (including MDAM style range skip scan) to nbtree 📎	Peter Geoghegan	23:45

March 26, 2025

Thread	Author	Time
Re: AIO v2.5	Andres Freund	00:17
Re: AIO v2.5	Noah Misch	00:19
Re: query_id: jumble names of temp tables for better pg_stat_statement UX 📎	Michael Paquier	00:34
Re: AIO v2.5	Noah Misch	00:43
Re: Proposal: Progressive explain 📎	Rafael Thofehrn Castro	00:52
Re: query_id: jumble names of temp tables for better pg_stat_statement UX	Sami Imseih	00:56
Re: Query ID Calculation Fix for DISTINCT / ORDER BY and LIMIT / OFFSET	Michael Paquier	01:04
Re: Statistics Import and Export 📎	Corey Huinker	01:41
Re: Reduce "Var IS [NOT] NULL" quals during constant folding 📎	Richard Guo	02:16
Re: Proposal - Allow extensions to set a Plan Identifier	Michael Paquier	02:43
Possibly hard-to-read message 📎	Kyotaro Horiguchi	03:07
Re: Proposal - Allow extensions to set a Plan Identifier	Sami Imseih	03:12
Re: Possibly hard-to-read message	David G. Johnston	03:52
Re: NOT ENFORCED constraint feature	Amul Sul	04:02
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	vignesh C	04:31
Re: UUID v7 📎	Masahiko Sawada	04:32
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Amit Kapila	04:51
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Amit Kapila	04:54
ALTER COLUMN SET DATA TYPE does not change the generation expression's collation	jian he	05:01
RE: BUG #18815: Logical replication worker Segmentation fault 📎	Zhijie Hou (Fujitsu)	05:07
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Amit Kapila	05:10
Re: a pool for parallel worker	Kirill Reshke	05:42
Re: [Patch] remove duplicated smgrclose	Masahiko Sawada	05:43
Re: Reduce "Var IS [NOT] NULL" quals during constant folding	Tender Wang	06:06
Re: a pool for parallel worker	Andy Fan	06:10
Doc: Add Table of Contents to psql Reference Page 📎	David G. Johnston	06:17
Re: query_id: jumble names of temp tables for better pg_stat_statement UX	Michael Paquier	06:24
Re: a pool for parallel worker	Andy Fan	06:30
Re: Reduce "Var IS [NOT] NULL" quals during constant folding	Richard Guo	06:31
Re: Fix infinite loop from setting scram_iterations to INT_MAX	Richard Guo	06:41
Re: Update LDAP Protocol in fe-connect.c to v3	Peter Eisentraut	06:41
Re: Allow default \watch interval in psql to be configured	Pavel Stehule	06:59
Re: NOT ENFORCED constraint feature	Álvaro Herrera	06:59
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	07:04
Re: a pool for parallel worker	Kirill Reshke	07:11
Re: Accessing an invalid pointer in BufferManagerRelation structure	Stepan Neretin	07:14
support create index on virtual generated column. 📎	jian he	07:15
[PATCH] avoid double scanning in function byteain 📎	Steven Niu	07:17
Re: Allow default \watch interval in psql to be configured	Pavel Stehule	07:42
RE: Fix 035_standby_logical_decoding.pl race conditions 📎	Hayato Kuroda (Fujitsu)	07:47
Re: Allow default \watch interval in psql to be configured	Daniel Gustafsson	08:05
Re: pg_ctl start may return 0 even if the postmaster has been already started on Windows	vignesh C	08:18
Re: [PATCH] avoid double scanning in function byteain	Kirill Reshke	08:37
Re: Windows: openssl & gssapi dislike each other	vignesh C	08:53
Better HINT message for "unexpected data beyond EOF" 📎	Jakub Wartak	08:59
Re: Possibly hard-to-read message	Daniel Gustafsson	09:10
Re: race condition when writing pg_control	vignesh C	09:12
Re: Allow default \watch interval in psql to be configured	Pavel Stehule	09:12
Re: [PATCH] Add a new pattern for zero-based months for Date/Time Formatting	Peter Eisentraut	09:18
RE: Query ID Calculation Fix for DISTINCT / ORDER BY and LIMIT / OFFSET	Bykov Ivan	09:31
Re: support create index on virtual generated column.	Kirill Reshke	09:36
Re: Reduce "Var IS [NOT] NULL" quals during constant folding	David Rowley	09:44

Browse Archives

Prev | Next