pgsql-hackers since 2025-03-09 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 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
[Proposal] Expose internal MultiXact member count function for efficient monitoring	Naga Appani	15:43
Re: Query ID Calculation Fix for DISTINCT / ORDER BY and LIMIT / OFFSET	Sami Imseih	15:49
Re: per backend WAL statistics	Nazir Bilal Yavuz	16:07
Re: Printing window function OVER clauses in EXPLAIN 📎	Tom Lane	16:18
Re: table_tuple_lock's snapshot argument	Ranier Vilela	16:20
Re: table_tuple_lock's snapshot argument	Heikki Linnakangas	16:52
Re: table_tuple_lock's snapshot argument	Ranier Vilela	16:55
Re: Query ID Calculation Fix for DISTINCT / ORDER BY and LIMIT / OFFSET 📎	Sami Imseih	17:20
Re: Changing the state of data checksums in a running cluster 📎	Tomas Vondra	17:35
Re: track generic and custom plans in pg_stat_statements	Sami Imseih	17:46
Re: bogus error message for ALTER TABLE ALTER CONSTRAINT 📎	Álvaro Herrera	17:58
Re: Add “FOR UPDATE NOWAIT” lock details to the log. 📎	Fujii Masao	18:07
Re: AIO v2.5 📎	Andres Freund	18:23
Re: dblink: Add SCRAM pass-through authentication 📎	Jacob Champion	18:25
Re: Parallel heap vacuum	Masahiko Sawada	18:27
Re: refactor AlterDomainAddConstraint (alter domain add constraint)	Alvaro Herrera	18:37
Re: BitmapHeapScan streaming read user and prelim refactoring 📎	Melanie Plageman	19:06
Re: sslinfo extension - add notbefore and notafter timestamps 📎	Cary Huang	19:29
Re: RFC: Additional Directory for Extensions 📎	Matheus Alcantara	20:25
RE: CRC32C Parallel Computation Optimization on ARM	Devulapalli, Raghuveer	20:36
Re: Log connection establishment timings	Daniel Gustafsson	21:02
Re: [PATCH] Add reverse(bytea)	Nathan Bossart	21:06
Re: [PATCH] Add reverse(bytea)	Daniel Gustafsson	21:08
Documentation Edits for pg_createsubscriber 📎	David G. Johnston	21:19
Re: Improve CRC32C performance on SSE4.2	Nathan Bossart	21:47
Re: Statistics Import and Export: difference in statistics dumped	Tom Lane	21:53
Re: meson vs. llvm bitcode files 📎	Diego Fronza	22:04
Re: BitmapHeapScan streaming read user and prelim refactoring 📎	Melanie Plageman	22:11
Re: encode/decode support for base64url	Cary Huang	22:51
Re: encode/decode support for base64url	Przemysław Sztoch	23:01
Re: Parallel heap vacuum	Masahiko Sawada	23:29
Re: BitmapHeapScan streaming read user and prelim refactoring 📎	Melanie Plageman	23:45
Re: Statistics Import and Export: difference in statistics dumped	Jeff Davis	23:53

March 11, 2025

Thread	Author	Time
Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility.	Peter Smith	00:00
Re: Parallel heap vacuum	Melanie Plageman	00:03
Re: per backend WAL statistics	Michael Paquier	00:06
Re: Memory context can be its own parent and child in replication command	Michael Paquier	00:09
Question about duplicate JSONTYPE_JSON check	Maciek Sakrejda	00:11
Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility.	David G. Johnston	00:31
Re: Memory context can be its own parent and child in replication command	Tom Lane	01:13
Re: Printing window function OVER clauses in EXPLAIN	David Rowley	01:16
Tidy recent code bloat in pg_creatersubscriber::cleanup_objects_atexit 📎	Peter Smith	01:29
Re: CRC32C Parallel Computation Optimization on ARM	John Naylor	01:30
Re: [Patch] remove duplicated smgrclose	Junwang Zhao	01:38
Re: FileFallocate misbehaving on XFS	Michael Harris	01:39
Re: Trigger more frequent autovacuums	wenhui qiu	02:00
RE: Documentation Edits for pg_createsubscriber	Hayato Kuroda (Fujitsu)	02:56
Re: Documentation Edits for pg_createsubscriber	David G. Johnston	03:36
Re: Anti join confusion	Richard Guo	03:46
Re: Commitfest app release on Feb 17 with many improvements	vignesh C	03:47
Re: Add arbitrary xid and mxid to pg_resetwal 📎	Daniil Davydov	03:47
Re: Commit fest 2025-03	vignesh C	04:11
support ALTER COLUMN SET EXPRESSION over virtual generated column with check constraint 📎	jian he	04:17
Re: Add an option to skip loading missing publication to avoid logical replication failure	Dilip Kumar	04:17
Re: Documentation Edits for pg_createsubscriber	Peter Smith	04:26
Re: bogus error message for ALTER TABLE ALTER CONSTRAINT	Amul Sul	04:32
Re: [Proposal] Expose internal MultiXact member count function for efficient monitoring	Naga Appani	05:15

Browse Archives

Prev | Next