pgsql-hackers before 2025-07-20 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 31

July 17, 2025

Thread Author Time
Re: Explicitly enable meson features in CI 📎 Nazir Bilal Yavuz 08:32
Re: Explicitly enable meson features in CI Nazir Bilal Yavuz 08:33
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart Amit Kapila 09:36
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart Amit Kapila 09:37
Re: Logical replication launcher did not automatically restart when got SIGKILL shveta malik 09:57
Re: Non-text mode for pg_dumpall 📎 Mahendra Singh Thalor 10:16
Re: Non-text mode for pg_dumpall 📎 Mahendra Singh Thalor 10:18
Re: simple patch for discussion Greg Hennessy 10:45
Re: Non-text mode for pg_dumpall Álvaro Herrera 11:11
Re: Conflict detection for update_deleted in logical replication shveta malik 11:14
Re: Logical Replication of sequences 📎 vignesh C 11:21
Re: [V2] Adding new CRC32C implementation for IBM S390X John Naylor 11:24
PostgreSQL 16 bug feedback yexiu-glory 11:41
Re: [Feature Request] Support INSERT ... FROM ... TO for date ranges Álvaro Herrera 12:01
Re: [PATCH] Add tests for binaryheap.c 📎 Aleksander Alekseev 12:03
Re: generic plans and "initial" pruning Amit Langote 12:11
Re: Non-text mode for pg_dumpall 📎 Mahendra Singh Thalor 12:52
Re: Test instability when pg_dump orders by OID Robert Haas 13:24
Re: Add 64-bit XIDs into PostgreSQL 15 📎 Maksim.Melnikov 13:36
Re: Fix lwlock.c and wait_event_names.txt discrepancy Bertrand Drouvot 14:25
Re: Log prefix missing for subscriber log messages received from publisher Fujii Masao 14:34
Re: Add progressive backoff to XactLockTableWait functions 📎 Xuneng Zhou 14:54
Re: small fix for pg_overexplain docs Nathan Bossart 15:32
Re: Log prefix missing for subscriber log messages received from publisher Fujii Masao 15:52
Re: PostgreSQL 16 bug feedback David G. Johnston 15:54
Re: Non-text mode for pg_dumpall Andrew Dunstan 16:09
Re: Log prefix missing for subscriber log messages received from publisher Álvaro Herrera 16:15
Re: PostgreSQL 16 bug feedback Laurenz Albe 16:21
Re: simple patch for discussion Maciek Sakrejda 16:44
Re: libpq: Process buffered SSL read bytes to support records >8kB on async API Jacob Champion 16:48
Re: Fix PQport to never return NULL if the connection is valid Tom Lane 16:58
Re: simple patch for discussion Andres Freund 17:03
Re: pg_dump does not dump domain not-null constraint's comments 📎 Álvaro Herrera 17:04
Re: Conflict detection for update_deleted in logical replication Masahiko Sawada 17:25
Re: Windows question: when is LC_MESSAGES defined? Nazir Bilal Yavuz 18:12
Re: track generic and custom plans in pg_stat_statements Sami Imseih 18:19
Re: Returning nbtree posting list TIDs in DESC order during backwards scans Peter Geoghegan 18:26
Re: Covering the comparison between date and timestamp, tz, type Tom Lane 18:30
Re: IPC/MultixactCreation on the Standby server Andrey Borodin 18:34
Re: [PATCH] Let's get rid of the freelist and the buffer_strategy_lock 📎 Greg Burd 18:35
Re: Fix PQport to never return NULL if the connection is valid Laurenz Albe 18:53
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart Masahiko Sawada 18:55
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart Masahiko Sawada 18:55
Re: small fix for pg_overexplain docs Robert Treat 18:58
Re: Collation and primary keys Jeff Davis 18:59
Re: Returning nbtree posting list TIDs in DESC order during backwards scans 📎 Peter Geoghegan 19:37
Re: POC: Parallel processing of indexes in autovacuum Masahiko Sawada 19:42
Re: Make COPY format extendable: Extract COPY TO format implementations Masahiko Sawada 20:33
Re: Parallel heap vacuum Melanie Plageman 20:39
Re: Make COPY format extendable: Extract COPY TO format implementations Masahiko Sawada 20:44
Re: pg_logical_slot_get_changes waits continously for a partial WAL record spanning across 2 pages 📎 Alexander Korotkov 21:09
Re: Adding basic NUMA awareness 📎 Tomas Vondra 21:11
Re: Adding basic NUMA awareness Tomas Vondra 21:14
Re: [PATCH] Add tests for binaryheap.c Nathan Bossart 21:34
Re: Collation and primary keys Laurenz Albe 21:35
Re: Log prefix missing for subscriber log messages received from publisher Fujii Masao 23:16
Re: Issues with hash and GiST LP_DEAD setting for kill_prior_tuple Mihail Nikalayeu 23:26
Re: simple patch for discussion 📎 David Rowley 23:34

July 18, 2025

Thread Author Time
Making type Datum be 8 bytes everywhere 📎 Tom Lane 00:09
Proposal: Out-of-Order NOTIFY via GUC to Improve LISTEN/NOTIFY Throughput 📎 Rishu Bagga 00:49
Add pg_exclusive_locks view for fast AccessExclusiveLock checks 📎 Lukas Fittl 00:51
simple patch for discussion David G. Johnston 01:04
Re: Proposal: Out-of-Order NOTIFY via GUC to Improve LISTEN/NOTIFY Throughput Tom Lane 01:28
Re: [PATCH] Proposal to Enable/Disable Index using ALTER INDEX David Rowley 01:48
Re: PostgreSQL 16 bug feedback yexiu-glory 01:52
Re: PostgreSQL 16 bug feedback yexiu-glory 01:58
Re: PostgreSQL 16 bug feedback David G. Johnston 02:10
Re: Conflict detection for update_deleted in logical replication Dilip Kumar 02:21
Re: [PATCH] Proposal to Enable/Disable Index using ALTER INDEX Sami Imseih 02:25
Re: simple patch for discussion Andy Fan 02:42
Re: Proposal to Enable/Disable Index using ALTER INDEX David G. Johnston 03:09
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart Amit Kapila 03:28
Re: simple patch for discussion David Rowley 03:51
Re: simple patch for discussion David G. Johnston 04:08
Re: simple patch for discussion David G. Johnston 04:23
Re: Improve pg_sync_replication_slots() to wait for primary to advance Dilip Kumar 04:43
Re: [PATCH] Proposal to Enable/Disable Index using ALTER INDEX David Rowley 05:12
Re: Logical Replication of sequences Dilip Kumar 05:14
Re: Improve pg_sync_replication_slots() to wait for primary to advance shveta malik 05:15
Re: Improve pg_sync_replication_slots() to wait for primary to advance Dilip Kumar 05:22
Re: Improve pg_sync_replication_slots() to wait for primary to advance shveta malik 05:55
Re: Improve pg_sync_replication_slots() to wait for primary to advance Dilip Kumar 06:01
Re: Adding wait events statistics 📎 Bertrand Drouvot 06:04
Re: Improving and extending int128.h to more of numeric.c John Naylor 06:42
Re: Proposal: Out-of-Order NOTIFY via GUC to Improve LISTEN/NOTIFY Throughput Joel Jacobson 06:46
Re: Improving and extending int128.h to more of numeric.c John Naylor 06:47
Lossless transmission of double precision floating point 📎 Michael J. Baars 07:01
Re: meson and check-tests 📎 Ashutosh Bapat 07:19
Re: psql: tab-completion support for COPY ... TO/FROM STDIN, STDOUT, and PROGRAM 📎 Yugo Nagata 07:49
Lossless transmission of double precision floating point 📎 Michael J. Baars 07:52
Re: Suggestion to add --continue-client-on-abort option to pgbench Rintaro Ikeda 08:07
Re: Proposal: Out-of-Order NOTIFY via GUC to Improve LISTEN/NOTIFY Throughput Joel Jacobson 08:15
Re: leafhopper / snakefly failing to build HEAD - GCC bug Robins Tharakan 08:36
Re: Logical Replication of sequences Dilip Kumar 08:40
Re: Improve error reporting in 027_stream_regress test 📎 Nazir Bilal Yavuz 08:57
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart shveta malik 08:57
Re: track generic and custom plans in pg_stat_statements Andrei Lepikhov 09:31
Upgrade from Fedora 40 to Fedora 42, or from PostgreSQL 16.3 to PostgreSQL 16.9 📎 Michael J. Baars 09:31
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart Amit Kapila 09:33
Re: Make COPY format extendable: Extract COPY TO format implementations Sutou Kouhei 09:49
Re: Proposal: Out-of-Order NOTIFY via GUC to Improve LISTEN/NOTIFY Throughput Joel Jacobson 09:59
Re: Make COPY format extendable: Extract COPY TO format implementations Sutou Kouhei 10:05
Re: Foreign key isolation tests Dean Rasheed 10:29
Re: IPC/MultixactCreation on the Standby server Álvaro Herrera 10:30
Re: Slot's restart_lsn may point to removed WAL segment after hard restart unexpectedly Alexander Korotkov 10:43
Re: Slot's restart_lsn may point to removed WAL segment after hard restart unexpectedly Alexander Korotkov 10:44
Re: Logical Replication of sequences Amit Kapila 10:45
Re: Slot's restart_lsn may point to removed WAL segment after hard restart unexpectedly Amit Kapila 10:48
Re: Conflict detection for update_deleted in logical replication 📎 Nisha Moond 10:55
Re: C11 / VS 2019 📎 Peter Eisentraut 11:12
Document slot's restart_lsn can go backward 📎 Alexander Korotkov 11:40
Re: Slot's restart_lsn may point to removed WAL segment after hard restart unexpectedly Alexander Korotkov 11:41
Re: Memory consumed by paths during partitionwise join planning Ashutosh Bapat 11:48
Re: IPC/MultixactCreation on the Standby server Álvaro Herrera 11:53
RE: Conflict detection for update_deleted in logical replication 📎 Zhijie Hou (Fujitsu) 12:02
Re: Upgrade from Fedora 40 to Fedora 42, or from PostgreSQL 16.3 to PostgreSQL 16.9 Ashutosh Bapat 12:17
Verify predefined LWLocks tranches have entries in wait_event_names.txt 📎 Bertrand Drouvot 13:39
Re: Fix lwlock.c and wait_event_names.txt discrepancy Bertrand Drouvot 13:40
Re: Missing NULL check after calling ecpg_strdup 📎 Aleksander Alekseev 13:45
Re: IPC/MultixactCreation on the Standby server 📎 Andrey Borodin 13:53
Re: Upgrade from Fedora 40 to Fedora 42, or from PostgreSQL 16.3 to PostgreSQL 16.9 Tom Lane 14:09
Re: Lossless transmission of double precision floating point Tom Lane 14:12
Re: postgres_fdw could deparse ArrayCoerceExpr 📎 Tender Wang 14:33
Even when the data is already ordered, MergeAppend still adds a Sort node feichanghong 14:37
Re: pg_dump does not dump domain not-null constraint's comments jian he 14:44
Re: Proposal to Enable/Disable Index using ALTER INDEX Sami Imseih 15:40
Re: postgres_fdw could deparse ArrayCoerceExpr Alexander Korotkov 15:41
Re: Adding wait events statistics Andres Freund 15:43
Re: Proposal: Out-of-Order NOTIFY via GUC to Improve LISTEN/NOTIFY Throughput Joel Jacobson 15:51
[(known) BUG] DELETE/UPDATE more than one row in partitioned foreign table 📎 Jehan-Guillaume de Rorthais 15:53
Re: Horribly slow pg_upgrade performance with many Large Objects Nathan Bossart 16:05
Re: Making type Datum be 8 bytes everywhere Andres Freund 16:26
Re: Verify predefined LWLocks tranches have entries in wait_event_names.txt Nathan Bossart 16:27
Re: Adding basic NUMA awareness Andres Freund 16:46
Re: [PATCH] Let's get rid of the freelist and the buffer_strategy_lock Andres Freund 17:03
Re: Log prefix missing for subscriber log messages received from publisher 📎 vignesh C 17:06
Re: Proposal: Out-of-Order NOTIFY via GUC to Improve LISTEN/NOTIFY Throughput Tom Lane 17:06
Re: Making type Datum be 8 bytes everywhere Tom Lane 17:24
Re: [PoC] Federated Authn/z with OAUTHBEARER Andres Freund 17:26
Re: index prefetching Tomas Vondra 17:44
Re: libpq: Process buffered SSL read bytes to support records >8kB on async API 📎 Jacob Champion 18:11
Re: index prefetching 📎 Tomas Vondra 18:31
Re: index prefetching Peter Geoghegan 18:50
Re: libpq: Process buffered SSL read bytes to support records >8kB on async API Jacob Champion 19:09
Re: Test instability when pg_dump orders by OID Noah Misch 19:17
Re: Support for 8-byte TOAST values (aka the TOAST infinite loop problem) Nikita Malakhov 19:24
Re: track generic and custom plans in pg_stat_statements 📎 Sami Imseih 19:37
Re: libpq: Process buffered SSL read bytes to support records >8kB on async API Andres Freund 19:55
Re: Documenting inlining SQL functions Pavel Stehule 19:57
Re: Log prefix missing for subscriber log messages received from publisher Álvaro Herrera 20:09
Re: Adding basic NUMA awareness Tomas Vondra 20:48
Re: [PATCH] avoid double scanning in function byteain Tom Lane 20:48
Re: index prefetching Andres Freund 20:52
Re: Adding basic NUMA awareness Andres Freund 21:03
Re: Conflict detection for update_deleted in logical replication 📎 Masahiko Sawada 21:10
Re: Conflict detection for update_deleted in logical replication Masahiko Sawada 21:30
Re: libpq: Process buffered SSL read bytes to support records >8kB on async API Jacob Champion 21:30
Re: index prefetching Peter Geoghegan 21:44
Re: Support for 8-byte TOAST values (aka the TOAST infinite loop problem) Hannu Krosing 22:14
Re: [PoC] Federated Authn/z with OAUTHBEARER Daniel Gustafsson 22:29
Re: Support for 8-byte TOAST values (aka the TOAST infinite loop problem) Hannu Krosing 22:31
Re: Foreign key isolation tests 📎 Paul A Jungwirth 23:25
Re: [PoC] Federated Authn/z with OAUTHBEARER 📎 Jacob Champion 23:31

July 19, 2025

Thread Author Time
Re: Documenting inlining SQL functions Maciek Sakrejda 01:09
Re: Parallel heap vacuum Masahiko Sawada 01:59
Documenting inlining SQL functions David G. Johnston 02:44
Re: index prefetching Andres Freund 02:47
Re: Documenting inlining SQL functions David G. Johnston 02:51
Re: Documenting inlining SQL functions Tom Lane 03:08
Re: index prefetching Peter Geoghegan 03:25
Re: Even when the data is already ordered, MergeAppend still adds a Sort node feichanghong 03:36
Re: Documenting inlining SQL functions David G. Johnston 03:37
Re: index prefetching Thomas Munro 04:03
Re: Documenting inlining SQL functions Pavel Stehule 04:48
Re: Conflict detection for update_deleted in logical replication Amit Kapila 05:02
Re: Support for 8-byte TOAST values (aka the TOAST infinite loop problem) Michael Paquier 05:04
Re: Even when the data is already ordered, MergeAppend still adds a Sort node Zhang Mingli 05:15
Re: Improve error reporting in 027_stream_regress test Michael Paquier 06:05
Re: Log prefix missing for subscriber log messages received from publisher 📎 vignesh C 06:45
Re: Lossless transmission of double precision floating point Michael J. Baars 09:38
Re: Upgrade from Fedora 40 to Fedora 42, or from PostgreSQL 16.3 to PostgreSQL 16.9 Michael J. Baars 09:44
Re: Skipping schema changes in publication 📎 Shlok Kyal 10:44
Re: Skipping schema changes in publication Shlok Kyal 10:44
Re: Skipping schema changes in publication Shlok Kyal 10:45
Re: Skipping schema changes in publication Shlok Kyal 10:47
Re: index prefetching Tomas Vondra 11:23
Re: Improve pg_sync_replication_slots() to wait for primary to advance Amit Kapila 11:39
Re: Document slot's restart_lsn can go backward Alexander Korotkov 12:47
Re: index prefetching Thomas Munro 13:07
get_rule_expr RelabelType node does not print COLLATE clause jian he 13:45
Re: Upgrade from Fedora 40 to Fedora 42, or from PostgreSQL 16.3 to PostgreSQL 16.9 Michael J. Baars 14:04
Re: Improve error reporting in 027_stream_regress test Tom Lane 15:27
Re: Proposal: Out-of-Order NOTIFY via GUC to Improve LISTEN/NOTIFY Throughput Joel Jacobson 15:35
Re: Upgrade from Fedora 40 to Fedora 42, or from PostgreSQL 16.3 to PostgreSQL 16.9 Tom Lane 15:36
Re: get_rule_expr RelabelType node does not print COLLATE clause Tom Lane 15:46
Re: MergeJoin beats HashJoin in the case of multiple hash clauses Tom Lane 18:25
Re: Logical replication prefetch Konstantin Knizhnik 18:36
Re: pg_logical_slot_get_changes waits continously for a partial WAL record spanning across 2 pages Tom Lane 19:49
Re: pg_logical_slot_get_changes waits continously for a partial WAL record spanning across 2 pages Alexander Korotkov 22:30
Re: pg_logical_slot_get_changes waits continously for a partial WAL record spanning across 2 pages Tom Lane 22:57

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 31