pgsql-hackers - April 2025

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

April 1, 2025

Thread	Author	Time
Re: Adding comments to help understand psql hidden queries	Maiquel Grassi	00:02
Re: pgsql: Add support for OAUTHBEARER SASL mechanism 📎	Jacob Champion	00:06
Re: AIO v2.5 📎	Andres Freund	00:41
Re: pgsql: Add memory/disk usage for Window aggregate nodes in EXPLAIN.	Tatsuo Ishii	00:48
Re: speedup COPY TO for partitioned table. 📎	jian he	01:01
RE: Fix 035_standby_logical_decoding.pl race conditions 📎	Hayato Kuroda (Fujitsu)	01:22
Re: [PATCH] Fix potential overflow in binary search mid calculation	Tender Wang	01:42
Re: RFC: Logging plan of the running query	torikoshia	01:43
Re: Adding skip scan (including MDAM style range skip scan) to nbtree 📎	Peter Geoghegan	02:02
Re: Using read stream in autoprewarm 📎	Melanie Plageman	02:14
Re: general purpose array_sort	Junwang Zhao	02:27
Re: Statistics Import and Export 📎	Nathan Bossart	02:33
Re: Statistics Import and Export	Robert Treat	03:02
Re: in BeginCopyTo make materialized view using COPY TO instead of COPY (query). 📎	jian he	03:12
Re: Fix slot synchronization with two_phase decoding enabled	Amit Kapila	03:20
Re: in BeginCopyTo make materialized view using COPY TO instead of COPY (query).	David G. Johnston	03:50
Re: add function argument name to substring and substr	jian he	04:11
Re: Replace IN VALUES with ANY in WHERE clauses during optimization	Alexander Korotkov	04:14
Re: add function argument name to substring and substr 📎	David G. Johnston	04:59
Re: explain analyze rows=%.0f	Andrei Lepikhov	05:20
Re: speedup COPY TO for partitioned table.	vignesh C	05:38
Re: Non-text mode for pg_dumpall 📎	Mahendra Singh Thalor	05:59
Re: Fix slot synchronization with two_phase decoding enabled 📎	Amit Kapila	06:09
Re: Test to dump and restore objects left behind by regression	Alvaro Herrera	06:22
Re: Proposal: Progressive explain 📎	Rafael Thofehrn Castro	06:23
Re: Reduce "Var IS [NOT] NULL" quals during constant folding	Richard Guo	06:34
Re: Memoize ANTI and SEMI JOIN inner	Richard Guo	07:18
statistics import and export: another difference in dump/restore	Ashutosh Bapat	07:24
Re: Test to dump and restore objects left behind by regression 📎	Ashutosh Bapat	07:43
Re: Improve monitoring of shared memory allocations 📎	Rahila Syed	07:43
Re: Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment	Ilia Evdokimov	07:52
pg_recvlogical cannot create slots with failover=true 📎	Hayato Kuroda (Fujitsu)	08:01
Re: Reducing memory consumed by RestrictInfo list translations in partitionwise join planning 📎	Amit Langote	08:01
Re: pg_recvlogical cannot create slots with failover=true	Michael Banck	08:18
Re: Fix 035_standby_logical_decoding.pl race conditions	Bertrand Drouvot	08:32
Re: Add partial :-variable expansion to psql \copy	Fabien Coelho	08:58
Self referential foreign keys in partitioned table not working as expected	Luca Vallisa	09:06
Re: [PATCH] Fix build on MINGW on ARM64	vignesh C	09:16
Re: Add partial :-variable expansion to psql \copy	Fabien Coelho	09:30
Re: in BeginCopyTo make materialized view using COPY TO instead of COPY (query).	vignesh C	09:45
Re: Add partial :-variable expansion to psql \copy	Christoph Berg	10:00
Re: Add partial :-variable expansion to psql \copy	Pavel Stehule	10:15
Re: Self referential foreign keys in partitioned table not working as expected	Christoph Berg	10:18
Re: in BeginCopyTo make materialized view using COPY TO instead of COPY (query).	Kirill Reshke	10:18
Re: Self referential foreign keys in partitioned table not working as expected	Luca Vallisa	10:24
Re: [PATCH] Fix build on MINGW on ARM64	Andrew Dunstan	10:32
Re: Improve CRC32C performance on SSE4.2 📎	John Naylor	10:33
Re: AIO writes vs hint bits vs checksums 📎	Heikki Linnakangas	10:34
Re: Self referential foreign keys in partitioned table not working as expected	Christoph Berg	10:46
Re: Draft for basic NUMA observability 📎	Jakub Wartak	10:56
RE: Fix slot synchronization with two_phase decoding enabled 📎	Zhijie Hou (Fujitsu)	10:58
Re: Better HINT message for "unexpected data beyond EOF"	Jakub Wartak	11:13
Re: Using read stream in autoprewarm	Nazir Bilal Yavuz	11:20
Re: Fix 035_standby_logical_decoding.pl race conditions	Amit Kapila	11:25
Re: Fix 035_standby_logical_decoding.pl race conditions	Amit Kapila	11:44
Hashed IN only applied to first encountered IN 📎	David Geier	11:51
RE: Fix 035_standby_logical_decoding.pl race conditions	Hayato Kuroda (Fujitsu)	11:52
Re: Change log level for notifying hot standby is waiting non-overflowed snapshot	torikoshia	11:54
Re: AIO v2.5	Aleksander Alekseev	11:56
Re: Add partial :-variable expansion to psql \copy	Daniel Verite	12:06
Re: Replace IN VALUES with ANY in WHERE clauses during optimization 📎	Alexander Korotkov	12:07
Re: Hashed IN only applied to first encountered IN	David Rowley	12:31
Re: RFC: Logging plan of the running query	Robert Haas	12:32
Re: [PATCH] Fix build on MINGW on ARM64	vignesh C	12:47
Re: Using read stream in autoprewarm 📎	Nazir Bilal Yavuz	12:50
Re: Index AM API cleanup 📎	Peter Eisentraut	12:50
Re: pgsql: Add support for OAUTHBEARER SASL mechanism	Christoph Berg	13:03
Re: PRI?64 vs Visual Studio (2022)	Peter Eisentraut	13:04
Re: pgsql: Add support for OAUTHBEARER SASL mechanism	Daniel Gustafsson	13:11
Re: add function argument name to substring and substr	Marcos Pegoraro	13:14
Re: add function argument name to substring and substr	Daniel Gustafsson	13:20
Re: Adding skip scan (including MDAM style range skip scan) to nbtree	Aleksander Alekseev	13:26
Re: why there is not VACUUM FULL CONCURRENTLY? 📎	Antonin Houska	13:31
Re: Statistics Import and Export	Robert Haas	13:37
Re: Proposal: Progressive explain	torikoshia	13:38
Re: AIO v2.5	Andres Freund	13:45
Re: pgsql: Add support for OAUTHBEARER SASL mechanism	Daniel Gustafsson	13:47
Re: Better HINT message for "unexpected data beyond EOF"	Robert Haas	13:49
Re: in BeginCopyTo make materialized view using COPY TO instead of COPY (query).	vignesh C	13:52
Re: Using read stream in autoprewarm 📎	Melanie Plageman	13:54
Re: Better HINT message for "unexpected data beyond EOF"	Christoph Berg	13:54
Re: RFC: Logging plan of the running query	torikoshia	13:57
Re: Better HINT message for "unexpected data beyond EOF"	Robert Haas	13:58
Re: Better HINT message for "unexpected data beyond EOF"	Andres Freund	13:59
Re: Make query cancellation keys longer 📎	Heikki Linnakangas	14:08
Re: in BeginCopyTo make materialized view using COPY TO instead of COPY (query).	Kirill Reshke	14:14
Re: Update LDAP Protocol in fe-connect.c to v3 📎	Andrew Jackson	14:19
Re: Replace IN VALUES with ANY in WHERE clauses during optimization	Alena Rybakina	14:23
Re: in BeginCopyTo make materialized view using COPY TO instead of COPY (query).	David G. Johnston	14:27
Re: Adding skip scan (including MDAM style range skip scan) to nbtree	Peter Geoghegan	14:37
Re: Proposal: Progressive explain	Robert Haas	14:37
Re: Adding skip scan (including MDAM style range skip scan) to nbtree	Matthias van de Meent	14:39
Re: add function argument name to substring and substr	David G. Johnston	14:40
Re: Restrict publishing of partitioned table with a foreign table as partition 📎	Shlok Kyal	14:48
Re: AIO writes vs hint bits vs checksums	Andres Freund	15:08
Re: AIO writes vs hint bits vs checksums	Heikki Linnakangas	15:11
Re: AIO v2.5	Noah Misch	15:11
Re: Draft for basic NUMA observability	Bertrand Drouvot	15:13
Re: [PATCH] Fix build on MINGW on ARM64	Andrew Dunstan	15:15
Re: Fix 035_standby_logical_decoding.pl race conditions	Bertrand Drouvot	15:15
Re: AIO writes vs hint bits vs checksums	Nico Williams	15:29
Re: pgsql: Add support for OAUTHBEARER SASL mechanism	Jacob Champion	15:48
Re: AIO v2.5	Andres Freund	15:55
macOS 15.4 versus strchrnul() 📎	Tom Lane	15:57
Re: Proposal - Allow extensions to set a Plan Identifier	Sami Imseih	15:58
Re: AIO v2.5	Noah Misch	16:07
Re: Improve CRC32C performance on SSE4.2	Nathan Bossart	16:25
Re: AIO v2.5	Andres Freund	16:51
Re: Reducing memory consumed by RestrictInfo list translations in partitionwise join planning 📎	Ashutosh Bapat	16:58
Re: Test to dump and restore objects left behind by regression	Alvaro Herrera	17:01
Re: macOS 15.4 versus strchrnul() 📎	Peter Eisentraut	17:07
Re: Proposal: Progressive explain	Rafael Thofehrn Castro	17:17
Re: Adding skip scan (including MDAM style range skip scan) to nbtree	Alena Rybakina	17:31
Re: Extend ALTER DEFAULT PRIVILEGES for large objects	Fujii Masao	17:35
Document SQL functions behavior regarding custom/generic plan 📎	Renan Alves Fonseca	17:37
Re: bug when apply fast default mechanism for adding new column over domain with default value	Alexander Lakhin	18:00
Re: Test to dump and restore objects left behind by regression	Daniel Gustafsson	18:06
Re: Statistics Import and Export 📎	Nathan Bossart	18:20
Re: POC: make mxidoff 64 bits	Heikki Linnakangas	18:25
Re: POC: make mxidoff 64 bits 📎	Heikki Linnakangas	18:26
Re: Small memory fixes for pg_createsubcriber	Noah Misch	18:39
Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch) 📎	Sami Imseih	18:41
Re: Statistics Import and Export 📎	Nathan Bossart	18:44
Re: RFC: Logging plan of the running query	Robert Haas	18:52
Re: Small memory fixes for pg_createsubcriber	Ranier Vilela	18:53
pgsql: aio: Add test_aio module	Andres Freund	18:54
Re: Improving tracking/processing of buildfarm test failures	Alexander Lakhin	19:00
Re: Adding skip scan (including MDAM style range skip scan) to nbtree	Peter Geoghegan	19:01
Re: RFC: Logging plan of the running query	Sami Imseih	19:05
Re: Adding skip scan (including MDAM style range skip scan) to nbtree	Alena Rybakina	19:08
Re: macOS 15.4 versus strchrnul()	Tom Lane	19:25
Re: System views for versions reporting	Dmitry Dolgov	19:27
Re: Small memory fixes for pg_createsubcriber	Ranier Vilela	19:28
Re: RFC: Logging plan of the running query	Robert Haas	19:29
Re: [PATCH v1] parallel pg_restore: avoid disk seeks when jumping short distance forward	Dimitrios Apostolou	19:33
Re: Reduce "Var IS [NOT] NULL" quals during constant folding	Robert Haas	19:34
TEMP_CONFIG vs test_aio	Andres Freund	19:42
Re: [PATCH v1] parallel pg_restore: avoid disk seeks when jumping short distance forward	Nathan Bossart	20:04
Re: TEMP_CONFIG vs test_aio	Todd Cook	20:12
Re: Small memory fixes for pg_createsubcriber	Noah Misch	20:14
Re: Adding skip scan (including MDAM style range skip scan) to nbtree	Matthias van de Meent	20:16
Re: TEMP_CONFIG vs test_aio	Andres Freund	20:17
Re: Draft for basic NUMA observability 📎	Tomas Vondra	20:17
Re: Adding support for SSLKEYLOGFILE in the frontend 📎	Daniel Gustafsson	20:22
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints 📎	Alvaro Herrera	20:22
Re: Statistics Import and Export	Jeff Davis	20:24
Re: TEMP_CONFIG vs test_aio	Noah Misch	20:29
Re: [PATCH] Fix build on MINGW on ARM64	Andrew Dunstan	20:32
Making sslrootcert=system work on Windows psql 📎	George MacKerron	21:05
Re: Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment	David Rowley	21:06
Re: TEMP_CONFIG vs test_aio	Andrew Dunstan	21:08
Re: Add partial :-variable expansion to psql \copy	Corey Huinker	21:24
Re: Parallel heap vacuum 📎	Masahiko Sawada	21:30
Re: TEMP_CONFIG vs test_aio	Andres Freund	21:34
Re: Making sslrootcert=system work on Windows psql	Jacob Champion	21:46
Re: AIO v2.5	Andres Freund	21:47
Re: Adding skip scan (including MDAM style range skip scan) to nbtree	Matthias van de Meent	21:56
Re: general purpose array_sort	Tom Lane	22:05
Re: Statistics Import and Export	Jeff Davis	22:05
Re: Adding skip scan (including MDAM style range skip scan) to nbtree	Matthias van de Meent	22:08
Re: [PATCH v1] parallel pg_restore: avoid disk seeks when jumping short distance forward	Dimitrios Apostolou	22:25
Re: AIO v2.5	Andres Freund	22:25
Re: Using read stream in autoprewarm 📎	Melanie Plageman	22:35
Re: [PoC] Federated Authn/z with OAUTHBEARER	Jacob Champion	22:40
Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch) 📎	Shayon Mukherjee	22:50
Re: Hashed IN only applied to first encountered IN	David Rowley	23:00
Re: Adding skip scan (including MDAM style range skip scan) to nbtree	Peter Geoghegan	23:02
Re: Small memory fixes for pg_createsubcriber	Michael Paquier	23:22
Re: general purpose array_sort	Junwang Zhao	23:25

April 2, 2025

Thread	Author	Time
Re: AIO v2.5	Noah Misch	00:13
Covering the comparison between date and timestamp, tz, type 📎	Kwangwon Seo	00:18
Re: bug when apply fast default mechanism for adding new column over domain with default value	Tom Lane	01:05
Re: Add mention in docs about locking all partitions for generic plans	David Rowley	01:06
Extensible user mapping handler for FDW 📎	Peifeng Qiu	01:36
Re: bug when apply fast default mechanism for adding new column over domain with default value 📎	Tender Wang	02:01
Re: Reduce "Var IS [NOT] NULL" quals during constant folding	Richard Guo	02:14
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints	jian he	02:19
Re: Statistics Import and Export	Robert Haas	02:24
Re: duplicated comments on get_relation_constraints	Richard Guo	02:39
Re: Statistics Import and Export 📎	Nathan Bossart	03:21
Re: CREATE SUBSCRIPTION - add missing test case	Peter Smith	04:10
Re: Fix slot synchronization with two_phase decoding enabled 📎	Amit Kapila	04:40
Re: Statistics Import and Export	Jeff Davis	05:44
RE: Fix slot synchronization with two_phase decoding enabled 📎	Zhijie Hou (Fujitsu)	05:55
Re: [PATCH] Re: Proposal to Enable/Disable Index using ALTER INDEX	Gurjeet Singh	05:55
Re: Change log level for notifying hot standby is waiting non-overflowed snapshot	Fujii Masao	06:21
Re: CRC32C Parallel Computation Optimization on ARM	John Naylor	06:45
Re: Re: proposal: schema variables 📎	Pavel Stehule	06:46
Re: Improve CRC32C performance on SSE4.2	John Naylor	07:10
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints	Rushabh Lathia	07:12
RE: Fix 035_standby_logical_decoding.pl race conditions 📎	Hayato Kuroda (Fujitsu)	07:16
Re: Reducing memory consumed by RestrictInfo list translations in partitionwise join planning 📎	Amit Langote	07:30
Re: Making sslrootcert=system work on Windows psql	Daniel Gustafsson	07:32
Re: Fix slot synchronization with two_phase decoding enabled	Masahiko Sawada	07:45
Re: Test to dump and restore objects left behind by regression	Ashutosh Bapat	08:19
Re: Change log level for notifying hot standby is waiting non-overflowed snapshot	torikoshia	08:33
Re: Fix 035_standby_logical_decoding.pl race conditions	Bertrand Drouvot	08:36
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints	Alvaro Herrera	08:45
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints	Alvaro Herrera	09:17
Re: Test to dump and restore objects left behind by regression	Alvaro Herrera	09:19

Browse Archives

Prev | Next