pgsql-hackers since 2025-03-10 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 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
Re: Conflict detection for multiple_unique_conflicts in logical replication	Dilip Kumar	05:40
Re: SQL Property Graph Queries (SQL/PGQ) 📎	Junwang Zhao	06:06
protocol support for labels	Jeremy Schneider	06:09
Re: [BUG]: the walsender does not update its IO statistics until it exits	Bertrand Drouvot	06:10
Re: per backend WAL statistics	Bertrand Drouvot	06:23
Re: change on_exit_nicely_list array to the dynamic array to increase slots at run time for pg_restore	Dilip Kumar	06:28
Re: Query ID Calculation Fix for DISTINCT / ORDER BY and LIMIT / OFFSET 📎	Michael Paquier	06:50
Re: bogus error message for ALTER TABLE ALTER CONSTRAINT	jian he	07:00
Re: Tidy recent code bloat in pg_creatersubscriber::cleanup_objects_atexit	Michael Paquier	07:06
Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility.	Peter Smith	07:20
Re: SQL Property Graph Queries (SQL/PGQ) 📎	Ashutosh Bapat	07:21
Send multiple statements to pg server at once	Andy Fan	07:23
Re: Allow CI to only run the compiler warnings task 📎	Bertrand Drouvot	07:25
Re: Send multiple statements to pg server at once	Pavel Stehule	07:29
Re: Send multiple statements to pg server at once	Andy Fan	07:38
Re: Query ID Calculation Fix for DISTINCT / ORDER BY and LIMIT / OFFSET	David Rowley	07:48
Re: Add “FOR UPDATE NOWAIT” lock details to the log.	Yuki Seino	07:50
Re: encode/decode support for base64url 📎	Florents Tselai	08:08
Re: Emitting JSON to file using COPY TO 📎	jian he	08:23
Re: bogus error message for ALTER TABLE ALTER CONSTRAINT	Álvaro Herrera	08:26
Re: [PATCH] Add reverse(bytea)	Aleksander Alekseev	08:29
Re: Selectively invalidate caches in pgoutput module 📎	Amit Kapila	08:52
Re: Conflict detection for multiple_unique_conflicts in logical replication	Nisha Moond	08:58
Re: SQL Property Graph Queries (SQL/PGQ)	Amit Langote	09:06
Re: NOT ENFORCED constraint feature	Álvaro Herrera	09:07
Re: Elimination of the repetitive code at the SLRU bootstrap functions. 📎	Evgeny	09:12
Re: Memory context can be its own parent and child in replication command	Anthonin Bonnefoy	09:26
Re: Reducing the log spam 📎	Laurenz Albe	09:46
RE: Query ID Calculation Fix for DISTINCT / ORDER BY and LIMIT / OFFSET 📎	Bykov Ivan	09:47
Re: [Proposal] Expose internal MultiXact member count function for efficient monitoring	Kirill Reshke	09:48
Re: explain analyze rows=%.0f	Ilia Evdokimov	09:58
Re: protocol support for labels	Kirill Reshke	10:03
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints 📎	Rushabh Lathia	10:15
Re: Statistics Import and Export: difference in statistics dumped	Ashutosh Bapat	10:20
Re: bogus error message for ALTER TABLE ALTER CONSTRAINT	Álvaro Herrera	10:21
Re: Query ID Calculation Fix for DISTINCT / ORDER BY and LIMIT / OFFSET	Michael Paquier	10:28
Re: Add an option to skip loading missing publication to avoid logical replication failure 📎	vignesh C	10:30
Re: Change COPY ... ON_ERROR ignore to ON_ERROR ignore_row	Jim Jones	10:31
Re: Accessing an invalid pointer in BufferManagerRelation structure 📎	Daniil Davydov	10:32
Statistics import and export: difference in statistics of materialized view dumped 📎	Ashutosh Bapat	10:38
Re: pg_upgrade: Support for upgrading to checksums enabled 📎	Peter Eisentraut	10:42
Re: Test to dump and restore objects left behind by regression 📎	Ashutosh Bapat	10:44
RE: Selectively invalidate caches in pgoutput module 📎	Zhijie Hou (Fujitsu)	10:53

Browse Archives

Prev | Next