pgsql-hackers since 2025-03-24 10:10

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 24, 2025

Thread	Author	Time
Re: POC, WIP: OR-clause support for indexes 📎	Andrei Lepikhov	10:10
Re: CREATE SUBSCRIPTION - add missing test case	Heikki Linnakangas	10:20
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided. 📎	Shubham Khanna	10:26
[PATCH] Add a new pattern for zero-based months for Date/Time Formatting 📎	Vincent Moreau	10:27
Re: Doc: fix the rewrite condition when executing ALTER TABLE ADD COLUMN	Álvaro Herrera	10:37
Re: sinvaladt.c: remove msgnumLock, use atomic operations on maxMsgNum 📎	Yura Sokolov	10:41
[PATCH] Add a new pattern for zero-based months for Date/Time Formatting 📎	Vincent Moreau	10:45
Re: POC, WIP: OR-clause support for indexes	Pavel Borisov	10:46
Re: support fast default for domain with constraints 📎	jian he	11:14
Re: [PATCH] SVE popcount support	John Naylor	11:34
Re: Improve CRC32C performance on SSE4.2	John Naylor	11:37
pg_restore documentation and --create/--single-transaction limitation 📎	Ashutosh Bapat	11:41
Re: Allow default \watch interval in psql to be configured 📎	Daniel Gustafsson	12:10
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Shlok Kyal	12:11
Re: Test to dump and restore objects left behind by regression	Alvaro Herrera	12:14
vacuum_truncate configuration parameter and isset_offset	Nikolay Shaplov	12:27
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Ashutosh Bapat	12:38
Re: Add pg_buffercache_evict_all() and pg_buffercache_mark_dirty[_all]() functions	Nazir Bilal Yavuz	12:39
Re: Add pg_buffercache_evict_all() and pg_buffercache_mark_dirty[_all]() functions 📎	Nazir Bilal Yavuz	12:39
Re: Add pg_buffercache_evict_all() and pg_buffercache_mark_dirty[_all]() functions	Nazir Bilal Yavuz	12:40
Re: Allow default \watch interval in psql to be configured	Ashutosh Bapat	12:42
Re: vacuum_truncate configuration parameter and isset_offset	Nikolay Shaplov	12:42
Re: POC, WIP: OR-clause support for indexes	Alena Rybakina	12:46
Re: Add pg_buffercache_evict_all() and pg_buffercache_mark_dirty[_all]() functions	Nazir Bilal Yavuz	12:55
Re: [18] CREATE SUBSCRIPTION ... SERVER	vignesh C	12:56
Re: sinvaladt.c: remove msgnumLock, use atomic operations on maxMsgNum	Andres Freund	13:08
Re: Improve monitoring of shared memory allocations 📎	Tomas Vondra	13:24
Re: Adding extension default version to \dx	Magnus Hagander	13:43
Re: Reducing memory consumed by RestrictInfo list translations in partitionwise join planning 📎	Amit Langote	13:52
Re: Add Postgres module info	Andrei Lepikhov	14:11
Re: Change log level for notifying hot standby is waiting non-overflowed snapshot 📎	torikoshia	14:18
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints	Robert Haas	14:22
Re: Add Postgres module info	Robert Haas	14:31
Re: vacuum_truncate configuration parameter and isset_offset	Nathan Bossart	14:43
Re: vacuum_truncate configuration parameter and isset_offset	Robert Haas	14:48
Re: Snapshot related assert failure on skink	Tomas Vondra	14:56
Re: vacuum_truncate configuration parameter and isset_offset	Nikolay Shaplov	15:11
Re: vacuum_truncate configuration parameter and isset_offset	Nikolay Shaplov	15:12
Re: vacuum_truncate configuration parameter and isset_offset	Robert Haas	15:25
Re: Snapshot related assert failure on skink	Heikki Linnakangas	15:25
Re: vacuum_truncate configuration parameter and isset_offset	David G. Johnston	15:30
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:43
Re: High memory usage in CachedPlan for large IN clauses in partitioned table updates	Tom Lane	15:44
Re: vacuum_truncate configuration parameter and isset_offset	Nikolay Shaplov	15:45
Modify SHOW to display reloptions by accepting table-qualified names.	David G. Johnston	15:45
Re: Restrict publishing of partitioned table with a foreign table as partition	Álvaro Herrera	15:47
Re: vacuum_truncate configuration parameter and isset_offset	David G. Johnston	15:49
Re: Add Postgres module info	Tom Lane	15:54
Re: Change log level for notifying hot standby is waiting non-overflowed snapshot	Fujii Masao	15:55
Re: pg_recvlogical requires -d but not described on the documentation	Fujii Masao	15:56
Re: Modify SHOW to display reloptions by accepting table-qualified names.	Tom Lane	15:58
Re: vacuum_truncate configuration parameter and isset_offset	Álvaro Herrera	16:00
Re: vacuum_truncate configuration parameter and isset_offset	Nikolay Shaplov	16:06
Re: vacuum_truncate configuration parameter and isset_offset	David G. Johnston	16:08
Re: BitmapHeapScan streaming read user and prelim refactoring 📎	Melanie Plageman	16:14
Re: dblink: Add SCRAM pass-through authentication	Peter Eisentraut	16:16
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints	Alvaro Herrera	16:29
Re: vacuum_truncate configuration parameter and isset_offset	David G. Johnston	16:29
Re: vacuum_truncate configuration parameter and isset_offset	David G. Johnston	16:40
Re: vacuum_truncate configuration parameter and isset_offset	Nathan Bossart	16:41
Re: vacuum_truncate configuration parameter and isset_offset	Nikolay Shaplov	16:53
Re: vacuum_truncate configuration parameter and isset_offset	David G. Johnston	16:54
Re: Add semi-join pushdown to postgres_fdw 📎	Alexander Pyhalov	16:56
Re: vacuum_truncate configuration parameter and isset_offset	Nathan Bossart	16:58
Re: vacuum_truncate configuration parameter and isset_offset	Nikolay Shaplov	17:03
Re: vacuum_truncate configuration parameter and isset_offset	Nathan Bossart	17:09
Re: vacuum_truncate configuration parameter and isset_offset	Nikolay Shaplov	17:27
Re: Add Postgres module info	Robert Haas	17:31
Re: vacuum_truncate configuration parameter and isset_offset	David G. Johnston	17:37
Re: vacuum_truncate configuration parameter and isset_offset	Robert Haas	17:43
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints	Robert Haas	17:47
Re: vacuum_truncate configuration parameter and isset_offset 📎	Nathan Bossart	17:48
Re: [PoC] Reducing planning time when tables have many partitions	Tom Lane	17:49
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	17:51
Re: vacuum_truncate configuration parameter and isset_offset	Nikolay Shaplov	17:57
Re: vacuum_truncate configuration parameter and isset_offset	Nikolay Shaplov	18:03
Re: Add Postgres module info 📎	Euler Taveira	18:14
Re: Add Postgres module info	Tom Lane	18:24
Re: vacuum_truncate configuration parameter and isset_offset	Nathan Bossart	18:45
Re: Proposal - Allow extensions to set a Plan Identifier	Lukas Fittl	18:47
Re: [PATCH] SVE popcount support	Nathan Bossart	19:06
Re: vacuum_truncate configuration parameter and isset_offset	Robert Haas	19:11
Re: vacuum_truncate configuration parameter and isset_offset	Nikolay Shaplov	19:12
Re: Proposal - Allow extensions to set a Plan Identifier	Alena Rybakina	19:21
Re: vacuum_truncate configuration parameter and isset_offset	Nathan Bossart	19:26
Re: vacuum_truncate configuration parameter and isset_offset	Nikolay Shaplov	19:30
Re: Proposal - Allow extensions to set a Plan Identifier	Sami Imseih	19:31
Re: Prevent an error on attaching/creating a DSM/DSA from an interrupt handler. 📎	Rahila Syed	19:31
Re: vacuum_truncate configuration parameter and isset_offset	Nikolay Shaplov	19:35
Re: Proposal - Allow extensions to set a Plan Identifier	Sami Imseih	19:36
Re: vacuum_truncate configuration parameter and isset_offset	Nathan Bossart	20:04
Re: vacuum_truncate configuration parameter and isset_offset	Nikolay Shaplov	20:27
Re: dblink: Add SCRAM pass-through authentication 📎	Matheus Alcantara	20:33
Re: BitmapHeapScan streaming read user and prelim refactoring	Melanie Plageman	20:44
Re: Disabling vacuum truncate for autovacuum	Nathan Bossart	20:47
Re: Logging which local address was connected to in log_line_prefix	Tom Lane	20:59
Re: Logging which local address was connected to in log_line_prefix	Tom Lane	21:10
Re: vacuum_truncate configuration parameter and isset_offset	Nathan Bossart	21:20
Re: Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment	Andrei Lepikhov	21:23
Re: Snapshot related assert failure on skink	Tomas Vondra	21:25
Re: Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment	David Rowley	22:05
Re: Proposal - Allow extensions to set a Plan Identifier	Michael Paquier	22:05
Re: Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment	Tom Lane	22:15
Re: Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment	Lukas Fittl	22:30
Re: Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment	Tom Lane	22:45
Re: AIO v2.5	Andres Freund	22:55
Re: Vacuum statistics	Jim Nasby	23:02
Re: Proposal - Allow extensions to set a Plan Identifier 📎	Sami Imseih	23:47
Re: Parallel heap vacuum 📎	Masahiko Sawada	23:58
Re: Parallel heap vacuum	Masahiko Sawada	23:58

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

Browse Archives

Prev | Next