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

Thread	Author	Time
Re: doc: expand note about pg_upgrade's --jobs option	Magnus Hagander	00:43
Re: ZStandard (with dictionaries) compression support for TOAST compression	Nikhil Kumar Veldanda	01:35
Re: per backend WAL statistics	Michael Paquier	01:57
Re: AIO v2.5	Andres Freund	02:11
Re: Why doesn't GiST VACUUM require a super-exclusive lock, like nbtree VACUUM? 📎	Matthias van de Meent	02:36
Clear errno in spell.c 📎	Jacob Brazeal	02:55
Re: Statistics Import and Export	Corey Huinker	03:40
Re: Statistics Import and Export	Corey Huinker	03:43
Re: [Patch] remove duplicated smgrclose	Masahiko Sawada	04:04
Re: support virtual generated column not null constraint	Xuneng Zhou	04:23
Re: support virtual generated column not null constraint	Xuneng Zhou	04:30
Re: Allow database owners to CREATE EVENT TRIGGER	Steve Chavez	05:03
Re: Parallel heap vacuum	Masahiko Sawada	05:30
Re: Statistics Import and Export	Hari Krishna Sunder	05:51
RE: Selectively invalidate caches in pgoutput module 📎	Hayato Kuroda (Fujitsu)	06:04
Re: Parallel heap vacuum 📎	Masahiko Sawada	06:41
Re: Statistics Import and Export	Corey Huinker	07:51
Re: per backend WAL statistics	Bertrand Drouvot	07:53
Re: Statistics Import and Export 📎	Corey Huinker	07:56
Re: Add contrib/pg_logicalsnapinspect	Bertrand Drouvot	07:58
Re: [Patch] remove duplicated smgrclose	Junwang Zhao	09:05
Re: [Patch] remove duplicated smgrclose	Junwang Zhao	09:37
Re: [Patch] remove duplicated smgrclose	Masahiko Sawada	09:45
Re: Why does exec_simple_query requires 2 snapshots	Michail Nikolaev	09:51
Re: pgsql: reindexdb: Add the index-level REINDEX with multiple jobs	Álvaro Herrera	09:56
Re: support virtual generated column not null constraint 📎	jian he	10:10
Re: pgsql: reindexdb: Add the index-level REINDEX with multiple jobs	Alexander Korotkov	10:42
Re: pgsql: reindexdb: Add the index-level REINDEX with multiple jobs	Alexander Korotkov	10:49
Re: pg_atomic_compare_exchange_*() and memory barriers	Alexander Korotkov	12:12
Re: pg_atomic_compare_exchange_*() and memory barriers	Andres Freund	13:02
Buildfarm coverage planning (was: what's going on with lapwing?)	Andrew Dunstan	13:11
Re: pg_atomic_compare_exchange_*() and memory barriers	Andres Freund	13:41
Re: Clarification on Role Access Rights to Table Indexes	Ayush Vatsa	15:04
Re: pg_atomic_compare_exchange_*() and memory barriers	Alexander Korotkov	15:06
Re: pg_atomic_compare_exchange_*() and memory barriers	Andres Freund	15:20
Re: RFC: Logging plan of the running query	Akshat Jaimini	15:42
Re: Statistics Import and Export	Robert Treat	15:56
Re: Clear errno in spell.c	Tom Lane	16:08
Re: Special-case executor expression steps for common combinations	Andreas Karlsson	16:15
Re: ZStandard (with dictionaries) compression support for TOAST compression 📎	Nikhil Kumar Veldanda	16:28
Re: Adding skip scan (including MDAM style range skip scan) to nbtree 📎	Peter Geoghegan	16:43
Re: Showing primitive index scan count in EXPLAIN ANALYZE (for skip scan and SAOP scans) 📎	Peter Geoghegan	16:47
Re: pg16 && GSSAPI && Heimdal/Macos	Todd M. Kover	17:38
Re: pg16 && GSSAPI && Heimdal/Macos	Tom Lane	19:02
Re: Statistics Import and Export	Corey Huinker	19:09
Re: doc: expand note about pg_upgrade's --jobs option	Nathan Bossart	20:30
Re: strange valgrind reports about wrapper_handler on 64-bit arm	Tomas Vondra	20:38
Re: Clarification on Role Access Rights to Table Indexes	Nathan Bossart	21:08
Re: Assert when executing query on partitioned table 📎	Joseph Koshakow	21:28
Re: Clarification on Role Access Rights to Table Indexes	Ayush Vatsa	21:31
Printing window function OVER clauses in EXPLAIN 📎	Tom Lane	21:39
Re: Clarification on Role Access Rights to Table Indexes 📎	Nathan Bossart	21:57
Re: pg16 && GSSAPI && Heimdal/Macos	Todd M. Kover	21:58
Re: Clarification on Role Access Rights to Table Indexes	Tom Lane	22:17
Re: pg16 && GSSAPI && Heimdal/Macos	Tom Lane	22:26
Re: encode/decode support for base64url	Florents Tselai	22:27
Re: strange valgrind reports about wrapper_handler on 64-bit arm 📎	Tomas Vondra	22:48

March 9, 2025

Thread	Author	Time
Re: Printing window function OVER clauses in EXPLAIN	David Rowley	01:15
Re: Clarification on Role Access Rights to Table Indexes	Nathan Bossart	01:35
Re: strange valgrind reports about wrapper_handler on 64-bit arm	Nathan Bossart	02:16
Re: Commitfest app release on Feb 17 with many improvements	vignesh C	02:20
Re: Printing window function OVER clauses in EXPLAIN	David G. Johnston	02:31
Re: pgsql: reindexdb: Add the index-level REINDEX with multiple jobs 📎	Alexander Korotkov	02:53
Re: Add an option to skip loading missing publication to avoid logical replication failure	Masahiko Sawada	03:29
Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options	Tatsuo Ishii	06:39
Incorrect assert in libpqwalreceiver 📎	Jacob Brazeal	08:09
Re: Introduce new multi insert Table AM and improve performance of various SQL commands with it for Heap AM 📎	Daniil Davydov	11:27
Re: Enhance file_fdw to report processed and skipped tuples in COPY progress	vignesh C	11:38
Re: [Doc] Improve hostssl related descriptions and option presentation	vignesh C	11:42
Re: Considering fractional paths in Append node 📎	Alexander Korotkov	11:44
Re: Commit fest 2025-03	vignesh C	12:10
Re: MergeJoin beats HashJoin in the case of multiple hash clauses 📎	Alexander Korotkov	12:13
Re: Why doesn't GiST VACUUM require a super-exclusive lock, like nbtree VACUUM?	Michail Nikolaev	12:44
Re: Commitfest app release on Feb 17 with many improvements	Jelte Fennema-Nio	13:35
Re: general purpose array_sort 📎	jian he	13:41
Re: Printing window function OVER clauses in EXPLAIN	Álvaro Herrera	14:12
Re: Printing window function OVER clauses in EXPLAIN	Tom Lane	15:45
Re: Clarification on Role Access Rights to Table Indexes	Tom Lane	15:48
Re: Parallel CREATE INDEX for GIN indexes	Tom Lane	16:38
Re: BackgroundPsql swallowing errors on windows	Andres Freund	16:47
Re: Statistics Import and Export	Jeff Davis	17:00
Re: strange valgrind reports about wrapper_handler on 64-bit arm	Tomas Vondra	17:11
Re: BackgroundPsql swallowing errors on windows	Noah Misch	17:23
Re: AIO v2.5	Tom Lane	17:51
Re: Changing the state of data checksums in a running cluster 📎	Tomas Vondra	17:57
Re: Considering fractional paths in Append node	Nikita Malakhov	18:26
maintenance_work_mem = 64kB doesn't work for vacuum	Masahiko Sawada	18:45
Re: Incorrect assert in libpqwalreceiver	Heikki Linnakangas	18:46
Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options 📎	Oliver Ford	20:07
Re: maintenance_work_mem = 64kB doesn't work for vacuum	David Rowley	21:30
Re: pgsql: reindexdb: Add the index-level REINDEX with multiple jobs 📎	Alexander Korotkov	21:53
Re: Parallel CREATE INDEX for GIN indexes	Tomas Vondra	22:17
Re: Printing window function OVER clauses in EXPLAIN 📎	Tom Lane	22:19
Re: Parallel CREATE INDEX for GIN indexes	Tom Lane	22:23
Re: Parallel CREATE INDEX for GIN indexes	Peter Geoghegan	22:27
Re: Special-case executor expression steps for common combinations	Daniel Gustafsson	22:35
Re: Add regression test checking combinations of (object,backend_type,context) in pg_stat_io	Michael Paquier	22:55
Re: Changing the state of data checksums in a running cluster 📎	Tomas Vondra	23:35
Re: Query ID Calculation Fix for DISTINCT / ORDER BY and LIMIT / OFFSET	Michael Paquier	23:38
Re: Enhance file_fdw to report processed and skipped tuples in COPY progress	Fujii Masao	23:47

March 10, 2025

Thread	Author	Time
Re: Printing window function OVER clauses in EXPLAIN	David Rowley	00:14
Re: Changing the state of data checksums in a running cluster 📎	Tomas Vondra	00:18
Re: [BUG]: the walsender does not update its IO statistics until it exits	Michael Paquier	00:23
Re: Printing window function OVER clauses in EXPLAIN	Tom Lane	01:13
Re: Query ID Calculation Fix for DISTINCT / ORDER BY and LIMIT / OFFSET	David Rowley	01:14
Re: Printing window function OVER clauses in EXPLAIN	David Rowley	01:17
Re: Query ID Calculation Fix for DISTINCT / ORDER BY and LIMIT / OFFSET	Michael Paquier	01:19
Re: maintenance_work_mem = 64kB doesn't work for vacuum	John Naylor	01:23
Re: maintenance_work_mem = 64kB doesn't work for vacuum	Melanie Plageman	01:45
Re: maintenance_work_mem = 64kB doesn't work for vacuum 📎	David Rowley	02:03
Re: CREATE OR REPLACE MATERIALIZED VIEW 📎	Erik Wienhold	02:46
Re: Make tuple deformation faster 📎	David Rowley	03:24
Re: Add an option to skip loading missing publication to avoid logical replication failure	Amit Kapila	03:33
Re: Add an option to skip loading missing publication to avoid logical replication failure	Amit Kapila	04:02
Re: Parallel heap vacuum	Peter Smith	04:05
Re: Parallel heap vacuum	Peter Smith	04:11
Re: maintenance_work_mem = 64kB doesn't work for vacuum	Masahiko Sawada	04:22
Re: Add an option to skip loading missing publication to avoid logical replication failure	Dilip Kumar	04:44
RE: Selectively invalidate caches in pgoutput module 📎	Hayato Kuroda (Fujitsu)	04:45
Re: [Doc] Improve hostssl related descriptions and option presentation	David G. Johnston	04:54
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Ashutosh Bapat	04:58
Re: RFC: Logging plan of the running query 📎	torikoshia	05:10
Re: Add an option to skip loading missing publication to avoid logical replication failure	Amit Kapila	05:24
Re: Back-patch of: avoid multiple hard links to same WAL file after a crash 📎	Michael Paquier	05:25
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Ajin Cherian	05:34
Re: vacuumdb changes for stats import/export	John Naylor	05:35
Re: Orphaned users in PG16 and above can only be managed by Superusers	Ashutosh Sharma	05:45
Re: Printing window function OVER clauses in EXPLAIN	Álvaro Herrera	06:08
Re: Parallel heap vacuum	Amit Kapila	06:12
Re: Restrict copying of invalidated replication slots 📎	Shlok Kyal	06:16
Re: Back-patch of: avoid multiple hard links to same WAL file after a crash	Michael Paquier	06:21
Re: Log connection establishment timings	Bertrand Drouvot	06:24
Re: Parallel heap vacuum	Amit Kapila	06:28
Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility. 📎	Shubham Khanna	06:30
Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility.	Shubham Khanna	06:41
Re: SQLFunctionCache and generic plans	Pavel Stehule	06:58
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Shubham Khanna	07:04
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided. 📎	Shubham Khanna	07:06
Re: Coccinelle for PostgreSQL development [1/N]: coccicheck.py 📎	Mats Kindahl	07:08
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Shubham Khanna	07:08
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided.	Shubham Khanna	07:09
[PATCH] Add reverse(bytea) 📎	Aleksander Alekseev	07:40
Re: Parallel heap vacuum	Peter Smith	07:46
Re: per backend WAL statistics 📎	Michael Paquier	07:46
Re: Non-text mode for pg_dumpall 📎	jian he	07:54
Re: FSM doesn't recover after zeroing damaged page.	Stepan Neretin	07:58
Re: Memory context can be its own parent and child in replication command	Anthonin Bonnefoy	08:07
Re: Xact end leaves CurrentMemoryContext = TopMemoryContext	Anthonin Bonnefoy	08:41
Re: Improve CRC32C performance on SSE4.2 📎	John Naylor	08:48
change on_exit_nicely_list array to the dynamic array to increase slots at run time for pg_restore 📎	Mahendra Singh Thalor	08:54
Re: Vacuum statistics	Ilia Evdokimov	09:13
Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility.	Nisha Moond	09:39
Re: [PoC] XMLCast (SQL/XML X025) 📎	Jim Jones	09:41
Re: NOT ENFORCED constraint feature 📎	Amul Sul	09:42
Re: Changing the state of data checksums in a running cluster 📎	Tomas Vondra	09:46
Re: 64 bit numbers vs format strings	Peter Eisentraut	09:49
Re: maintenance_work_mem = 64kB doesn't work for vacuum	David Rowley	09:53
Re: [Patch] remove duplicated smgrclose	Steven Niu	10:07
Re: Draft for basic NUMA observability	Bertrand Drouvot	10:14
RE: Query ID Calculation Fix for DISTINCT / ORDER BY and LIMIT / OFFSET 📎	Bykov Ivan	10:17
Re: SQL:2011 application time	Peter Eisentraut	10:56
RE: Selectively invalidate caches in pgoutput module 📎	Hayato Kuroda (Fujitsu)	10:59
Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility. 📎	Shubham Khanna	11:01
Re: track generic and custom plans in pg_stat_statements	Ilia Evdokimov	11:01
RE: Selectively invalidate caches in pgoutput module	Zhijie Hou (Fujitsu)	11:07
Re: pgsql: reindexdb: Add the index-level REINDEX with multiple jobs	Álvaro Herrera	11:12
Re: Changing the state of data checksums in a running cluster 📎	Tomas Vondra	11:17
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints 📎	Rushabh Lathia	11:26
Re: encode/decode support for base64url 📎	Florents Tselai	11:28
Re: Implement waiting for wal lsn replay: reloaded 📎	Alexander Korotkov	11:30
Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility.	Nisha Moond	11:31
Re: Query ID Calculation Fix for DISTINCT / ORDER BY and LIMIT / OFFSET 📎	David Rowley	11:45
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints	Alvaro Herrera	11:50
Re: per backend WAL statistics 📎	Bertrand Drouvot	11:52
Re: per backend WAL statistics	Nazir Bilal Yavuz	12:08
Re: pg_attribute_noreturn(), MSVC, C11 📎	Peter Eisentraut	12:27
Re: Extensible storage manager API - SMGR hook Redux	Kirill Reshke	12:30
Re: encode/decode support for base64url	Daniel Gustafsson	12:31
Re: encode/decode support for base64url	Florents Tselai	12:43
Re: INSERT ... ON CONFLICT DO SELECT [FOR ...] take 2	Kirill Reshke	13:05
Re: Wrong results with subquery pullup and grouping sets 📎	Richard Guo	13:05
Re: INSERT ... ON CONFLICT DO SELECT [FOR ...] take 2	Kirill Reshke	13:10
Re: Add “FOR UPDATE NOWAIT” lock details to the log. 📎	Yuki Seino	13:11
RE: Selectively invalidate caches in pgoutput module 📎	Hayato Kuroda (Fujitsu)	13:12
Re: Changing the state of data checksums in a running cluster	Daniel Gustafsson	13:27
Re: Vacuum statistics	Kirill Reshke	13:33
Re: change on_exit_nicely_list array to the dynamic array to increase slots at run time for pg_restore	Tom Lane	13:43
Re: FSM doesn't recover after zeroing damaged page.	Kirill Reshke	13:56
Re: pg_attribute_noreturn(), MSVC, C11	Andres Freund	13:58
Re: pg_attribute_noreturn(), MSVC, C11	Peter Eisentraut	14:37
Re: pg_attribute_noreturn(), MSVC, C11	Andres Freund	14:38
Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility. 📎	Shubham Khanna	14:42
Re: per backend WAL statistics	Bertrand Drouvot	14:43
Re: [BUG]: the walsender does not update its IO statistics until it exits	Bertrand Drouvot	14:52
Re: Orphaned users in PG16 and above can only be managed by Superusers	Nathan Bossart	15:01
Re: Changing the state of data checksums in a running cluster 📎	Tomas Vondra	15:01
Re: vacuumdb changes for stats import/export	Nathan Bossart	15:08
Re: Clarification on Role Access Rights to Table Indexes	Nathan Bossart	15:15
Re: Changing the state of data checksums in a running cluster	Tomas Vondra	15:16
Re: table_tuple_lock's snapshot argument	Heikki Linnakangas	15:22

Browse Archives

Prev | Next