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

Thread Author Time
Re: MergeJoin beats HashJoin in the case of multiple hash clauses Tender Wang 00:05
RE: Conflict detection for update_deleted in logical replication 📎 Zhijie Hou (Fujitsu) 03:05
Re: Documenting inlining SQL functions Merlin Moncure 03:19
Re: Returning nbtree posting list TIDs in DESC order during backwards scans Mircea Cadariu 04:12
Re: event trigger support for PL/Python Pavel Stehule 06:07
Re: Support for 8-byte TOAST values (aka the TOAST infinite loop problem) 📎 Nikhil Kumar Veldanda 06:56
Re: stats.sql might fail due to shared buffers also used by parallel tests Alexander Lakhin 08:00
Re: Upgrade from Fedora 40 to Fedora 42, or from PostgreSQL 16.3 to PostgreSQL 16.9 Michael J. Baars 08:13
Re: Support for 8-byte TOAST values (aka the TOAST infinite loop problem) 📎 Nikhil Kumar Veldanda 08:28
Re: Even when the data is already ordered, MergeAppend still adds a Sort node feichanghong 08:49
DSA overflow in hash join Konstantin Knizhnik 11:48
Re: Upgrade from Fedora 40 to Fedora 42, or from PostgreSQL 16.3 to PostgreSQL 16.9 Michael J. Baars 12:41
Re: Metadata and record block access stats for indexes Frédéric Yhuel 13:54
Re: Logical Replication of sequences 📎 vignesh C 14:15
Re: Logical Replication of sequences vignesh C 14:18
Re: Even when the data is already ordered, MergeAppend still adds a Sort node Tom Lane 16:03
Re: POC: Parallel processing of indexes in autovacuum 📎 Daniil Davydov 16:43
Re: simple patch for discussion 📎 Greg Hennessy 18:27
Re: Proposal: Out-of-Order NOTIFY via GUC to Improve LISTEN/NOTIFY Throughput Rishu Bagga 22:06
[PATCH] Use strchr() to search for a single character 📎 Dmitry Mityugov 22:21
Re: [PATCH] Proposal to Enable/Disable Index using ALTER INDEX Robert Treat 23:54

July 21, 2025

Thread Author Time
Re: Horribly slow pg_upgrade performance with many Large Objects Hannu Krosing 00:03
Re: Support for 8-byte TOAST values (aka the TOAST infinite loop problem) Hannu Krosing 00:15
Re: index prefetching Thomas Munro 00:59
Re: Log prefix missing for subscriber log messages received from publisher Fujii Masao 01:14
Re: Even when the data is already ordered, MergeAppend still adds a Sort node feichanghong 01:58
Re: array_random jian he 03:15
Re: array_random Tom Lane 03:49
Re: Conflict detection for update_deleted in logical replication Amit Kapila 04:00
Re: Improve pg_sync_replication_slots() to wait for primary to advance shveta malik 04:38
Re: Logical Replication of sequences Dilip Kumar 05:06
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart shveta malik 05:18
Add support for specifying tables in pg_createsubscriber. 📎 Shubham Khanna 05:30
Re: Document slot's restart_lsn can go backward 📎 Amit Kapila 05:34
Re-archive the WAL on standby with archive_mode=always？ Japin Li 05:38
Re: Logical Replication of sequences Dilip Kumar 05:45
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart shveta malik 05:54
Re: Improve pg_sync_replication_slots() to wait for primary to advance Amit Kapila 05:55
Re: Improve pg_sync_replication_slots() to wait for primary to advance Dilip Kumar 05:59
Re: Proposal: Out-of-Order NOTIFY via GUC to Improve LISTEN/NOTIFY Throughput Joel Jacobson 06:16
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart Amit Kapila 06:28
Re: add function argument name to substring and substr 📎 jian he 06:31
Re: Skipping schema changes in publication Peter Smith 06:46
Re: Logical Replication of sequences shveta malik 06:47
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart Amit Kapila 06:52
Re: index prefetching Nazir Bilal Yavuz 06:53
Re: libxml2 author overwhelmed with security requests Sandeep Thakkar 07:16
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart shveta malik 07:35
Re: Document slot's restart_lsn can go backward vignesh C 08:40
Re: Missing NULL check after calling ecpg_strdup 📎 Aleksander Alekseev 08:48
Re: Log prefix missing for subscriber log messages received from publisher Álvaro Herrera 08:51
Re: Logical Replication of sequences vignesh C 08:52
Re: Improve error reporting in 027_stream_regress test Nazir Bilal Yavuz 08:53
Re: sql/json query function JsonBehavior default expression's collation may differ from returning type's collation 📎 jian he 08:57
Fix incorrect comment in pg_get_shmem_allocations_numa() 📎 Bertrand Drouvot 09:06
Re: Logical Replication of sequences vignesh C 09:06
Re: Add os_page_num to pg_buffercache 📎 Bertrand Drouvot 09:12
Re: Logical Replication of sequences Amit Kapila 09:25
Re: Add 64-bit XIDs into PostgreSQL 15 Daniil Davydov 09:28
Re: Logical Replication of sequences Dilip Kumar 09:42
Re: pg_dump does not dump domain not-null constraint's comments Álvaro Herrera 09:48
Re: Logical Replication of sequences Dilip Kumar 09:54
Re: Add 64-bit XIDs into PostgreSQL 15 Yura Sokolov 10:01
Re: Logical Replication of sequences shveta malik 10:46
Re: Skipping schema changes in publication shveta malik 10:52
Re: Support for 8-byte TOAST values (aka the TOAST infinite loop problem) 📎 Nikita Malakhov 11:06
Re: Support for 8-byte TOAST values (aka the TOAST infinite loop problem) Nikita Malakhov 11:20
Re: Conflict detection for update_deleted in logical replication 📎 Nisha Moond 11:49
Re: Document slot's restart_lsn can go backward Alexander Korotkov 12:09
Re: Improve error reporting in 027_stream_regress test Nazir Bilal Yavuz 12:21
Re: index prefetching 📎 Thomas Munro 12:39
Proposal: QUALIFY clause 📎 Matheus Alcantara 12:47
Re: 024_add_drop_pub.pl might fail due to deadlock 📎 Ajin Cherian 13:28
Re: Test instability when pg_dump orders by OID Robert Haas 13:40
Use merge-based matching for MCVs in eqjoinsel 📎 Ilia Evdokimov 13:55
Re: Proposal: QUALIFY clause Mike Artz 14:18
Re: Parallel heap vacuum Melanie Plageman 14:28
Re: Proposal: QUALIFY clause Isaac Morland 14:29
Re: Horribly slow pg_upgrade performance with many Large Objects Nathan Bossart 14:38
Re: Proposal: QUALIFY clause Tom Lane 14:41
Re: Proposal: QUALIFY clause Matheus Alcantara 14:47
Re: track generic and custom plans in pg_stat_statements Andrei Lepikhov 14:55
Re: IPC/MultixactCreation on the Standby server 📎 Andrey Borodin 14:58
Fwd: [PATCH] Support for basic ALTER TABLE progress reporting. 📎 Jiří Kavalík 15:19
Re: Fwd: [PATCH] Support for basic ALTER TABLE progress reporting. Álvaro Herrera 15:54
Re: Issues with hash and GiST LP_DEAD setting for kill_prior_tuple Peter Geoghegan 15:59
Re: Optimize shared LWLock acquisition for high-core-count systems 📎 Zhou, Zhiguo 16:19
Re: POC: Parallel processing of indexes in autovacuum Sami Imseih 16:40
Re: why there is not VACUUM FULL CONCURRENTLY? Alvaro Herrera 16:48
Re: [PATCH] Proposal to Enable/Disable Index using ALTER INDEX Sami Imseih 17:16
Update Examples in Logical Replication Docs 📎 Shlok Kyal 17:27
Re: Proposal: QUALIFY clause Tom Lane 17:30
Re: [PATCH] Let's get rid of the freelist and the buffer_strategy_lock 📎 Greg Burd 17:37
Re: Conflict detection for update_deleted in logical replication Masahiko Sawada 17:56
Question on any plans to use the User Server/User Mapping to provide Logical Replication Subscriptions the user/password in an encrypted manner Vitale, Anthony, Sony Music 18:13
Re: Proposal: QUALIFY clause Thom Brown 18:31
Re: [PATCH] Let's get rid of the freelist and the buffer_strategy_lock Andres Freund 18:35
Re: Proposal: QUALIFY clause Marko Tiikkaja 18:38
Re: [PATCH] Generate random dates/times in a specified range Greg Sabino Mullane 19:06
Re: Exposing some hidden serializable transaction costs Greg Sabino Mullane 19:10
Re: display hot standby state in psql prompt Greg Sabino Mullane 19:12
Re: Skipping schema changes in publication 📎 Shlok Kyal 19:33
Re: Skipping schema changes in publication Shlok Kyal 19:35
Re: Parallel heap vacuum Masahiko Sawada 19:41
Re: Proposal: QUALIFY clause Vik Fearing 20:20
Re: Verify predefined LWLocks tranches have entries in wait_event_names.txt Nathan Bossart 20:20
Re: Proposal: QUALIFY clause Vik Fearing 20:23
Re: Proposal: QUALIFY clause Vik Fearing 20:26
Re: Verify predefined LWLocks tranches have entries in wait_event_names.txt Nathan Bossart 20:28
Re: [PATCH] Proposal to Enable/Disable Index using ALTER INDEX Robert Treat 20:29
Re: Proposal: QUALIFY clause Nico Williams 20:34
Re: Non-text mode for pg_dumpall Andrew Dunstan 20:41
Re: pgsql: Introduce pg_shmem_allocations_numa view Christoph Berg 20:52
Re: [PATCH] Proposal to Enable/Disable Index using ALTER INDEX Sami Imseih 21:23
Re: Proposal: QUALIFY clause 📎 Matheus Alcantara 21:29
Re: track generic and custom plans in pg_stat_statements 📎 Sami Imseih 21:47
Re: Proposal: QUALIFY clause Vik Fearing 22:11
Re: [PATCH] Proposal to Enable/Disable Index using ALTER INDEX Robert Treat 22:17
Re: Add estimated hit ratio to Memoize in EXPLAIN to explain cost adjustment 📎 David Rowley 22:17
Re: [PATCH] Check for TupleTableSlot nullness before dereferencing Jacob Champion 22:20
Re: Support for 8-byte TOAST values (aka the TOAST infinite loop problem) Michael Paquier 22:43
Re: Support for 8-byte TOAST values (aka the TOAST infinite loop problem) Michael Paquier 22:54
Re: Proposal: QUALIFY clause Tom Lane 22:56
Re: Verify predefined LWLocks tranches have entries in wait_event_names.txt Michael Paquier 23:02
Re: track generic and custom plans in pg_stat_statements Michael Paquier 23:07
Re: track generic and custom plans in pg_stat_statements Sami Imseih 23:13
Re: Non-reproducible AIO failure Andres Freund 23:19
Re: track generic and custom plans in pg_stat_statements Sami Imseih 23:22
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart Masahiko Sawada 23:33
Re: Parallel heap vacuum Andres Freund 23:49

July 22, 2025

Thread Author Time
Re: teach pg_upgrade to handle in-place tablespaces Corey Huinker 00:16
Re: Non-text mode for pg_dumpall Noah Misch 00:53
Re: Improve error reporting in 027_stream_regress test Michael Paquier 00:55
Re: teach pg_upgrade to handle in-place tablespaces 📎 Nathan Bossart 00:57
Re: Support tid range scan in parallel? David Rowley 01:29
Re: Verify predefined LWLocks tranches have entries in wait_event_names.txt Nathan Bossart 01:34
Re: teach pg_upgrade to handle in-place tablespaces Michael Paquier 01:37
Re: Non-text mode for pg_dumpall Andrew Dunstan 01:43
Re: Skipping schema changes in publication Peter Smith 01:58
Re: CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions 📎 jian he 01:59
Re: Verify predefined LWLocks tranches have entries in wait_event_names.txt Michael Paquier 02:05
Re: teach pg_upgrade to handle in-place tablespaces Nathan Bossart 02:06
Re: Update Examples in Logical Replication Docs Peter Smith 02:15
Re: teach pg_upgrade to handle in-place tablespaces Michael Paquier 02:17
Re: [PATCH] Check for TupleTableSlot nullness before dereferencing David Rowley 02:25
Re: Reduce "Var IS [NOT] NULL" quals during constant folding Richard Guo 02:55
redis_fdw failure on crake Richard Guo 03:12
Re: Proposal: QUALIFY clause Pavel Stehule 03:19
Re: Proposal: QUALIFY clause Merlin Moncure 03:43
Re: Conflict detection for update_deleted in logical replication Amit Kapila 03:48
Re: Proposal: QUALIFY clause Nico Williams 04:08
Re: Improve LWLock tranche name visibility across backends 📎 Sami Imseih 04:26
Re: Update Examples in Logical Replication Docs Amit Kapila 04:50
Re: Proposal: QUALIFY clause Merlin Moncure 05:02
Re: Proposal: QUALIFY clause Tom Lane 05:14
pgsql: Log remote NOTICE, WARNING, and similar messages using ereport() Fujii Masao 05:22
Re: Log prefix missing for subscriber log messages received from publisher Fujii Masao 05:29
Re: IndexAmRoutine aminsertcleanup function can be NULL? Michael Paquier 05:36
Re: proposal: schema variables 📎 Pavel Stehule 05:53
Re: redis_fdw failure on crake Michael Paquier 05:54
Re: Verify predefined LWLocks tranches have entries in wait_event_names.txt 📎 Bertrand Drouvot 06:20
Re: Verify predefined LWLocks tranches have entries in wait_event_names.txt Bertrand Drouvot 06:23
Re: Log prefix missing for subscriber log messages received from publisher Fujii Masao 06:24
Re: generic plans and "initial" pruning Amit Langote 06:43
Support getrandom() for pg_strong_random() source 📎 Masahiko Sawada 06:43
Re: CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions Vik Fearing 06:45
Re: POC: Parallel processing of indexes in autovacuum 📎 Daniil Davydov 06:45
Re: pgsql: Introduce pg_shmem_allocations_numa view Bertrand Drouvot 07:01
Re: Missing NULL check after calling ecpg_strdup 📎 Michael Paquier 07:05
Re: Support getrandom() for pg_strong_random() source Michael Paquier 07:13
Re: Log prefix missing for subscriber log messages received from publisher Álvaro Herrera 07:18
Re: IndexAmRoutine aminsertcleanup function can be NULL? Peter Smith 07:36
Re: [WIP]Vertical Clustered Index (columnar store extension) - take2 📎 Peter Smith 07:46
Re: Support getrandom() for pg_strong_random() source Masahiko Sawada 08:06
Add backup_type to pg_stat_progress_basebackup 📎 Shinya Kato 08:48
Re: Suggestion to add --continue-client-on-abort option to pgbench Yugo Nagata 08:49
Re: track needed attributes in plan nodes for executor use Amit Langote 08:59
Re: Skipping schema changes in publication shveta malik 08:59
Re: Add backup_type to pg_stat_progress_basebackup Yugo Nagata 09:06
Re: track needed attributes in plan nodes for executor use Amit Langote 09:08
Re: Log prefix missing for subscriber log messages received from publisher Álvaro Herrera 09:24
Re: Draft for basic NUMA observability 📎 Patrick Stählin 09:30
Re: Add backup_type to pg_stat_progress_basebackup 📎 Shinya Kato 09:41
Re: display hot standby state in psql prompt 📎 Jim Jones 09:51
Re: [WIP]Vertical Clustered Index (columnar store extension) - take2 Japin Li 10:11
Re: CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions jian he 10:19
icu_validation_level INFO message level not displayed in pg_settings.enumvals jian he 10:21
Re: Skipping schema changes in publication shveta malik 10:27
Re: Fix tab completion in v18 for ALTER DATABASE/USER/ROLE ... RESET jian he 10:28
Re: amcheck: support for GiST Arseniy Mukhin 10:47
Re: Issues with hash and GiST LP_DEAD setting for kill_prior_tuple Amit Kapila 10:59
Re: Support getrandom() for pg_strong_random() source Dagfinn Ilmari Mannsåker 11:11
Re: MergeAppend could consider sorting cheapest child path 📎 Andrei Lepikhov 11:13
Re: Fix tab completion in v18 for ALTER DATABASE/USER/ROLE ... RESET 📎 Dagfinn Ilmari Mannsåker 11:18
Re: Question on any plans to use the User Server/User Mapping to provide Logical Replication Subscriptions the user/password in an encrypted manner Amit Kapila 11:19
Re: Support for 8-byte TOAST values (aka the TOAST infinite loop problem) Nikita Malakhov 11:24
Re: Log prefix missing for subscriber log messages received from publisher Fujii Masao 11:37
Re: SQL Property Graph Queries (SQL/PGQ) 📎 Ashutosh Bapat 11:40
Re: Log prefix missing for subscriber log messages received from publisher Álvaro Herrera 11:47
Re: Proposal: QUALIFY clause Matheus Alcantara 11:55

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