pgsql-hackers since 2025-01-31 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

Jan. 31, 2025

Thread Author Time
Re: Skip collecting decoded changes of already-aborted transactions Masahiko Sawada 00:03
Re: Improve error handling for invalid slots and ensure a same 'inactive_since' time for inactive slots Peter Smith 00:19
Re: Issues with 2PC at recovery: CLOG lookups and GlobalTransactionData 📎 Michael Paquier 00:21
Re: Improve error handling for invalid slots and ensure a same 'inactive_since' time for inactive slots 📎 Peter Smith 01:13
postgresql.conf.sample ordering for IO, worker related GUCs Andres Freund 01:19
Re: Using Expanded Objects other than Arrays from plpgsql 📎 Tom Lane 01:53
Re: postgresql.conf.sample ordering for IO, worker related GUCs Tom Lane 01:55
Re: Error in StrategySyncStart() prologue Michael Paquier 02:08
Re: Introduce XID age and inactive timeout based replication slot invalidation 📎 Nisha Moond 02:13
Re: postgresql.conf.sample ordering for IO, worker related GUCs Andres Freund 02:24
Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options Tatsuo Ishii 02:25
Re: Skip collecting decoded changes of already-aborted transactions Peter Smith 03:06
Re: Compression of bigger WAL records wenhui qiu 03:37
Re: Non-text mode for pg_dumpall 📎 jian he 03:52
Re: Error in StrategySyncStart() prologue Ashutosh Bapat 04:14
Re: [PATCH] Optionally record Plan IDs to track plan changes for a query 📎 Michael Paquier 04:37
Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch) Sami Imseih 04:48
Re: Removing unneeded self joins 📎 Andrei Lepikhov 04:57
Re: Restrict publishing of partitioned table with a foreign table as partition 📎 Sergey Tatarintsev 05:08
Re: Introduce XID age and inactive timeout based replication slot invalidation Peter Smith 05:09
EvictUnpinnedBuffer and buffer free list Ashutosh Bapat 05:15
Re: [PATCH] Optionally record Plan IDs to track plan changes for a query Lukas Fittl 05:19
Re: Improve error handling for invalid slots and ensure a same 'inactive_since' time for inactive slots Amit Kapila 05:22
Re: [PATCH] Optionally record Plan IDs to track plan changes for a query Michael Paquier 05:33
Minor fix in pg_buffercache_evict documentation 📎 Ashutosh Bapat 06:03
Re: why there is not VACUUM FULL CONCURRENTLY? Antonin Houska 06:27
Re: Conflict detection for update_deleted in logical replication Amit Kapila 06:39
Re: UUID v7 📎 Andrey Borodin 07:08
Re: Feature Request: Add AES-128-CFB Mode Support to pgcrypto Umar Hayat 08:08
Re: Show WAL write and fsync stats in pg_stat_io Nazir Bilal Yavuz 08:29
Re: generic plans and "initial" pruning 📎 Amit Langote 08:31
Re: EvictUnpinnedBuffer and buffer free list Yura Sokolov 08:49
Re: Non-text mode for pg_dumpall jian he 08:51
Re: Introduce XID age and inactive timeout based replication slot invalidation Amit Kapila 09:02
Re: Add SPLIT PARTITION/MERGE PARTITIONS commands Alexander Korotkov 09:07
jsonlog missing from logging_collector description 📎 Umar Hayat 09:09
Re: jsonlog missing from logging_collector description Michael Paquier 09:12
Re: Add SPLIT PARTITION/MERGE PARTITIONS commands Alexander Korotkov 09:19
Re: Add SPLIT PARTITION/MERGE PARTITIONS commands Alexander Korotkov 09:22
Re: Use "protocol options" name instead of "protocol extensions" everywhere Laurenz Albe 09:23
Re: why there is not VACUUM FULL CONCURRENTLY? Alvaro Herrera 09:32
Re: Use "protocol options" name instead of "protocol extensions" everywhere Laurenz Albe 09:32
Re: Minor fix in pg_buffercache_evict documentation Daniel Gustafsson 09:53
Re: why there is not VACUUM FULL CONCURRENTLY? Antonin Houska 10:15
Re: why there is not VACUUM FULL CONCURRENTLY? Alvaro Herrera 10:29
Re: why there is not VACUUM FULL CONCURRENTLY? Matthias van de Meent 10:38
Re: Truncate logs by max_log_size 📎 Kirill Gavrilov 10:46
hash_search_with_hash_value is high in "perf top" on a replica Dmitry Koterov 11:30
pgbench with partitioned tables 📎 Sergey Tatarintsev 11:32
Re: EvictUnpinnedBuffer and buffer free list Ashutosh Bapat 11:36
Re: jsonlog missing from logging_collector description Ashutosh Bapat 11:41
Re: Reducing memory consumed by RestrictInfo list translations in partitionwise join planning Alvaro Herrera 12:08
Re: Reducing memory consumed by RestrictInfo list translations in partitionwise join planning Alvaro Herrera 12:16
Re: Introduce XID age and inactive timeout based replication slot invalidation 📎 Nisha Moond 12:20
Re: hash_search_with_hash_value is high in "perf top" on a replica Srinath Reddy 12:24
Re: why there is not VACUUM FULL CONCURRENTLY? Antonin Houska 12:32
Re: jsonlog missing from logging_collector description Umar Hayat 12:48
Re: NOT ENFORCED constraint feature Ashutosh Bapat 12:59
Re: Optimization for lower(), upper(), casefold() functions. Alexander Borisov 13:13
Re: Convert macros to static inline functions 📎 Maxim Orlov 13:29
Re: why there is not VACUUM FULL CONCURRENTLY? Alvaro Herrera 13:34
Re: NOT ENFORCED constraint feature Alvaro Herrera 13:40
RE: Proposal: Filter irrelevant change before reassemble transactions during logical decoding 📎 Hayato Kuroda (Fujitsu) 13:43
Re: Issues with 2PC at recovery: CLOG lookups and GlobalTransactionData Vitaly Davydov 13:54
Commitfest app release on Feb 17 with many improvements Jelte Fennema-Nio 14:23
Re: hash_search_with_hash_value is high in "perf top" on a replica Álvaro Herrera 14:25
Re: POC, WIP: OR-clause support for indexes Alena Rybakina 14:31
Re: FileFallocate misbehaving on XFS Jean-Christophe Arnu 14:33
Re: hash_search_with_hash_value is high in "perf top" on a replica Yura Sokolov 14:38
Re: New process of getting changes into the commitfest app Jelte Fennema-Nio 14:39
Re: hash_search_with_hash_value is high in "perf top" on a replica Andres Freund 14:43
Re: EvictUnpinnedBuffer and buffer free list Melanie Plageman 14:50
Re: Windows: openssl & gssapi dislike each other 📎 Daniel Gustafsson 14:54
Re: jsonlog missing from logging_collector description Tom Lane 15:19
Re: postgresql.conf.sample ordering for IO, worker related GUCs 📎 Andres Freund 15:24
Re: Windows: openssl & gssapi dislike each other Andres Freund 15:29
Re: postgresql.conf.sample ordering for IO, worker related GUCs Tom Lane 15:33
Re: Windows: openssl & gssapi dislike each other Daniel Gustafsson 15:34
Re: [PoC] Federated Authn/z with OAUTHBEARER 📎 Daniel Gustafsson 16:23
Re: RFC: Packing the buffer lookup table James Hunter 17:22
Re: UUID v7 Masahiko Sawada 18:49
Re: Increase of maintenance_work_mem limit in 64-bit Windows Tom Lane 19:00
Re: pgbench with partitioned tables Sami Imseih 19:27
Re: why there is not VACUUM FULL CONCURRENTLY? Antonin Houska 20:02
Re: Conflict detection for update_deleted in logical replication Masahiko Sawada 21:23
Re: pgbench with partitioned tables Melanie Plageman 21:54
Re: postgresql.conf.sample ordering for IO, worker related GUCs Robert Treat 22:22
Re: pgbench with partitioned tables Melanie Plageman 22:23
Re: pgbench with partitioned tables Sami Imseih 22:24
Re: Make COPY format extendable: Extract COPY TO format implementations 📎 Masahiko Sawada 22:25
Re: Make COPY format extendable: Extract COPY TO format implementations 📎 Sutou Kouhei 23:10
Re: postgresql.conf.sample ordering for IO, worker related GUCs Andres Freund 23:21

Feb. 1, 2025

Thread Author Time
Re: Make COPY format extendable: Extract COPY TO format implementations Masahiko Sawada 00:34
Re: jsonlog missing from logging_collector description Michael Paquier 02:20
Re: jsonlog missing from logging_collector description Tom Lane 02:32
Re: RFC: Packing the buffer lookup table Zhang Mingli 05:01
Re: Conflict detection for update_deleted in logical replication Amit Kapila 05:07
Re: Introduce XID age and inactive timeout based replication slot invalidation 📎 vignesh C 06:11
Proposal to CREATE FOREIGN TABLE LIKE Zhang Mingli 06:55
Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch) 📎 Shayon Mukherjee 07:35
Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch) Shayon Mukherjee 07:41
Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch) Shayon Mukherjee 07:44
Re: Add trim_trailing_whitespace to editorconfig file Peter Eisentraut 09:11
Re: Make COPY format extendable: Extract COPY TO format implementations 📎 Sutou Kouhei 10:12
Re: Commitfest app release on Feb 17 with many improvements Jelte Fennema-Nio 11:03
Re: hash_search_with_hash_value is high in "perf top" on a replica Dmitry Koterov 11:46
Re: Proposal to CREATE FOREIGN TABLE LIKE Álvaro Herrera 12:20
Re: Proposal to CREATE FOREIGN TABLE LIKE Zhang Mingli 13:39
Re: hash_search_with_hash_value is high in "perf top" on a replica Ants Aasma 14:43
Re: NOT ENFORCED constraint feature jian he 15:01
Re: hash_search_with_hash_value is high in "perf top" on a replica Andres Freund 15:50
Re: hash_search_with_hash_value is high in "perf top" on a replica Andres Freund 15:55
Re: Improving tracking/processing of buildfarm test failures Alexander Lakhin 16:00
Re: Non-text mode for pg_dumpall Srinath Reddy 16:06
Re: more backtraces 📎 Andrey Borodin 17:29
[PATCH] Fix build on MINGW on ARM64 📎 Lars Kanis 19:22

Feb. 2, 2025

Thread Author Time
Cross-type index comparison support in contrib/btree_gin 📎 Tom Lane 01:44
Re: Add a function to get the version of installed extension Tom Lane 05:15
Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch) jian he 09:41
Re: UUID v7 📎 Andrey Borodin 10:15
Increased work_mem for "logical replication tablesync worker" only? Dmitry Koterov 11:43
Re: why there is not VACUUM FULL CONCURRENTLY? Alvaro Herrera 13:21
Re: Proposal to CREATE FOREIGN TABLE LIKE Álvaro Herrera 13:24
Re: pgbench with partitioned tables Álvaro Herrera 13:45
Doc fix of aggressive vacuum threshold for multixact members storage 📎 Alex Friedman 15:10
Re: Cross-type index comparison support in contrib/btree_gin Tom Lane 16:47
Re: Getting rid of CaseTestExpr (well, partially) Tom Lane 17:24
Re: POC, WIP: OR-clause support for indexes 📎 Alexander Korotkov 17:57
Re: POC, WIP: OR-clause support for indexes Alexander Korotkov 17:58
Re: POC, WIP: OR-clause support for indexes Alexander Korotkov 18:00
Re: Allow default \watch interval in psql to be configured 📎 Daniel Gustafsson 18:25
[PATCH] Fix incorrect range in pg_regress comment 📎 Ilia Evdokimov 18:46
Re: UUID v7 📎 Sergey Prokhorenko 19:40
Re: SQL/JSON json_table plan clause 📎 Nikita Malakhov 19:43
Re: Non-text mode for pg_dumpall 📎 Mahendra Singh Thalor 20:19
Re: Vacuum statistics Alexander Korotkov 20:43
Re: [PATCH] Fix incorrect range in pg_regress comment Tom Lane 21:26
Re: [PATCH] Fix incorrect range in pg_regress comment Jelte Fennema-Nio 21:46
Re: Using Expanded Objects other than Arrays from plpgsql 📎 Tom Lane 21:56
Re: [PATCH] Fix incorrect range in pg_regress comment Tom Lane 22:01
Re: Proposal to CREATE FOREIGN TABLE LIKE Mingli Zhang 22:22
DOCS - Generated Column Replication Examples 📎 Peter Smith 22:52
Re: Pgoutput not capturing the generated columns Peter Smith 22:58
Re: Issues with 2PC at recovery: CLOG lookups and GlobalTransactionData Michael Paquier 23:59

Feb. 3, 2025

Thread Author Time
meson's in-tree libpq header search order vs -Dextra_include_dirs 📎 Thomas Munro 00:28
Re: Proposal to CREATE FOREIGN TABLE LIKE Michael Paquier 00:29
Re: [PATCH] Fix incorrect range in pg_regress comment Michael Paquier 00:34
Re: Introduce XID age and inactive timeout based replication slot invalidation Peter Smith 00:46
Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch) 📎 jian he 02:45
Re: pgbench with partitioned tables Sami Imseih 02:58
Re: Using Expanded Objects other than Arrays from plpgsql Michel Pelletier 03:02
Re: jsonlog missing from logging_collector description Michael Paquier 03:04
Re: Increased work_mem for "logical replication tablesync worker" only? Amit Kapila 03:09
Re: pg_rewind with --write-recovery-conf option doesn't write dbname to primary_conninfo value. Amit Kapila 03:30
Re: Introduce XID age and inactive timeout based replication slot invalidation Peter Smith 03:33
Re: [PATCH] Fix incorrect range in pg_regress comment Tom Lane 03:38
Re: Show WAL write and fsync stats in pg_stat_io 📎 Michael Paquier 04:07
Re: NOT ENFORCED constraint feature Amul Sul 04:09
Re: Fix assert failure when decoding XLOG_PARAMETER_CHANGE on primary Amit Kapila 04:11
Re: NOT ENFORCED constraint feature Amul Sul 04:27
Re: pgbench with partitioned tables 📎 Sergey Tatarintsev 04:37
Re: Introduce XID age and inactive timeout based replication slot invalidation Amit Kapila 05:04
Re: NOT ENFORCED constraint feature Ashutosh Bapat 05:19
Re: NOT ENFORCED constraint feature Amul Sul 05:30
Re: Logging parallel worker draught 📎 Sami Imseih 05:36
Re: Logical Replication of sequences 📎 vignesh C 05:43
RE: pg_rewind with --write-recovery-conf option doesn't write dbname to primary_conninfo value. Hayato Kuroda (Fujitsu) 05:50
Re: Introduce XID age and inactive timeout based replication slot invalidation Peter Smith 05:50
Re: pg_rewind with --write-recovery-conf option doesn't write dbname to primary_conninfo value. Peter Smith 05:59
Re: POC, WIP: OR-clause support for indexes Andrei Lepikhov 06:24
Re: Introduce XID age and inactive timeout based replication slot invalidation Amit Kapila 06:34
Re: Make COPY format extendable: Extract COPY TO format implementations Vladlen Popolitov 06:38
Re: why there is not VACUUM FULL CONCURRENTLY? Antonin Houska 07:01
Optimize scram_SaltedPassword performance 📎 Zixuan Fu 07:11
Re: SQL/JSON json_table plan clause Vladlen Popolitov 07:15
Re: Optimize scram_SaltedPassword performance Yura Sokolov 07:45
Re: NOT ENFORCED constraint feature Alvaro Herrera 07:50
Re: pgbench with partitioned tables Álvaro Herrera 07:57
Re: Optimize scram_SaltedPassword performance Michael Paquier 08:16
Re: Show WAL write and fsync stats in pg_stat_io Bertrand Drouvot 08:50
Re: Non-text mode for pg_dumpall Srinath Reddy 08:53
Re: Non-text mode for pg_dumpall Srinath Reddy 09:02
Re: Optimize scram_SaltedPassword performance Fu Zixuan 09:07
Re: Non-text mode for pg_dumpall 📎 jian he 09:14
Re: Using Expanded Objects other than Arrays from plpgsql Andrey Borodin 09:19
Re: Introduce XID age and inactive timeout based replication slot invalidation Amit Kapila 09:25
Re: POC, WIP: OR-clause support for indexes Alena Rybakina 10:22
Re: Truncate logs by max_log_size Jim Jones 10:31
Re: Show WAL write and fsync stats in pg_stat_io Bertrand Drouvot 10:37
Re: Increased work_mem for "logical replication tablesync worker" only? Dmitry Koterov 11:04
Re: Index AM API cleanup Peter Eisentraut 11:08
Re: Optimize scram_SaltedPassword performance Daniel Gustafsson 11:17
new commitfest transition guidance Peter Eisentraut 11:22
Re: Extensible storage manager API - SMGR hook Redux 📎 Andreas Karlsson 11:27
Re: POC, WIP: OR-clause support for indexes 📎 Alexander Korotkov 11:32
Re: Show WAL write and fsync stats in pg_stat_io Nazir Bilal Yavuz 11:34
RE: POC: enable logical decoding when wal_level = 'replica' without a server restart 📎 Hayato Kuroda (Fujitsu) 11:40
Re: Using Expanded Objects other than Arrays from plpgsql Pavel Borisov 11:42
Re: Optimize scram_SaltedPassword performance Yura Sokolov 11:45
Re: Add RESPECT/IGNORE NULLS and FROM FIRST/LAST options Tatsuo Ishii 11:45

Browse Archives

Prev | Next