pgsql-hackers since 2025-04-04 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
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

April 4, 2025

Thread Author Time
Re: Statistics Import and Export πŸ“Ž Nathan Bossart 02:19
Re: Removing unneeded self joins Richard Guo 02:53
Quote-less file names in error messages πŸ“Ž Kyotaro Horiguchi 03:03
RE: Some codes refer slot()->{'slot_name'} but it is not defined Hayato Kuroda (Fujitsu) 03:06
Re: speedup COPY TO for partitioned table. πŸ“Ž jian he 03:20
Re: Slot's restart_lsn may point to removed WAL segment after hard restart unexpectedly Alexander Korotkov 03:22
RE: pg_recvlogical cannot create slots with failover=true πŸ“Ž Hayato Kuroda (Fujitsu) 03:28
Re: Detach partition with constraint test Amul Sul 04:01
Re: Improve error reporting for few options in pg_createsubscriber Amit Kapila 04:06
Re: Some codes refer slot()->{'slot_name'} but it is not defined Fujii Masao 04:38
Re: Improve error reporting for few options in pg_createsubscriber πŸ“Ž vignesh C 04:41
Re: Fwd: [BUG]: the walsender does not update its IO statistics until it exits πŸ“Ž Bertrand Drouvot 05:01
Re: Restrict publishing of partitioned table with a foreign table as partition Sergey Tatarintsev 05:06
Re: Conflict detection for multiple_unique_conflicts in logical replication Peter Smith 05:11
RE: Some codes refer slot()->{'slot_name'} but it is not defined Hayato Kuroda (Fujitsu) 05:33
Re: [fixed] Trigger test Dmitrii Bondar 05:45
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints Rushabh Lathia 05:49
Re: New criteria for autovacuum Konstantin Knizhnik 05:52
Re: [PoC] Reducing planning time when tables have many partitions πŸ“Ž David Rowley 06:04
Re: Historic snapshot doesn't track txns committed in BUILDING_SNAPSHOT state Masahiko Sawada 06:09
Re: Conflict detection for multiple_unique_conflicts in logical replication Amit Kapila 06:20
Re: Make COPY format extendable: Extract COPY TO format implementations Sutou Kouhei 06:42
Re: Draft for basic NUMA observability Bertrand Drouvot 06:50
Re: why there is not VACUUM FULL CONCURRENTLY? Alvaro Herrera 07:33
Re: Draft for basic NUMA observability πŸ“Ž Jakub Wartak 07:35
Re: Some problems regarding the self-join elimination code Richard Guo 07:37
Re: Thread-safe nl_langinfo() and localeconv() Peter Eisentraut 07:38
Re: Quote-less file names in error messages Daniel Gustafsson 07:40
Re: Changing the state of data checksums in a running cluster Alexander Korotkov 07:55
Re: Using read stream in autoprewarm Daniel Gustafsson 07:59
Re: Using read stream in autoprewarm Nazir Bilal Yavuz 08:17
Re: Non-text mode for pg_dumpall πŸ“Ž Mahendra Singh Thalor 08:22
Re: pg_stat_statements: improve loading and saving routines for the dump file m.litsarev 08:25
Re: Reducing memory consumed by RestrictInfo list translations in partitionwise join planning Amit Langote 08:34
Re: Removing unneeded self joins Andrei Lepikhov 08:35
Re: Make COPY format extendable: Extract COPY TO format implementations Sutou Kouhei 08:38
Re: Making sslrootcert=system work on Windows psql Daniel Gustafsson 08:39
Re: [PoC] Reducing planning time when tables have many partitions πŸ“Ž Yuya Watari 08:42
Re: [PoC] Reducing planning time when tables have many partitions Amit Langote 08:46
Re: Reducing memory consumed by RestrictInfo list translations in partitionwise join planning Ashutosh Bapat 08:47
Re: Reducing memory consumed by RestrictInfo list translations in partitionwise join planning Amit Langote 08:52
Re: Non-text mode for pg_dumpall πŸ“Ž Mahendra Singh Thalor 09:12
Re: Restrict publishing of partitioned table with a foreign table as partition πŸ“Ž Shlok Kyal 09:14
Re: Network failure may prevent promotion Heikki Linnakangas 09:58
Re: Extend ALTER DEFAULT PRIVILEGES for large objects πŸ“Ž Fujii Masao 10:18
Re: why there is not VACUUM FULL CONCURRENTLY? Antonin Houska 10:28
Re: rename pg_log_standby_snapshot Amit Kapila 10:40
Re: Improve error reporting for few options in pg_createsubscriber Amit Kapila 10:45
Re: Better HINT message for "unexpected data beyond EOF" πŸ“Ž Jakub Wartak 10:55
Re: rename pg_log_standby_snapshot Bertrand Drouvot 10:57
Re: Test to dump and restore objects left behind by regression πŸ“Ž Ashutosh Bapat 11:11
Re: Test to dump and restore objects left behind by regression Ashutosh Bapat 11:17
002_pg_upgrade is broken for custom install Ashutosh Bapat 11:27
Re: 002_pg_upgrade is broken for custom install Álvaro Herrera 11:31
Re: 002_pg_upgrade is broken for custom install Ashutosh Bapat 11:41
Re: Large expressions in indexes can't be stored (non-TOASTable) Amit Kapila 11:46
Re: 002_pg_upgrade is broken for custom install Álvaro Herrera 11:53
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints πŸ“Ž Rushabh Lathia 11:54
Re: Change COPY ... ON_ERROR ignore to ON_ERROR ignore_row πŸ“Ž jian he 11:55
Re: Index AM API cleanup Andres Freund 12:17
Re: speedup COPY TO for partitioned table. Kirill Reshke 12:17
Re: Improve documentation regarding custom settings, placeholders, and the administrative functions Heikki Linnakangas 12:19
Re: Index AM API cleanup Peter Eisentraut 12:46
pgsql: Convert 'x IN (VALUES ...)' to 'x = ANY ...' then appropriate Alexander Korotkov 13:17
Re: Proposal: Filter irrelevant change before reassemble transactions during logical decoding Shlok Kyal 13:34
Re: in BeginCopyTo make materialized view using COPY TO instead of COPY (query). Fujii Masao 13:39
autoprewarm_dump_now Π”Π°Ρ€ΡŒΡ Π¨Π°Π½ΠΈΠ½Π° 13:40
Re: psql suggestion "select <tab>" offers nothing, can we get functions like "\df <tab>" Kirill Reshke 13:41
Re: Memoize ANTI and SEMI JOIN inner Andrei Lepikhov 13:49
Re: [PoC] Reducing planning time when tables have many partitions Ashutosh Bapat 13:53
Re: autoprewarm_dump_now Heikki Linnakangas 14:04
Re: [PoC] Reducing planning time when tables have many partitions David Rowley 14:22
Re: Large expressions in indexes can't be stored (non-TOASTable) Nathan Bossart 14:28
Re: [PoC] Reducing planning time when tables have many partitions πŸ“Ž David Rowley 14:30
Re: pg_upgrade: Support for upgrading to checksums enabled Robert Treat 14:34
Re: Draft for basic NUMA observability Tomas Vondra 14:36
Re: Replace IN VALUES with ANY in WHERE clauses during optimization Andres Freund 14:39
Re: Draft for basic NUMA observability Tomas Vondra 14:40
Re: Extend ALTER DEFAULT PRIVILEGES for large objects Nathan Bossart 14:47
Re: [PoC] Reducing planning time when tables have many partitions πŸ“Ž Tom Lane 15:05
Re: Extend ALTER DEFAULT PRIVILEGES for large objects Fujii Masao 15:10
Re: Replace IN VALUES with ANY in WHERE clauses during optimization Tom Lane 15:17
Re: Replace IN VALUES with ANY in WHERE clauses during optimization πŸ“Ž Alena Rybakina 15:19
Re: Replace IN VALUES with ANY in WHERE clauses during optimization Peter Geoghegan 15:33
Re: Add pg_buffercache_evict_all() and pg_buffercache_mark_dirty[_all]() functions πŸ“Ž Nazir Bilal Yavuz 15:36
Re: Improve monitoring of shared memory allocations πŸ“Ž Rahila Syed 15:45
Re: pgsql: Convert 'x IN (VALUES ...)' to 'x = ANY ...' then appropriate Melanie Plageman 15:47
Exponential notation bug Marcos Pegoraro 15:55
Re: Replace IN VALUES with ANY in WHERE clauses during optimization Tom Lane 16:00
Re: Test to dump and restore objects left behind by regression Andres Freund 16:01
Re: Replace IN VALUES with ANY in WHERE clauses during optimization Peter Geoghegan 16:02
Re: pgsql: Convert 'x IN (VALUES ...)' to 'x = ANY ...' then appropriate Alexander Korotkov 16:03
Re: Fwd: [BUG]: the walsender does not update its IO statistics until it exits vignesh C 16:03
Re: Replace IN VALUES with ANY in WHERE clauses during optimization Alexander Korotkov 16:04
Re: Test to dump and restore objects left behind by regression Andres Freund 16:07
Re: New criteria for autovacuum Melanie Plageman 16:10
Re: Exponential notation bug Maciek Sakrejda 16:12
Re: Exponential notation bug Robert Haas 16:14
Re: autoprewarm_dump_now Melanie Plageman 16:17
Re: Exponential notation bug Tom Lane 16:17
Re: New criteria for autovacuum Robert Haas 16:19
Re: Replace IN VALUES with ANY in WHERE clauses during optimization Alena Rybakina 16:30
Re: Use XLOG_CONTROL_FILE macro everywhere? πŸ“Ž Fujii Masao 16:32
Re: autoprewarm_dump_now Robert Haas 16:36
Re: why there is not VACUUM FULL CONCURRENTLY? πŸ“Ž Antonin Houska 16:38
Re: Restrict copying of invalidated replication slots Masahiko Sawada 16:39
Re: rename pg_log_standby_snapshot Sami Imseih 16:55
Re: Update LDAP Protocol in fe-connect.c to v3 πŸ“Ž Andrew Jackson 16:55
Re: [PATCH v2] parallel pg_restore: avoid disk seeks when jumping short distance forward πŸ“Ž Dimitrios Apostolou 16:55
Re: Draft for basic NUMA observability Jakub Wartak 17:07
[PATCH] parallel pg_restore: move offset-building phase to before forking πŸ“Ž Dimitrios Apostolou 17:11
Re: Exponential notation bug Marcos Pegoraro 17:25
Re: Bump soft open file limit (RLIMIT_NOFILE) to hard limit on startup Heikki Linnakangas 17:34
Re: pg_recvlogical cannot create slots with failover=true Masahiko Sawada 17:44
Re: Adding skip scan (including MDAM style range skip scan) to nbtree Alena Rybakina 17:44
Re: Parallel heap vacuum Melanie Plageman 18:05
Re: why there is not VACUUM FULL CONCURRENTLY? Euler Taveira 18:21
Re: 002_pg_upgrade is broken for custom install πŸ“Ž Ashutosh Bapat 18:25
Re: SQLFunctionCache and generic plans Alexander Lakhin 19:00
Re: Reduce "Var IS [NOT] NULL" quals during constant folding Robert Haas 19:14
Re: AIO v2.5 πŸ“Ž Andres Freund 19:16
Re: Draft for basic NUMA observability πŸ“Ž Tomas Vondra 19:25
Re: New criteria for autovacuum Konstantin Knizhnik 19:27
RE: AIX support πŸ“Ž Srirama Kucherlapati 19:31
Re: New criteria for autovacuum Melanie Plageman 19:41
Re: Using read stream in autoprewarm Melanie Plageman 19:46
Re: Statistics Import and Export Nathan Bossart 19:56
Re: New criteria for autovacuum Sami Imseih 20:03
Re: Statistics Import and Export Nathan Bossart 20:06
pgsql: Non text modes for pg_dumpall, correspondingly change pg_restore Andrew Dunstan 20:09
Re: Non-text mode for pg_dumpall Andrew Dunstan 20:11
Re: AIX support Heikki Linnakangas 20:44
Re: Statistics Import and Export Nathan Bossart 20:58
Fundamental scheduling bug in parallel restore of partitioned tables πŸ“Ž Tom Lane 21:12
Re: AIO v2.5 Noah Misch 21:18
Re: Proposal: Limitations of palloc inside checkpointer Heikki Linnakangas 21:22
Re: In-placre persistance change of a relation Thom Brown 21:29
Re: Change COPY ... ON_ERROR ignore to ON_ERROR ignore_row Masahiko Sawada 21:32
Re: Parallel heap vacuum Masahiko Sawada 21:34
Re: SQLFunctionCache and generic plans Tom Lane 21:47
Re: SQLFunctionCache and generic plans Alexander Lakhin 22:00
Proposal for enabling auto-vectorization for checksum calculations πŸ“Ž Matthew Sterrett 22:03
Re: Periodic FSM vacuum doesn't happen in one-pass strategy vacuum. πŸ“Ž Masahiko Sawada 22:06
Re: Improve CRC32C performance on SSE4.2 Nathan Bossart 22:15
Re: Statistics Import and Export Nathan Bossart 22:25
Re: BTScanOpaqueData size slows down tests Andres Freund 23:24
Re: Use XLOG_CONTROL_FILE macro everywhere? πŸ“Ž Anton A. Melnikov 23:27
Re: Statistics Import and Export πŸ“Ž Corey Huinker 23:32

April 5, 2025

Thread Author Time
Re: [PoC] Federated Authn/z with OAUTHBEARER πŸ“Ž Jacob Champion 00:27
Re: Statistics Import and Export Nathan Bossart 02:06
Re: Use XLOG_CONTROL_FILE macro everywhere? Fujii Masao 03:11
Re: AIO v2.5 Andres Freund 03:53
Re: [PoC] Reducing planning time when tables have many partitions πŸ“Ž David Rowley 03:55
Re: New criteria for autovacuum Konstantin Knizhnik 06:02
Re: RFC: Logging plan of the running query πŸ“Ž Atsushi Torikoshi 06:13
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints πŸ“Ž jian he 07:29
Re: Change COPY ... ON_ERROR ignore to ON_ERROR ignore_row πŸ“Ž jian he 08:31
Re: Draft for basic NUMA observability πŸ“Ž Bertrand Drouvot 09:37
Re: Modern SHA2- based password hashes for pgcrypto Alvaro Herrera 09:47
Re: Removing unneeded self joins πŸ“Ž Alexander Korotkov 10:09
Re: Back-patch of: avoid multiple hard links to same WAL file after a crash Michael Paquier 10:14
Re: Re: proposal: schema variables πŸ“Ž Pavel Stehule 10:33
Re: Modern SHA2- based password hashes for pgcrypto Bernd Helmle 10:45
Re: SQL Property Graph Queries (SQL/PGQ) Junwang Zhao 12:50
Re: Draft for basic NUMA observability Tomas Vondra 13:23
Re: AIO v2.5 Noah Misch 13:43
Re: Draft for basic NUMA observability πŸ“Ž Tomas Vondra 14: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 Andrew Dunstan 14:42
Re: Back-patch of: avoid multiple hard links to same WAL file after a crash Tom Lane 15:07
A modest proposal: make parser/rewriter/planner inputs read-only Tom Lane 16:46
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:48
Re: Draft for basic NUMA observability Bertrand Drouvot 16:58
Re: Draft for basic NUMA observability Bertrand Drouvot 17:14
Re: Modern SHA2- based password hashes for pgcrypto Alvaro Herrera 17:22
RE: AIX support πŸ“Ž Srirama Kucherlapati 18:29
Re: Use XLOG_CONTROL_FILE macro everywhere? Anton A. Melnikov 19:10
Re: Back-patch of: avoid multiple hard links to same WAL file after a crash Noah Misch 19:13
Re: Enhancing Memory Context Statistics Reporting πŸ“Ž Daniel Gustafsson 19:29
Re: [fixed] Trigger test Tom Lane 19:54
Re: Add partial :-variable expansion to psql \copy πŸ“Ž Fabien Coelho 20:14
Re: Parallel heap vacuum Melanie Plageman 20:16
Re: In-placre persistance change of a relation Heikki Linnakangas 20:17
Re: Parallel heap vacuum Andres Freund 20:32
Re: CREATE OR REPLACE MATERIALIZED VIEW Tom Lane 20:37
Re: [PATCH] Re: Proposal to Enable/Disable Index using ALTER INDEX πŸ“Ž Shayon Mukherjee 21:00
Re: Removing unneeded self joins Alena Rybakina 21:01
Re: dblink query interruptibility Andreas Karlsson 22:14
Re: Draft for basic NUMA observability Andres Freund 22:29
Re: Back-patch of: avoid multiple hard links to same WAL file after a crash Michael Paquier 22:42
Re: Draft for basic NUMA observability Andres Freund 23:00
Re: [PATCH] New predefined role pg_manage_extensions Tom Lane 23:07

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

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30