pgsql-hackers since 2025-04-06 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 6, 2025

Thread	Author	Time
Re: Back-patch of: avoid multiple hard links to same WAL file after a crash	Noah Misch	02:09
Re: A modest proposal: make parser/rewriter/planner inputs read-only	Andres Freund	02:30
Re: rename pg_log_standby_snapshot	Andres Freund	02:32
Re: Removing unneeded self joins 📎	Tender Wang	04:02
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints	Álvaro Herrera	04:56
Re: Parallel heap vacuum	Masahiko Sawada	05:01
Re: rename pg_log_standby_snapshot	Michael Paquier	06:33
Re: Back-patch of: avoid multiple hard links to same WAL file after a crash	Michael Paquier	06:53
Re: Improve CRC32C performance on SSE4.2	John Naylor	08:11
Re: Removing unneeded self joins	Daniel Gustafsson	11:23
Re: Make COPY format extendable: Extract COPY TO format implementations	jian he	11:29
Re: Typo in comment for pgstat_database_flush_cb() 📎	Etsuro Fujita	11:31
Re: Thinko in pgstat_build_snapshot()	Etsuro Fujita	11:35
Re: Removing unneeded self joins	Tender Wang	11:42
Re: Removing unneeded self joins	Alexander Korotkov	11:49
Re: Draft for basic NUMA observability	Tomas Vondra	11:51
Re: Draft for basic NUMA observability	Tomas Vondra	11:56
Re: Draft for basic NUMA observability 📎	Jakub Wartak	12:57
Re: Removing unneeded self joins	Tender Wang	13:09
Re: Draft for basic NUMA observability	Tomas Vondra	13:52
Re: Introduce new multi insert Table AM and improve performance of various SQL commands with it for Heap AM	Jingtang Zhang	13:54
Re: Update Unicode data to Unicode 16.0.0	Nathan Bossart	14:16
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	14:24
Re: Removing unneeded self joins	Tom Lane	14:41
Re: getting "shell command argument contains a newline or carriage return:" error with pg_dumpall when db name have new line in double quote	Nathan Bossart	14:50
Re: getting "shell command argument contains a newline or carriage return:" error with pg_dumpall when db name have new line in double quote	Álvaro Herrera	15:23
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	16:10
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	16:10
Re: Make COPY format extendable: Extract COPY TO format implementations	David G. Johnston	16:20
Re: Removing unneeded self joins	Alexander Korotkov	16:46
FmgrInfo allocation patterns (and PL handling as staged programming)	Chapman Flack	17:18
Re: getting "shell command argument contains a newline or carriage return:" error with pg_dumpall when db name have new line in double quote	Tom Lane	17:21
Re: FmgrInfo allocation patterns (and PL handling as staged programming)	Tom Lane	17:33
Re: getting "shell command argument contains a newline or carriage return:" error with pg_dumpall when db name have new line in double quote	Álvaro Herrera	17:34
[PATCH] clarify palloc comment on quote_literal_cstr 📎	Steve Chavez	17:37
Re: Modern SHA2- based password hashes for pgcrypto	Bernd Helmle	17:39
Re: getting "shell command argument contains a newline or carriage return:" error with pg_dumpall when db name have new line in double quote	Tom Lane	17:51
Re: FmgrInfo allocation patterns (and PL handling as staged programming)	Tom Lane	17:59
Re: datfrozenxid > relfrozenxid w/ crash before XLOG_HEAP_INPLACE	Noah Misch	18:00
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints 📎	Alvaro Herrera	18:02
Re: FmgrInfo allocation patterns (and PL handling as staged programming)	Chapman Flack	18:16
Re: Parallel heap vacuum	Melanie Plageman	18:51
Re: New criteria for autovacuum	Melanie Plageman	19:19
Re: FmgrInfo allocation patterns (and PL handling as staged programming)	Chapman Flack	19:39
Re: Modern SHA2- based password hashes for pgcrypto	Tom Lane	19:43
Re: FmgrInfo allocation patterns (and PL handling as staged programming)	Tom Lane	19:47
Re: AIO v2.5 📎	Alexander Lakhin	20:00
BAS_BULKREAD vs read stream	Andres Freund	20:15
Re: Update Unicode data to Unicode 16.0.0	Nathan Bossart	20:15
Re: Restrict publishing of partitioned table with a foreign table as partition 📎	Álvaro Herrera	20:27
Re: [PoC] Federated Authn/z with OAUTHBEARER	Christoph Berg	20:48
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	21:10
Re: Typo in comment for pgstat_database_flush_cb()	Michael Paquier	21:44
Re: [PATCH] clarify palloc comment on quote_literal_cstr	Michael Paquier	21:49
Re: Possibly hard-to-read message	Daniel Gustafsson	21:52
Re: Logging which local address was connected to in log_line_prefix 📎	Tom Lane	22:01
Re: Logging which local address was connected to in log_line_prefix	Michael Paquier	22:41
Re: History doc page clarification on naming	Daniel Gustafsson	22:50
Re: Logging which local address was connected to in log_line_prefix	Tom Lane	22:53
Re: [PoC] Reducing planning time when tables have many partitions 📎	David Rowley	23:04
Re: FmgrInfo allocation patterns (and PL handling as staged programming)	Chapman Flack	23:27
Re: Revisiting {CREATE INDEX, REINDEX} CONCURRENTLY improvements 📎	Mihail Nikalayeu	23:45

April 7, 2025

Thread	Author	Time
Re: FmgrInfo allocation patterns (and PL handling as staged programming)	Tom Lane	00:01
Re: Use XLOG_CONTROL_FILE macro everywhere?	Fujii Masao	00:32
Re: FmgrInfo allocation patterns (and PL handling as staged programming)	Chapman Flack	00:41
Re: Possibly hard-to-read message	David G. Johnston	00:43
Re: Logging which local address was connected to in log_line_prefix	Greg Sabino Mullane	00:49
Re: per backend WAL statistics	Michael Paquier	00:54
Re: Possibly hard-to-read message	Daniel Gustafsson	00:55
Re: Some read stream improvements	Andres Freund	01:29
Re: Some read stream improvements	Thomas Munro	01:33
Re: rename pg_log_standby_snapshot	Sami Imseih	01:38
Re: Use XLOG_CONTROL_FILE macro everywhere?	Anton A. Melnikov	01:55
Re: New criteria for autovacuum	Sami Imseih	02:18
RE: pg_recvlogical cannot create slots with failover=true 📎	Zhijie Hou (Fujitsu)	02:18
Re: FmgrInfo allocation patterns (and PL handling as staged programming) 📎	Tom Lane	02:37
Re: Reduce "Var IS [NOT] NULL" quals during constant folding	Richard Guo	02:59
Re: Modern SHA2- based password hashes for pgcrypto	Andres Freund	03:02
Re: Removing unneeded self joins	Richard Guo	03:12
Re: [PoC] Reducing planning time when tables have many partitions	Yuya Watari	03:14
Re: [PATCH] PGSERVICEFILE as part of a normal connection string	Michael Paquier	04:04
Re: [PATCH] PGSERVICEFILE as part of a normal connection string	Michael Paquier	04:10
Re: Restrict publishing of partitioned table with a foreign table as partition	Sergey Tatarintsev	04:13
Re: [PATCH] Fix build on MINGW on ARM64	Tom Lane	04:58
Re: SQL Property Graph Queries (SQL/PGQ)	Ashutosh Bapat	05:19
Re: Parallel heap vacuum	Peter Smith	05:27
Correct mismatched verb in a message 📎	Kyotaro Horiguchi	06:13
RE: Fix 035_standby_logical_decoding.pl race conditions 📎	Hayato Kuroda (Fujitsu)	06:15
Re: Changing shared_buffers without restart	Ashutosh Bapat	06:20
Re: Introduce new multi insert Table AM and improve performance of various SQL commands with it for Heap AM 📎	Daniil Davydov	06:26
Unquoted file name in an error message 📎	Kyotaro Horiguchi	06:27
Re: Fwd: [BUG]: the walsender does not update its IO statistics until it exits 📎	Michael Paquier	06:31
Re: Correct mismatched verb in a message	Michael Paquier	06:32
Re: Make COPY format extendable: Extract COPY TO format implementations	Sutou Kouhei	06:34
Re: Enhancing Memory Context Statistics Reporting	Rahila Syed	06:51
Make prep_status() message translatable 📎	Kyotaro Horiguchi	06:55
Re: Modern SHA2- based password hashes for pgcrypto	Bernd Helmle	07:03
Re: Modern SHA2- based password hashes for pgcrypto	Bernd Helmle	07:09
Re: Fwd: [BUG]: the walsender does not update its IO statistics until it exits 📎	Bertrand Drouvot	07:13
Re: Make prep_status() message translatable	Fujii Masao	07:26
An incorrect check in get_memoize_path 📎	Richard Guo	07:50
Re: Draft for basic NUMA observability 📎	Jakub Wartak	08:09
Re: SQL Property Graph Queries (SQL/PGQ)	Junwang Zhao	08:13
Re: History doc page clarification on naming	Dave Page	08:16
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints 📎	Rushabh Lathia	08:28
Re: Changing shared_buffers without restart 📎	Dmitry Dolgov	08:43
Re: Fix 035_standby_logical_decoding.pl race conditions	Bertrand Drouvot	09:10
Re: pgsql: Convert 'x IN (VALUES ...)' to 'x = ANY ...' then appropriate	David Rowley	09:15
Re: BUG #18815: Logical replication worker Segmentation fault	Amit Kapila	09:37
Re: Fix 035_standby_logical_decoding.pl race conditions	Amit Kapila	09:46
Re: Typo in comment for pgstat_database_flush_cb()	Etsuro Fujita	09:50
Re: Draft for basic NUMA observability	Bertrand Drouvot	09:53
Re: Fix 035_standby_logical_decoding.pl race conditions	Bertrand Drouvot	09:58
RE: BUG #18815: Logical replication worker Segmentation fault	Zhijie Hou (Fujitsu)	09:58
Re: AIX support	Heikki Linnakangas	10:04
Re: Restrict publishing of partitioned table with a foreign table as partition	Álvaro Herrera	10:05
Re: Unquoted file name in an error message	Álvaro Herrera	10:13
Re: Draft for basic NUMA observability 📎	Jakub Wartak	10:32
Re: [PATCH] clarify palloc comment on quote_literal_cstr	Ashutosh Bapat	11:33
Re: Modern SHA2- based password hashes for pgcrypto 📎	Bernd Helmle	11:48
Re: An incorrect check in get_memoize_path	wenhui qiu	12:02
Re: [PATCH] Add CANONICAL option to xmlserialize 📎	Jim Jones	12:25
as per commit 643a1a61985bef2590496, move create/open dir code to function using switch case of pg_backup_directory.c file also 📎	Mahendra Singh Thalor	12:25
Re: Restrict publishing of partitioned table with a foreign table as partition	Álvaro Herrera	12:30
Re: Restrict publishing of partitioned table with a foreign table as partition 📎	Álvaro Herrera	12:39
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints 📎	jian he	12:43
Re: Fix 035_standby_logical_decoding.pl race conditions 📎	Amit Kapila	12:47
Re: An incorrect check in get_memoize_path 📎	Andrei Lepikhov	12:54
Re: ci: Allow running mingw tests by default via environment variable 📎	Nazir Bilal Yavuz	13:03
Re: pgsql: Convert 'x IN (VALUES ...)' to 'x = ANY ...' then appropriate	Alexander Korotkov	13:08
Re: Unquoted file name in an error message 📎	Andrew Dunstan	13:10
Re: Removing unneeded self joins	Alexander Korotkov	13:11
Re: as per commit 643a1a61985bef2590496, move create/open dir code to function using switch case of pg_backup_directory.c file also	Andrew Dunstan	13:22
Re: Add pg_buffercache_evict_all() and pg_buffercache_mark_dirty[_all]() functions	Andres Freund	13:38
Re: Enhancing Memory Context Statistics Reporting 📎	Daniel Gustafsson	13:41
Re: ci: Allow running mingw tests by default via environment variable	Andres Freund	13:43
Re: pgsql: Convert 'x IN (VALUES ...)' to 'x = ANY ...' then appropriate	Melanie Plageman	13:50
Re: [PoC] Federated Authn/z with OAUTHBEARER	Peter Eisentraut	13:59
Re: [PoC] Federated Authn/z with OAUTHBEARER	Andres Freund	14:21
Re: [PoC] Federated Authn/z with OAUTHBEARER	Andres Freund	14:43
Re: pgsql: Convert 'x IN (VALUES ...)' to 'x = ANY ...' then appropriate	Tom Lane	15:04
Re: [PATCH] Fix build on MINGW on ARM64	Andrew Dunstan	15:05
Re: Commit fest 2025-03	vignesh C	15:07
Re: Draft for basic NUMA observability 📎	Tomas Vondra	15:11
Re: [PATCH] Fix build on MINGW on ARM64	Andrew Dunstan	15:21
Re: Logging which local address was connected to in log_line_prefix	Tom Lane	15:27
Re: Periodic FSM vacuum doesn't happen in one-pass strategy vacuum.	Melanie Plageman	15:29
Re: Logging which local address was connected to in log_line_prefix	Robert Haas	15:39
Re: Enhancing Memory Context Statistics Reporting	Andres Freund	15:43
Re: [PoC] Reducing planning time when tables have many partitions	Tom Lane	15:48
Re: Draft for basic NUMA observability	Andres Freund	15:51
Re: Logging which local address was connected to in log_line_prefix	Tom Lane	15:59
Re: AIO v2.5	Andres Freund	16:20
Re: Logging which local address was connected to in log_line_prefix	Robert Haas	16:23
Re: Draft for basic NUMA observability	Andres Freund	16:27
Re: Enhancing Memory Context Statistics Reporting	Rahila Syed	16:27
Re: Draft for basic NUMA observability 📎	Tomas Vondra	16:36
Re: Add pg_buffercache_evict_all() and pg_buffercache_mark_dirty[_all]() functions 📎	Nazir Bilal Yavuz	16:37
Re: [PoC] Federated Authn/z with OAUTHBEARER	Peter Eisentraut	16:38
Re: Enhancing Memory Context Statistics Reporting	Andres Freund	16:38
Re: Logging parallel worker draught	Melanie Plageman	16:41
Re: [PoC] Federated Authn/z with OAUTHBEARER	Jacob Champion	16:41
Re: Draft for basic NUMA observability	Andres Freund	16:42
Re: [PoC] Federated Authn/z with OAUTHBEARER	Andres Freund	16:52
Re: speedup COPY TO for partitioned table.	Kirill Reshke	16:54
Re: [PoC] Reducing planning time when tables have many partitions	Ashutosh Bapat	16:54
Re: speedup COPY TO for partitioned table.	Kirill Reshke	16:55
Re: psql suggestion "select <tab>" offers nothing, can we get functions like "\df <tab>"	Kirill Reshke	16:55
Re: [PoC] Federated Authn/z with OAUTHBEARER	Andres Freund	17:05
Re: Improve monitoring of shared memory allocations	Tomas Vondra	17:14
Re: Draft for basic NUMA observability	Tomas Vondra	17:16
Adding pg_dump flag for parallel export to pipes 📎	Nitin Motiani	17:16
pgsql: Allow NOT NULL constraints to be added as NOT VALID	Álvaro Herrera	17:20
Re: Draft for basic NUMA observability	Andres Freund	17:24
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints	Alvaro Herrera	17:24
Re: FmgrInfo allocation patterns (and PL handling as staged programming)	Chapman Flack	17:26
Re: [PoC] Federated Authn/z with OAUTHBEARER	Jacob Champion	17:32
Re: FmgrInfo allocation patterns (and PL handling as staged programming)	Tom Lane	17:34
Re: Modern SHA2- based password hashes for pgcrypto	Tom Lane	17:50
Re: Draft for basic NUMA observability 📎	Tomas Vondra	17:59
Re: Modern SHA2- based password hashes for pgcrypto	Andres Freund	18:00
Re: Draft for basic NUMA observability	Andres Freund	18:11
Re: Draft for basic NUMA observability	Bertrand Drouvot	18:11
Re: Modern SHA2- based password hashes for pgcrypto	Álvaro Herrera	18:15
Re: Modern SHA2- based password hashes for pgcrypto	Tom Lane	18:16
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints	Tom Lane	18:30
Re: Enhancing Memory Context Statistics Reporting	Rahila Syed	18:30
Re: [PATCH] clarify palloc comment on quote_literal_cstr 📎	Steve Chavez	18:37
Re: [PoC] Federated Authn/z with OAUTHBEARER	Christoph Berg	18:47
Re: Periodic FSM vacuum doesn't happen in one-pass strategy vacuum.	Masahiko Sawada	18:52
Re: as per commit 643a1a61985bef2590496, move create/open dir code to function using switch case of pg_backup_directory.c file also 📎	Mahendra Singh Thalor	18:59
Re: AIO v2.5	Alexander Lakhin	19:10
Re: pg_recvlogical cannot create slots with failover=true	Masahiko Sawada	19:15
Re: pgsql: Allow NOT NULL constraints to be added as NOT VALID	Andres Freund	19:16
Re: AIO v2.5	Andres Freund	19:24
Re: BAS_BULKREAD vs read stream	Melanie Plageman	19:24
Re: Adding pg_dump flag for parallel export to pipes	Hannu Krosing	19:48
Re: Draft for basic NUMA observability 📎	Tomas Vondra	19:51
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints	Alvaro Herrera	19:52
[Question: linux pipes ( ... | gzip | cat ... ) in tests failing] Re: [PATCH] Adding pg_dump flag for parallel export to pipes	Hannu Krosing	19:54

Browse Archives

Prev | Next