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

Thread	Author	Time
Re: BitmapHeapScan streaming read user and prelim refactoring	Andres Freund	00:07
Re: Question about duplicate JSONTYPE_JSON check	Maciek Sakrejda	00:41
Re: Back-patch of: avoid multiple hard links to same WAL file after a crash	Michael Paquier	00:46
Re: Query ID Calculation Fix for DISTINCT / ORDER BY and LIMIT / OFFSET	Michael Paquier	00:51
Re: Question about duplicate JSONTYPE_JSON check	Tender Wang	01:00
Re: Conflict detection for multiple_unique_conflicts in logical replication	Peter Smith	01:02
Re: [BUG?] check_exclusion_or_unique_constraint false negative 📎	Mihail Nikalayeu	01:05
Re: Back-patch of: avoid multiple hard links to same WAL file after a crash	Noah Misch	01:23
Re: Query ID Calculation Fix for DISTINCT / ORDER BY and LIMIT / OFFSET	David Rowley	02:28
Re: Question about duplicate JSONTYPE_JSON check	Amit Langote	03:07
Re: per backend WAL statistics	Tom Lane	03:14
Re: Logical Replication of sequences 📎	vignesh C	03:44
Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility.	Amit Kapila	03:52
Re: AIO v2.5	Noah Misch	03:57
Re: Optimization for lower(), upper(), casefold() functions. 📎	Jeff Davis	04:05
Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility.	Amit Kapila	04:10
Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility.	David G. Johnston	04:13
Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility.	David G. Johnston	04:22
Re: SQL Property Graph Queries (SQL/PGQ)	Ashutosh Bapat	04:31
Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility.	Amit Kapila	04:34
Re: Conflict detection for multiple_unique_conflicts in logical replication	Dilip Kumar	04:47
Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility.	David G. Johnston	05:12
Re: Orphaned users in PG16 and above can only be managed by Superusers	Ashutosh Sharma	05:20
RE: Documentation Edits for pg_createsubscriber	Hayato Kuroda (Fujitsu)	05:29
Re: pg_recvlogical requires -d but not described on the documentation	vignesh C	05:32
Re: per backend WAL statistics 📎	Bertrand Drouvot	05:37
Re: Parallel heap vacuum	Dilip Kumar	05:54
Re: pg_recvlogical requires -d but not described on the documentation	David G. Johnston	05:59
Re: pg_recvlogical requires -d but not described on the documentation	David G. Johnston	06:08
Re: Elimination of the repetitive code at the SLRU bootstrap functions.	Andrey Borodin	06:25
Re: Parallel heap vacuum	Dilip Kumar	06:26
Re: Orphaned users in PG16 and above can only be managed by Superusers	Ashutosh Sharma	06:40
Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility.	Amit Kapila	06:41
Re: CRC32C Parallel Computation Optimization on ARM	John Naylor	06:51
Re: Improve CRC32C performance on SSE4.2	John Naylor	06:54
Re: vacuumdb changes for stats import/export	John Naylor	06:56
Re: Non-text mode for pg_dumpall	jian he	07:03
Re: [PoC] Add CANONICAL option to xmlserialize	newtglobal postgresql_contributors	07:21
Re: [PoC] Reducing planning time when tables have many partitions	newtglobal postgresql_contributors	07:23
Re: Non-text mode for pg_dumpall	Laurenz Albe	07:24
Re: Proposal: Limitations of palloc inside checkpointer	Xuneng Zhou	07:27
Re: Wrong results with subquery pullup and grouping sets 📎	Richard Guo	07:45
Re: [PoC] Add CANONICAL option to xmlserialize	Jim Jones	07:49
Re: Add Postgres module info 📎	Andrei Lepikhov	07:58
Re: Change COPY ... ON_ERROR ignore to ON_ERROR ignore_row	jian he	08:00
Re: Question about duplicate JSONTYPE_JSON check 📎	Amit Langote	08:04
Re: Change COPY ... ON_ERROR ignore to ON_ERROR ignore_row	Jim Jones	08:25
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints	Ashutosh Bapat	08:27
Re: Special-case executor expression steps for common combinations	Daniel Gustafsson	08:57
Re: DOCS - Generated Column Replication Examples	vignesh C	08:58
Re: Memory context can be its own parent and child in replication command 📎	Anthonin Bonnefoy	09:13
Re: Wrong results with subquery pullup and grouping sets	Dean Rasheed	09:28
Re: SQL function which allows to distinguish a server being in point in time recovery mode and an ordinary replica	vignesh C	09:30
Re: Selectively invalidate caches in pgoutput module 📎	Amit Kapila	09:30
Re: pgsql: reindexdb: Add the index-level REINDEX with multiple jobs	Álvaro Herrera	09:41
Re: Conflict detection for multiple_unique_conflicts in logical replication 📎	Nisha Moond	09:45
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints	Alvaro Herrera	09:50
Re: NOT ENFORCED constraint feature 📎	Amul Sul	10:02
Re: dblink query interruptibility	Andreas Karlsson	10:03
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints	Rushabh Lathia	10:04
Re: Parallel heap vacuum	Amit Kapila	10:05
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints	Ashutosh Bapat	10:08
Re: Question about duplicate JSONTYPE_JSON check	Álvaro Herrera	10:09
Re: Parallel heap vacuum	Amit Kapila	10:10
Re: Parallel heap vacuum	Dilip Kumar	10:18
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints 📎	Rushabh Lathia	10:22
Re: Test mail for pgsql-hackers	Ashutosh Bapat	10:26
Re: meson vs. llvm bitcode files 📎	Nazir Bilal Yavuz	10:26
Re: Add an option to skip loading missing publication to avoid logical replication failure	Amit Kapila	10:34
Re: [PATCH] SVE popcount support 📎	Chiranmoy.Bhattacharya@fujitsu.com	10:34
Re: Index AM API cleanup 📎	Peter Eisentraut	10:40
Re: Add an option to skip loading missing publication to avoid logical replication failure	Dilip Kumar	10:45
Re: Improve monitoring of shared memory allocations 📎	Rahila Syed	10:46
Re: Vacuum timing in pg_stat_all_tables 📎	Bertrand Drouvot	10:52
Re: Statistics import and export: difference in statistics of materialized view dumped	Ashutosh Bapat	10:59
Re: Proposal: Limitations of palloc inside checkpointer	Maxim Orlov	11:00
Re: INSERT ... ON CONFLICT DO SELECT [FOR ...] take 2	Dean Rasheed	11:02
Re: per backend WAL statistics	Michael Paquier	11:32
Re: Logical Replication of sequences	vignesh C	11:34
Re: Conflict detection for update_deleted in logical replication	vignesh C	11:36
Re: Separate GUC for replication origins	vignesh C	11:47
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints	Ashutosh Bapat	11:51
Re: Bypassing cursors in postgres_fdw to enable parallel plans	Andy Fan	11:57
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints	Alvaro Herrera	11:57
Re: Test to dump and restore objects left behind by regression	Alvaro Herrera	12:05
RE: Selectively invalidate caches in pgoutput module 📎	Hayato Kuroda (Fujitsu)	12:15
Re: Question about duplicate JSONTYPE_JSON check	Amit Langote	12:26
Re: Test mail for pgsql-hackers	David G. Johnston	12:28
Re: Changing the state of data checksums in a running cluster	Tomas Vondra	12:28
Re: Document NULL	Marcos Pegoraro	12:36
Re: Question about duplicate JSONTYPE_JSON check	Álvaro Herrera	12:40
Re: Document NULL	David G. Johnston	12:48
Re: Change log level for notifying hot standby is waiting non-overflowed snapshot 📎	torikoshia	12:57
Re: Changing the state of data checksums in a running cluster	Dagfinn Ilmari Mannsåker	13:08
Re: Changing the state of data checksums in a running cluster 📎	Tomas Vondra	13:16
Re: RFC: Additional Directory for Extensions 📎	Matheus Alcantara	13:17
Re: meson vs. llvm bitcode files	Diego Fronza	13:39
Re: Index AM API cleanup 📎	Peter Eisentraut	14:00
Re: Index AM API cleanup	Tom Lane	14:25
Re: Proposal: Progressive explain	Euler Taveira	14:25
Re: Implement waiting for wal lsn replay: reloaded 📎	Yura Sokolov	14:44
Re: Elimination of the repetitive code at the SLRU bootstrap functions. 📎	Evgeny Voropaev	15:02
Re: dblink: Add SCRAM pass-through authentication 📎	Jacob Champion	15:17
Re: Optimizing FastPathTransferRelationLocks()	Ashutosh Bapat	15:32
Re: Orphaned users in PG16 and above can only be managed by Superusers	Nathan Bossart	15:36
Re: Elimination of the repetitive code at the SLRU bootstrap functions.	Andrey Borodin	15:41
Re: Draft for basic NUMA observability 📎	Jakub Wartak	15:41
Re: Log connection establishment timings	Melanie Plageman	15:43
Re: Introduce "log_connection_stages" setting.	Melanie Plageman	15:48
Re: Non-text mode for pg_dumpall	Andrew Dunstan	15:48
remove open-coded popcount in acl.c 📎	Nathan Bossart	15:50
Re: Index AM API cleanup	Mark Dilger	15:52
Re: Test to dump and restore objects left behind by regression	Ashutosh Bapat	15:58
Re: Index AM API cleanup	Mark Dilger	16:08
Re: Test to dump and restore objects left behind by regression	Alvaro Herrera	16:09
Re: AIO v2.5	Andres Freund	16:10
Re: Add pg_buffercache_evict_all() and pg_buffercache_mark_dirty[_all]() functions	Nazir Bilal Yavuz	16:15
Re: remove open-coded popcount in acl.c	Álvaro Herrera	16:23
Re: Document NULL	Álvaro Herrera	16:27
Re: Question about duplicate JSONTYPE_JSON check	Maciek Sakrejda	16:27
001_rep_changes.pl succeeds after a long time	Álvaro Herrera	16:28
Re: Optimization for lower(), upper(), casefold() functions. 📎	Alexander Borisov	16:55
Re: AIO v2.5	Andres Freund	17:06
Re: Parallel safety docs for CTEs	James Coleman	17:11
RE: CRC32C Parallel Computation Optimization on ARM	Devulapalli, Raghuveer	17:49
Rename functions to alloc/free things in reorderbuffer.c 📎	Heikki Linnakangas	17:53
Re: Primary and standby setting cross-checks	Kirill Reshke	18:09
Re: Replace IN VALUES with ANY in WHERE clauses during optimization	Alena Rybakina	18:11
Re: remove open-coded popcount in acl.c 📎	Nathan Bossart	18:19
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints	Alvaro Herrera	18:20
Re: [PATCH] SVE popcount support	Nathan Bossart	18:32
Re: remove open-coded popcount in acl.c	Álvaro Herrera	18:34
Re: remove open-coded popcount in acl.c	Nathan Bossart	18:35
Re: Handle interrupts while waiting on Append's async subplans	Heikki Linnakangas	19:16
Re: Rename functions to alloc/free things in reorderbuffer.c	Tom Lane	19:31
Re: Optimization for lower(), upper(), casefold() functions.	Alexander Borisov	19:32
Re: vacuumdb changes for stats import/export 📎	Nathan Bossart	19:34
Re: Vacuum statistics	Alena Rybakina	19:36
Re: making EXPLAIN extensible	Sami Imseih	19:38
Re: Optimization for lower(), upper(), casefold() functions. 📎	Jeff Davis	19:39
Re: Vacuum statistics	Alena Rybakina	19:41
Re: making EXPLAIN extensible	Tom Lane	19:50
Missing constraint when duplicated unique index ?	Marcos Pegoraro	19:52
Re: making EXPLAIN extensible	Sami Imseih	19:58
Re: BitmapHeapScan streaming read user and prelim refactoring	Melanie Plageman	20:01
Re: Rename functions to alloc/free things in reorderbuffer.c	Heikki Linnakangas	20:04
Re: remove open-coded popcount in acl.c	Nathan Bossart	20:04
Re: Adding skip scan (including MDAM style range skip scan) to nbtree	Alena Rybakina	20:28
Re: Optimization for lower(), upper(), casefold() functions. 📎	Alexander Borisov	20:39
Re: Adding skip scan (including MDAM style range skip scan) to nbtree	Peter Geoghegan	20:50
Re: Add an option to skip loading missing publication to avoid logical replication failure	Masahiko Sawada	21:51
Re: Add connection active, idle time to pg_stat_activity	Sadeq Dousti	22:00
Re: Vacuum statistics	Jim Nasby	22:15
Re: [PATCH] pg_stat_activity: make slow/hanging authentication more visible	Jacob Champion	22:16
Re: AIO v2.5 📎	Andres Freund	23:23
Re: PGSERVICEFILE as part of a normal connection string	Ryo Kanbayashi	23:53

March 13, 2025

Thread	Author	Time
Re: Separate GUC for replication origins 📎	Euler Taveira	00:28
Dubious server log messages after pg_upgrade	Tom Lane	00:41
Re: PGSERVICEFILE as part of a normal connection string	Michael Paquier	00:42
Re: pg_rewind with --write-recovery-conf option doesn't write dbname to primary_conninfo value.	Masahiko Sawada	01:05
Re: Dubious server log messages after pg_upgrade	Nathan Bossart	01:39
Re: Separate GUC for replication origins	vignesh C	02:06
Re: DOCS: Make the Server Application docs synopses more consistent 📎	Peter Smith	02:06
Re: Add an option to skip loading missing publication to avoid logical replication failure 📎	vignesh C	02:08
Re: Proposal: Filter irrelevant change before reassemble transactions during logical decoding 📎	Ajin Cherian	02:13
DOCS: Make the Server Application docs synopses more consistent	David G. Johnston	02:51
Re: DOCS: Make the Server Application docs synopses more consistent	David G. Johnston	03:17
Re: Add an option to skip loading missing publication to avoid logical replication failure	Dilip Kumar	03:48
Re: Question about duplicate JSONTYPE_JSON check	Amit Langote	03:51
pgsql: Avoid invalidating all RelationSyncCache entries on publication	Amit Kapila	04:00
Re: Add connection active, idle time to pg_stat_activity	Sadeq Dousti	04:50
Re: [PoC] Reducing planning time when tables have many partitions	David Rowley	04:53
Re: Add an option to skip loading missing publication to avoid logical replication failure	vignesh C	05:19
Re: Commitfest Manager for March	Peter Smith	05:22
RE: long-standing data loss bug in initial sync of logical replication 📎	Hayato Kuroda (Fujitsu)	05:29
Re: Orphaned users in PG16 and above can only be managed by Superusers	Ashutosh Sharma	05:44
Re: Commitfest Manager for March	vignesh C	06:07
Re: PGSERVICEFILE as part of a normal connection string	Laurenz Albe	06:07
Re: Add an option to skip loading missing publication to avoid logical replication failure	Dilip Kumar	06:13
Re: protocol support for labels	Jeremy Schneider	06:39
Re: Vacuum statistics	Bertrand Drouvot	06:42
Re: Proposal: Filter irrelevant change before reassemble transactions during logical decoding	Ajin Cherian	06:49
Re: in BeginCopyTo make materialized view using COPY TO instead of COPY (query).	newtglobal postgresql_contributors	06:50
Re: Add XMLNamespaces to XMLElement	newtglobal postgresql_contributors	06:51
Re: pg_dump, pg_dumpall, pg_restore: Add --no-policies option	newtglobal postgresql_contributors	06:52
Re: Test to dump and restore objects left behind by regression	Ashutosh Bapat	06:52
Re: Orphaned users in PG16 and above can only be managed by Superusers	Ashutosh Sharma	06:58
Re: Parallel heap vacuum	Masahiko Sawada	07:19
Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options 📎	Oliver Ford	07:49
Re: Wrong results with subquery pullup and grouping sets	Richard Guo	07:53
RE: long-standing data loss bug in initial sync of logical replication 📎	Hayato Kuroda (Fujitsu)	08:02
RE: 001_rep_changes.pl succeeds after a long time	Zhijie Hou (Fujitsu)	08:30
Re: [Patch] remove duplicated smgrclose	Steven Niu	08:36
Supporting TCP_SYNCNT in libpq 📎	Francesco Canovai	08:37
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints	Rushabh Lathia	08:37
RE: long-standing data loss bug in initial sync of logical replication	Hayato Kuroda (Fujitsu)	08:42
Re: Test to dump and restore objects left behind by regression	Alvaro Herrera	08:42
Re: Selectively invalidate caches in pgoutput module	Amit Kapila	08:43
Re: relfilenode statistics	Kirill Reshke	09:00
Random pg_upgrade 004_subscription test failure on drongo 📎	vignesh C	09:04

Browse Archives

Prev | Next