pgsql-hackers since 2025-04-02 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

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
Re: Fix 035_standby_logical_decoding.pl race conditions 📎	Amit Kapila	09:34
Re: Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment 📎	Ilia Evdokimov	09:35
Re: Hashed IN only applied to first encountered IN	David Geier	09:44
Re: statistics import and export: another difference in dump/restore 📎	Ashutosh Bapat	10:05
Re: Test to dump and restore objects left behind by regression	Ashutosh Bapat	10:06
Re: Using read stream in autoprewarm	Nazir Bilal Yavuz	10:26
Mention the default io_method?	Daniel Westermann (DWE)	10:28
Re: Mention the default io_method?	Pavel Stehule	10:32
Re: Fix 035_standby_logical_decoding.pl race conditions	Amit Kapila	10:39
Re: Fix 035_standby_logical_decoding.pl race conditions	Bertrand Drouvot	11:14
Re: pg_restore documentation and --create/--single-transaction limitation	Ashutosh Bapat	11:16
Small optimization set tuple block/tableOid once 📎	Ranier Vilela	11:28
Re: getting "shell command argument contains a newline or carriage return:" error with pg_dumpall when db name have new line in double quote 📎	Mahendra Singh Thalor	11:45
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints 📎	Rushabh Lathia	11:48
fallocate() causes btrfs to never compress postgresql files	Dimitrios Apostolou	11:53
Re: AIO v2.5	Andres Freund	11:58
RE: Fix 035_standby_logical_decoding.pl race conditions 📎	Hayato Kuroda (Fujitsu)	12:13
Re: [18] CREATE SUBSCRIPTION ... SERVER	Shlok Kyal	12:28
Re: NOT ENFORCED constraint feature	Peter Eisentraut	12:32
Re: TEMP_CONFIG vs test_aio	Andrew Dunstan	12:34
Re: getting "shell command argument contains a newline or carriage return:" error with pg_dumpall when db name have new line in double quote	Andrew Dunstan	12:35
Re: Reducing memory consumed by RestrictInfo list translations in partitionwise join planning 📎	Ashutosh Bapat	12:51
Re: Reducing the log spam	Fujii Masao	13:11
Some problems regarding the self-join elimination code	Richard Guo	13:26
RE: Fix slot synchronization with two_phase decoding enabled	Zhijie Hou (Fujitsu)	13:32
Re: Making sslrootcert=system work on Windows psql 📎	George MacKerron	13:39
pgsql: Make cancel request keys longer	Heikki Linnakangas	13:43
Re: Make query cancellation keys longer	Heikki Linnakangas	13:48
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints 📎	jian he	13:51
Re: Making sslrootcert=system work on Windows psql	George MacKerron	14:15
Re: Replace IN VALUES with ANY in WHERE clauses during optimization 📎	Alena Rybakina	14:33
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints	Robert Haas	14:40
Re: Draft for basic NUMA observability	Jakub Wartak	14:45
Re: Draft for basic NUMA observability 📎	Jakub Wartak	14:46
Re: Fix 035_standby_logical_decoding.pl race conditions 📎	Bertrand Drouvot	15:00
Re: bug when apply fast default mechanism for adding new column over domain with default value	Tom Lane	15:15
Re: in BeginCopyTo make materialized view using COPY TO instead of COPY (query).	Fujii Masao	15:19
BTScanOpaqueData size slows down tests	Andres Freund	15:20
Re: bug when apply fast default mechanism for adding new column over domain with default value	Tender Wang	15:24
Re: Draft for basic NUMA observability	Bertrand Drouvot	15:27
Re: BTScanOpaqueData size slows down tests	Tom Lane	15:36
Re: [PATCH] PGSERVICEFILE as part of a normal connection string	Ryo Kanbayashi	15:36
Re: Incorrect result of bitmap heap scan.	Andres Freund	15:37
Re: BTScanOpaqueData size slows down tests	Peter Geoghegan	15:45
Re: Improve monitoring of shared memory allocations	Tomas Vondra	15:49
Re: Using read stream in autoprewarm 📎	Melanie Plageman	15:54
Re: SQL function which allows to distinguish a server being in point in time recovery mode and an ordinary replica	Fujii Masao	15:57
Re: BTScanOpaqueData size slows down tests	Andres Freund	15:57
Re: BTScanOpaqueData size slows down tests	Peter Geoghegan	16:01
Re: BTScanOpaqueData size slows down tests	Tom Lane	16:02
Re: index prefetching	Andres Freund	16:05
Re: BTScanOpaqueData size slows down tests	Andres Freund	16:08
Re: BTScanOpaqueData size slows down tests	Peter Geoghegan	16:09
Re: BTScanOpaqueData size slows down tests	Tom Lane	16:10
Re: BTScanOpaqueData size slows down tests	Peter Geoghegan	16:12
Re: Incorrect result of bitmap heap scan.	Matthias van de Meent	16:20
Re: RFC: Logging plan of the running query	Sami Imseih	16:22
Re: BTScanOpaqueData size slows down tests	Álvaro Herrera	16:31
Re: BTScanOpaqueData size slows down tests	Peter Geoghegan	16:36
Re: pull-up subquery if JOIN-ON contains refs to upper-query	Alena Rybakina	16:39
Re: Draft for basic NUMA observability	Tomas Vondra	16:40
Re: index prefetching	Tomas Vondra	16:41
Re: Statistics Import and Export	Andres Freund	16:42
Re: BTScanOpaqueData size slows down tests	Álvaro Herrera	16:43
Re: Parallel CREATE INDEX for GIN indexes	Andres Freund	16:43
Re: BTScanOpaqueData size slows down tests	Peter Geoghegan	16:45
Re: Parallel CREATE INDEX for GIN indexes	Tomas Vondra	16:49
Re: Incorrect result of bitmap heap scan. 📎	Matthias van de Meent	16:58
Re: Add pg_buffercache_evict_all() and pg_buffercache_mark_dirty[_all]() functions	Andres Freund	17:06
Re: BTScanOpaqueData size slows down tests	Tomas Vondra	17:07
Re: [PATCH] Add sortsupport for range types and btree_gist	Heikki Linnakangas	17:18
Re: Using read stream in autoprewarm	Nazir Bilal Yavuz	17:20
Re: statistics import and export: another difference in dump/restore	Jeff Davis	17:25
Re: Incorrect result of bitmap heap scan.	Andres Freund	17:48
Re: SQLFunctionCache and generic plans	Tom Lane	18:09
Re: Incorrect result of bitmap heap scan.	Tom Lane	18:17
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints	Alvaro Herrera	18:24
Re: Replace IN VALUES with ANY in WHERE clauses during optimization	Alexander Korotkov	19:00
Re: Reducing the log spam	Tom Lane	19:23
Re: Fix slot synchronization with two_phase decoding enabled	Masahiko Sawada	19:29
Re: Using read stream in autoprewarm 📎	Melanie Plageman	19:34
Re: Incorrect result of bitmap heap scan.	Matthias van de Meent	19:35
Re: Incorrect result of bitmap heap scan.	Andres Freund	19:36
Re: [PATCH] Add sortsupport for range types and btree_gist 📎	Heikki Linnakangas	19:41
Re: Proposal - Allow extensions to set a Plan Identifier 📎	Sami Imseih	19:43
Re: LWLock deadlock in brinRevmapDesummarizeRange 📎	Arseniy Mukhin	19:50
Re: Enhancing Memory Context Statistics Reporting 📎	Daniel Gustafsson	21:44
Re: Restrict copying of invalidated replication slots	Masahiko Sawada	21:58
Re: Some read stream improvements	Andres Freund	22:17
Re: BTScanOpaqueData size slows down tests	David Rowley	22:26
Re: Question -- why is there no errhint_internal function?	Peter Smith	22:58
Re: Adding skip scan (including MDAM style range skip scan) to nbtree	Peter Geoghegan	23:15
Re: Question -- why is there no errhint_internal function?	Andres Freund	23:26
Re: Adding skip scan (including MDAM style range skip scan) to nbtree	Peter Geoghegan	23:32
Re: Statistics Import and Export	Jeff Davis	23:36

April 3, 2025

Thread	Author	Time
Re: Using read stream in autoprewarm 📎	Melanie Plageman	00:25
Re: Back-patch of: avoid multiple hard links to same WAL file after a crash 📎	Noah Misch	00:29
Re: Making sslrootcert=system work on Windows psql	Jacob Champion	01:21
Re: Some read stream improvements	Thomas Munro	01:43
Re: [PATCH] Re: Proposal to Enable/Disable Index using ALTER INDEX	Sami Imseih	01:58
Re: [PATCH] Re: Proposal to Enable/Disable Index using ALTER INDEX	Gurjeet Singh	02:16
RE: Fix slot synchronization with two_phase decoding enabled	Zhijie Hou (Fujitsu)	02:20
Re: Statistics Import and Export 📎	Nathan Bossart	02:26
Re: Statistics Import and Export	Corey Huinker	02:34
Re: Statistics Import and Export	Nathan Bossart	02:38
Re: [PATCH] Re: Proposal to Enable/Disable Index using ALTER INDEX	Sami Imseih	02:53
Re: Fix slot synchronization with two_phase decoding enabled	Amit Kapila	02:57
Some codes refer slot()->{'slot_name'} but it is not defined 📎	Hayato Kuroda (Fujitsu)	03:15
Re: Reducing memory consumed by RestrictInfo list translations in partitionwise join planning 📎	Amit Langote	03:28
Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility. 📎	Peter Smith	03:37
Re: Fwd: [BUG]: the walsender does not update its IO statistics until it exits	vignesh C	03:55
Re: Test to dump and restore objects left behind by regression	vignesh C	03:59
Re: Test to dump and restore objects left behind by regression	Ashutosh Bapat	04:02
Re: Fix 035_standby_logical_decoding.pl race conditions	Amit Kapila	04:16
Re: NOT ENFORCED constraint feature	Amul Sul	05:07
Re: RFC: Logging plan of the running query	torikoshia	05:32
RE: Fix 035_standby_logical_decoding.pl race conditions 📎	Hayato Kuroda (Fujitsu)	05:34
Re: RFC: Logging plan of the running query	torikoshia	05:34
Re: Fix slot synchronization with two_phase decoding enabled	Masahiko Sawada	05:37
Re: SQLFunctionCache and generic plans	Alexander Pyhalov	05:38
Re: Fix 035_standby_logical_decoding.pl race conditions	Amit Kapila	05:46
Re: Fix slot synchronization with two_phase decoding enabled	Amit Kapila	05:49
RE: Fix 035_standby_logical_decoding.pl race conditions 📎	Hayato Kuroda (Fujitsu)	05:58
Re: RFC: Logging plan of the running query	torikoshia	05:59
Re: statistics import and export: another difference in dump/restore	Ashutosh Bapat	06:17
Re: Test to dump and restore objects left behind by regression 📎	Ashutosh Bapat	06:38
Re: Draft for basic NUMA observability	Jakub Wartak	06:56
RE: pg_recvlogical cannot create slots with failover=true 📎	Hayato Kuroda (Fujitsu)	06:57
Re: Fix 035_standby_logical_decoding.pl race conditions	Bertrand Drouvot	06:59
Re: Draft for basic NUMA observability 📎	Jakub Wartak	07:01
RE: Fix slot synchronization with two_phase decoding enabled	Zhijie Hou (Fujitsu)	07:15
Re: Extensible user mapping handler for FDW	Daniel Gustafsson	07:20
Re: Reducing the log spam	Laurenz Albe	07:22
Re: Fwd: [BUG]: the walsender does not update its IO statistics until it exits	Bertrand Drouvot	07:24
Re: pg_upgrade: Support for upgrading to checksums enabled	Peter Eisentraut	07:25
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints 📎	jian he	07:45
Re: duplicated comments on get_relation_constraints	Richard Guo	07:51
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints	Peter Eisentraut	08:01
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints	Alvaro Herrera	08:07
Re: Test to dump and restore objects left behind by regression	Alvaro Herrera	08:20
Re: Draft for basic NUMA observability	Bertrand Drouvot	08:23
Re: AIX support	wenhui qiu	08:25
Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility.	vignesh C	08:50
Re: in BeginCopyTo make materialized view using COPY TO instead of COPY (query). 📎	jian he	08:53
Re: Test to dump and restore objects left behind by regression	Ashutosh Bapat	09:14
Re: Some codes refer slot()->{'slot_name'} but it is not defined	Fujii Masao	09:21
Re: Fix 035_standby_logical_decoding.pl race conditions	Amit Kapila	09:45
Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility.	Amit Kapila	09:46
Re: Fwd: [BUG]: the walsender does not update its IO statistics until it exits	vignesh C	09:53
Re: Small optimization set tuple block/tableOid once 📎	Ranier Vilela	10:09
Re: Eliminating SPI / SQL from some RI triggers - take 3	Amit Langote	10:19
Re: Update Unicode data to Unicode 16.0.0	Peter Eisentraut	10:20
Re: Making sslrootcert=system work on Windows psql 📎	Daniel Gustafsson	10:41
two occurrences of assign print_notnull within pg_dump.c	jian he	11:00
Re: Making sslrootcert=system work on Windows psql	Sandeep Thakkar	11:02
Re: [PATCH] Add sortsupport for range types and btree_gist	Heikki Linnakangas	11:13
Re: two occurrences of assign print_notnull within pg_dump.c	Ashutosh Bapat	11:22
Re: Mention the default io_method? 📎	Daniel Westermann (DWE)	11:26
Re: Make query cancellation keys longer 📎	Daniel Gustafsson	11:29
Re: two occurrences of assign print_notnull within pg_dump.c	Alvaro Herrera	11:30
Re: Make query cancellation keys longer	Heikki Linnakangas	11:33
Re: [PoC] Reducing planning time when tables have many partitions 📎	David Rowley	11:34
Re: in BeginCopyTo make materialized view using COPY TO instead of COPY (query). 📎	Fujii Masao	11:46
Re: Draft for basic NUMA observability 📎	Tomas Vondra	11:52
Re: libpq support for NegotiateProtocolVersion	Ranier Vilela	11:55
Re: Proposal: Filter irrelevant change before reassemble transactions during logical decoding	Shlok Kyal	12:01
Re: Draft for basic NUMA observability	Tomas Vondra	12:15
Detach partition with constraint test 📎	Ashutosh Bapat	12:22
RE: Some codes refer slot()->{'slot_name'} but it is not defined 📎	Hayato Kuroda (Fujitsu)	12:23

Browse Archives

Prev | Next