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

Thread	Author	Time
Re: read stream on amcheck 📎	Melanie Plageman	00:48
Re: Partition pruning on parameters grouped into an array does not prune properly	David Rowley	00:58
Re: AIO v2.5 📎	Andres Freund	01:07
Re: A small correction to doc and comment of FSM for indexes	Michael Paquier	01:21
Re: Possibly hard-to-read message	David G. Johnston	01:34
Re: Add Postgres module info	Yurii Rashkovskii	01:38
Re: Possibly hard-to-read message	David G. Johnston	01:42
Re: Query ID Calculation Fix for DISTINCT / ORDER BY and LIMIT / OFFSET	Michael Paquier	01:50
Re: making EXPLAIN extensible	Robert Haas	01:53
Re: making EXPLAIN extensible	Michael Paquier	01:53
support ALTER TABLE DROP EXPRESSION for virtual generated column 📎	jian he	01:54
Re: POC: make mxidoff 64 bits	wenhui qiu	02:03
Re: Change log level for notifying hot standby is waiting non-overflowed snapshot 📎	torikoshia	02:06
Re: Historic snapshot doesn't track txns committed in BUILDING_SNAPSHOT state	Ajin Cherian	02:30
Re: making EXPLAIN extensible	Tom Lane	02:40
Re: Add Postgres module info	Tom Lane	02:45
Re: Add Postgres module info	Yurii Rashkovskii	02:53
Re: Use CLOCK_MONOTONIC_COARSE for instr_time when available	Tom Lane	03:09
Re: support ALTER TABLE DROP EXPRESSION for virtual generated column	Tom Lane	03:15
Re: Add Postgres module info	Tom Lane	03:17
Re: Make COPY format extendable: Extract COPY TO format implementations 📎	Sutou Kouhei	03:28
Re: GSoC 2025 - Looking for Beginner-Friendly PostgreSQL Project	wenhui qiu	03:34
Re: [PATCH] SVE popcount support 📎	Nathan Bossart	03:38
Re: support ALTER TABLE DROP EXPRESSION for virtual generated column	David G. Johnston	03:44
Re: Historic snapshot doesn't track txns committed in BUILDING_SNAPSHOT state	cca5507	03:47
RE: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Hayato Kuroda (Fujitsu)	04:26
Re: [PoC] Reducing planning time when tables have many partitions	Ashutosh Bapat	04:42
Re: NOT ENFORCED constraint feature	Amul Sul	04:48
Re: Historic snapshot doesn't track txns committed in BUILDING_SNAPSHOT state	Ajin Cherian	04:57
Re: Latches vs lwlock contention	Alexander Lakhin	05:00
Re: Query ID Calculation Fix for DISTINCT / ORDER BY and LIMIT / OFFSET	Sami Imseih	05:02
Re: [PoC] Reducing planning time when tables have many partitions 📎	Ashutosh Bapat	05:10
Re: NOT ENFORCED constraint feature	Ashutosh Bapat	05:35
Re: Query ID Calculation Fix for DISTINCT / ORDER BY and LIMIT / OFFSET	David Rowley	05:37
Re: Query ID Calculation Fix for DISTINCT / ORDER BY and LIMIT / OFFSET	David Rowley	05:43
Re: Current master hangs under the debugger after Parallel Seq Scan (Linux, MacOS)	Vladlen Popolitov	06:23
Re: Use CLOCK_MONOTONIC_COARSE for instr_time when available	wenhui qiu	06:29
Re: Fix slot synchronization with two_phase decoding enabled	Amit Kapila	06:29
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Amit Kapila	06:45
Re: Remove useless casts to (char *)	Vladlen Popolitov	06:46
Re: Reduce "Var IS [NOT] NULL" quals during constant folding	Richard Guo	07:10
Re: why there is not VACUUM FULL CONCURRENTLY?	Antonin Houska	07:20
Re: Historic snapshot doesn't track txns committed in BUILDING_SNAPSHOT state	cca5507	07:26
Re: Remove vardata parameters from eqjoinsel_inner	Richard Guo	07:48
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided. 📎	Shubham Khanna	08:05
Re: [fixed] Trigger test 📎	Dmitrii Bondar	08:13
Re: simplifying grammar for ALTER CONSTRAINT .. SET [NO] INHERIT	Álvaro Herrera	08:27
Re: [PATCH] SVE popcount support	John Naylor	08:31
Re: read stream on amcheck 📎	Nazir Bilal Yavuz	08:45
Re: Squash constant lists in query jumbling by default	Álvaro Herrera	08:47
Re: GSoC 2025 - Looking for Beginner-Friendly PostgreSQL Project	Jesper Pedersen	08:52
Re: Better HINT message for "unexpected data beyond EOF"	Jakub Wartak	09:25
Re: [PATCH] PGSERVICEFILE as part of a normal connection string	Michael Paquier	09:31
Re: Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment	Ilia Evdokimov	10:12
Re: Thread-safe nl_langinfo() and localeconv()	Peter Eisentraut	10:16
Re: Fix 035_standby_logical_decoding.pl race conditions	Amit Kapila	10:20
Re: FileFallocate misbehaving on XFS	Andrea Gelmini	10:25
Re: Reducing memory consumed by RestrictInfo list translations in partitionwise join planning 📎	Ashutosh Bapat	10:27
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	10:46
Re: Remove vardata parameters from eqjoinsel_inner 📎	Ilia Evdokimov	11:00
Re: making EXPLAIN extensible	Robert Haas	11:29
Re: Draft for basic NUMA observability	Nazir Bilal Yavuz	11:30
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	11:33
Re: Statistics import and export: difference in statistics of materialized view dumped	Ashutosh Bapat	11:37
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	11:57
Re: Improve monitoring of shared memory allocations 📎	Rahila Syed	12:02
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	12:03
Re: Options to control remote transactions’ access/deferrable modes in postgres_fdw	Ashutosh Bapat	12:25
Re: Test to dump and restore objects left behind by regression	vignesh C	12:31
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	12:39
Re: Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment	Robert Haas	12:46
Re: NOT ENFORCED constraint feature 📎	Amul Sul	12:54
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	12:55
Re: Improve monitoring of shared memory allocations	Tomas Vondra	12:56
Re: NOT ENFORCED constraint feature 📎	Peter Eisentraut	12:58
Re: Draft for basic NUMA observability 📎	Jakub Wartak	13:02
Re: getting "shell command argument contains a newline or carriage return:" error with pg_dumpall when db name have new line in double quote	Álvaro Herrera	13:03
Re: Allow default \watch interval in psql to be configured 📎	Ranier Vilela	13:04
Re: Allow default \watch interval in psql to be configured	Daniel Gustafsson	13:08
Re: Draft for basic NUMA observability	Álvaro Herrera	13:15
Re: Partition pruning on parameters grouped into an array does not prune properly	Andrei Lepikhov	13:22
Re: NOT ENFORCED constraint feature	Amul Sul	13:36
Re: Add Postgres module info 📎	Yurii Rashkovskii	13:38
Re: Remove vardata parameters from eqjoinsel_inner	Tom Lane	13:40
Re: Draft for basic NUMA observability	Andres Freund	13:40
Re: Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment	Andrei Lepikhov	13:46
Re: Selectively invalidate caches in pgoutput module	Andres Freund	13:48
Re: Parallel tests publication and subscription might fail due to concurrent tuple update	vignesh C	13:50
Re: Reduce "Var IS [NOT] NULL" quals during constant folding	Tom Lane	13:53
Re: Reduce "Var IS [NOT] NULL" quals during constant folding	Richard Guo	14:08
Re: Better HINT message for "unexpected data beyond EOF"	Andres Freund	14:12
Re: NOT ENFORCED constraint feature	Álvaro Herrera	14:15
Re: Use CLOCK_MONOTONIC_COARSE for instr_time when available	Andres Freund	14:19
Re: SQL:2023 JSON simplified accessor support	Vik Fearing	14:27
Re: Better HINT message for "unexpected data beyond EOF"	Robert Haas	14:55
Re: Better HINT message for "unexpected data beyond EOF"	Christoph Berg	15:00
Re: Add Postgres module info	Tom Lane	15:07
Re: psql \dh: List High-Level (Root) Tables and Indexes	Greg Sabino Mullane	15:08
Re: Change log level for notifying hot standby is waiting non-overflowed snapshot 📎	torikoshia	15:13
libpq maligning postgres stability	Andres Freund	15:19
Re: psql \dh: List High-Level (Root) Tables and Indexes	Christoph Berg	15:19
Re: Amcheck verification of GiST and GIN	Mark Dilger	15:30
Re: libpq maligning postgres stability	Robert Haas	15:48
pg_stat_database.checksum_failures vs shared relations	Andres Freund	15:58
Remove restrictions in recursive query	Renan Alves Fonseca	16:02
Re: libpq maligning postgres stability	Christoph Berg	16:03
Docs and tests for RLS policies applied by command type 📎	Dean Rasheed	16:03
Re: pg_stat_database.checksum_failures vs shared relations	Robert Haas	16:06
Re: Use CLOCK_MONOTONIC_COARSE for instr_time when available 📎	Jianghua Yang	16:09
Re: Amcheck verification of GiST and GIN	Tomas Vondra	16:14
Re: Support "make check" for PGXS extensions	Peter Eisentraut	16:21
Re: Test to dump and restore objects left behind by regression	Ashutosh Bapat	16:31
Re: Remove restrictions in recursive query	Robert Haas	16:37
Re: Remove restrictions in recursive query	Robert Haas	16:39
Re: Remove restrictions in recursive query	David G. Johnston	17:00
Re: Test to dump and restore objects left behind by regression	Alvaro Herrera	17:15
Re: Support "make check" for PGXS extensions	David E. Wheeler	17:23
Re: acronym, glossary and other related matters in the docs	David G. Johnston	17:58
Re: Remove restrictions in recursive query	Renan Alves Fonseca	18:03
Re: Remove restrictions in recursive query	David G. Johnston	18:09
Re: Remove restrictions in recursive query	Renan Alves Fonseca	18:21
Re: Proposal: Progressive explain	Robert Haas	18:26
Re: Remove restrictions in recursive query	Robert Haas	18:32
Re: read stream on amcheck	Melanie Plageman	18:35
Re: read stream on amcheck	Matheus Alcantara	18:45
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints 📎	Alvaro Herrera	19:25
Re: read stream on amcheck	Melanie Plageman	19:42
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:07
Re: read stream on amcheck	Matheus Alcantara	20:56
Re: AIO v2.5	Andres Freund	20:58
Re: Non-text mode for pg_dumpall 📎	Andrew Dunstan	21:15
Re: Remove restrictions in recursive query	Tom Lane	21:17
Re: Remove restrictions in recursive query	Renan Alves Fonseca	21:21
Re: making EXPLAIN extensible 📎	Andrei Lepikhov	21:34
Re: Remove restrictions in recursive query	Tom Lane	21:50
Re: Adding skip scan (including MDAM style range skip scan) to nbtree	Alena Rybakina	22:03
Re: Remove restrictions in recursive query	Renan Alves Fonseca	22:29
Re: psql \dh: List High-Level (Root) Tables and Indexes	Sadeq Dousti	22:48
Re: Add pg_buffercache_evict_all() and pg_buffercache_mark_dirty[_all]() functions	Aidar Imamov	22:53
Re: psql \dh: List High-Level (Root) Tables and Indexes	Sadeq Dousti	23:13
Re: POC, WIP: OR-clause support for indexes 📎	Alexander Korotkov	23:18
Re: psql \dh: List High-Level (Root) Tables and Indexes 📎	Sadeq Dousti	23:28
Re: Improve monitoring of shared memory allocations 📎	Tomas Vondra	23:50
Re: [PATCH] PGSERVICEFILE as part of a normal connection string 📎	Michael Paquier	23:57

March 28, 2025

Thread	Author	Time
Bringing non-atomic operation to a PL that hasn't had it	Chapman Flack	00:12
Re: Remove restrictions in recursive query	Tom Lane	00:14
RE: Selectively invalidate caches in pgoutput module	Hayato Kuroda (Fujitsu)	00:33
Re: pg_stat_database.checksum_failures vs shared relations	Michael Paquier	00:44
Re: pg_stat_database.checksum_failures vs shared relations	Andres Freund	01:02
Re: Cross-type index comparison support in contrib/btree_gin 📎	Tom Lane	01:22
Re: Test to dump and restore objects left behind by regression	Michael Paquier	01:36
Re: Proposal: Progressive explain	Rafael Thofehrn Castro	01:37
Re: [PATCH] PGSERVICEFILE as part of a normal connection string	Michael Paquier	01:44
RE: Partial aggregates pushdown 📎	Fujii.Yuki@df.MitsubishiElectric.co.jp	02:00
Re: Reducing memory consumed by RestrictInfo list translations in partitionwise join planning 📎	David Rowley	03:02
Re: speedup COPY TO for partitioned table. 📎	jian he	03:03
Re: speedup COPY TO for partitioned table. 📎	jian he	03:09
Re: AIO v2.5	Noah Misch	03:22
Re: pg_stat_database.checksum_failures vs shared relations	Julien Rouhaud	03:24
Re: Selectively invalidate caches in pgoutput module	Amit Kapila	03:53
Re: Parallel heap vacuum	Masahiko Sawada	03:55
Re: Use XLOG_CONTROL_FILE macro everywhere? 📎	Anton A. Melnikov	04:09
Re: making EXPLAIN extensible	Man Zeng	04:12
Re: Sequence Access Methods, round two 📎	Michael Paquier	04:31
duplicated comments on get_relation_constraints	jian he	04:46
Re: Statistics import and export: difference in statistics of materialized view dumped 📎	Jeff Davis	05:11
RE: Selectively invalidate caches in pgoutput module 📎	Hayato Kuroda (Fujitsu)	05:16
Re: UUID v7	Masahiko Sawada	05:31
Re: Reducing memory consumed by RestrictInfo list translations in partitionwise join planning	Ashutosh Bapat	06:31
Re: Test to dump and restore objects left behind by regression	Ashutosh Bapat	06:32
Re: Parallel heap vacuum 📎	Masahiko Sawada	06:40
Re: Test to dump and restore objects left behind by regression	Ashutosh Bapat	06:50
Assert failure in base_yyparse 📎	Евгений Горбанев	07:39
Re: Sequence Access Methods, round two	Kirill Reshke	07:40
Re: duplicated comments on get_relation_constraints	Kirill Reshke	07:52
Re: sync_standbys_defined read/write race on startup 📎	Maksim.Melnikov	07:57
Re: Thread-safe nl_langinfo() and localeconv() 📎	Peter Eisentraut	08:13
Re: MergeAppend could consider sorting cheapest child path 📎	Alexander Pyhalov	08:19
Re: Proposal: Adding compression of temporary files	Filip Janus	08:23
Re: Buffer overflow in zic	Евгений Горбанев	08:43
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints	jian he	08:50
Re: NOT ENFORCED constraint feature 📎	Amul Sul	09:00
RE: Fix 035_standby_logical_decoding.pl race conditions 📎	Hayato Kuroda (Fujitsu)	09:02
Re: Assert failure in base_yyparse	Richard Guo	09:05
Re: Selectively invalidate caches in pgoutput module	Amit Kapila	09:15
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Amit Kapila	09:16
Re: Statistics import and export: difference in statistics of materialized view dumped	Ashutosh Bapat	09:23
Re: Test to dump and restore objects left behind by regression	Ashutosh Bapat	09:28
Re: Assert failure in base_yyparse	Richard Guo	09:34
Re: making EXPLAIN extensible	Pavel Luzanov	09:39
Re: Restrict publishing of partitioned table with a foreign table as partition 📎	Shlok Kyal	09:43
Re: NOT ENFORCED constraint feature	Ashutosh Bapat	10:03
Re: Assert failure in base_yyparse 📎	Евгений Горбанев	10:12
Re: duplicated comments on get_relation_constraints	Richard Guo	10:19
Re: psql \dh: List High-Level (Root) Tables and Indexes	Christoph Berg	10:27
Re: Test to dump and restore objects left behind by regression	Alvaro Herrera	10:35
Re: Add pg_buffercache_evict_all() and pg_buffercache_mark_dirty[_all]() functions 📎	Nazir Bilal Yavuz	10:37
Re: POC, WIP: OR-clause support for indexes	Pavel Borisov	10:47
Re: Restrict publishing of partitioned table with a foreign table as partition	Álvaro Herrera	11:04
Re: Improve monitoring of shared memory allocations	Rahila Syed	11:10

Browse Archives

Prev | Next