pgsql-hackers since 2025-02-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)

Browse Archives

Prev | Next

Feb. 6, 2025

Thread Author Time
Re: new commitfest transition guidance Peter Geoghegan 00:14
Re: new commitfest transition guidance Tom Lane 00:29
Re: Separate GUC for replication origins Euler Taveira 00:39
Re: Separate GUC for replication origins Masahiko Sawada 00:49
Re: Improve documentation regarding custom settings, placeholders, and the administrative functions 📎 David G. Johnston 00:50
Re: Docs for pg_basebackup needs v17 note for incremental backup David G. Johnston 00:59
Re: per backend WAL statistics Michael Paquier 01:38
Re: Add isolation test template in injection_points for wait/wakeup/detach Michael Paquier 01:42
Re: Remove unnecessary static specifier Japin Li 01:51
Re: Trigger more frequent autovacuums of heavy insert tables wenhui qiu 01:54
Re: Show WAL write and fsync stats in pg_stat_io Tom Lane 02:06
RE: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided. Hayato Kuroda (Fujitsu) 02:07
Re: Show WAL write and fsync stats in pg_stat_io Michael Paquier 02:28
Re: Introduce XID age and inactive timeout based replication slot invalidation Nisha Moond 02:32
Re: Introduce XID age and inactive timeout based replication slot invalidation Nisha Moond 02:32
Re: Introduce XID age and inactive timeout based replication slot invalidation 📎 Nisha Moond 02:32
Re: generic plans and "initial" pruning 📎 Amit Langote 02:35
Re: Improve documentation regarding custom settings, placeholders, and the administrative functions Zhang Mingli 02:36
Re: Improve documentation regarding custom settings, placeholders, and the administrative functions David G. Johnston 02:49
Re: Show WAL write and fsync stats in pg_stat_io Tom Lane 02:52
Re: Show WAL write and fsync stats in pg_stat_io 📎 Michael Paquier 03:35
Re: Statistics Import and Export Corey Huinker 03:51
Re: Statistics Import and Export 📎 Corey Huinker 04:01
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided. Peter Smith 04:08
Re: Statistics Import and Export Jeff Davis 04:45
Re: Introduce XID age and inactive timeout based replication slot invalidation 📎 Amit Kapila 04:47
Re: Introduce XID age and inactive timeout based replication slot invalidation Amit Kapila 04:49
Re: Test to dump and restore objects left behind by regression 📎 Michael Paquier 06:01
Re: Fix assert failure when decoding XLOG_PARAMETER_CHANGE on primary Amit Kapila 06:16
Re: Failed assertion with jit enabled Bertrand Drouvot 06:55
Re: Show WAL write and fsync stats in pg_stat_io Bertrand Drouvot 07:32
Buffer overflow in zic 📎 Evgeniy Gorbanyov 07:38
Re: Implement waiting for wal lsn replay: reloaded 📎 Andrei Lepikhov 07:42
Re: Implement waiting for wal lsn replay: reloaded Yura Sokolov 08:31
Re: [PATCH] pg_stat_activity: make slow/hanging authentication more visible Michael Paquier 08:35
Re: Show WAL write and fsync stats in pg_stat_io Michael Paquier 08:39
Re: [PATCH] SVE popcount support [email protected] 08:44
RE: Improving tracking/processing of buildfarm test failures Hayato Kuroda (Fujitsu) 08:55
Re: Statistics Import and Export 📎 Corey Huinker 09:35
Re: Test to dump and restore objects left behind by regression Alvaro Herrera 09:43
Re: Proposal to CREATE FOREIGN TABLE LIKE 📎 Zhang Mingli 10:09
Re: Modern SHA2- based password hashes for pgcrypto Alvaro Herrera 10:20
Move wal_buffers_full to WalUsage (and report it in pgss/explain) 📎 Bertrand Drouvot 10:27
Re: per backend WAL statistics Bertrand Drouvot 10:28
Re: Proposal to CREATE FOREIGN TABLE LIKE Álvaro Herrera 10:29
Re: Proposal to CREATE FOREIGN TABLE LIKE Álvaro Herrera 10:31
Re: Introduce XID age and inactive timeout based replication slot invalidation 📎 Nisha Moond 10:38
Re: AIO v2.3 📎 Jakub Wartak 10:50
SLRU_PAGES_PER_SEGMENT as configure parameter 📎 Daniil Davydov 10:53
Add missing tab completion for VACUUM and ANALYZE with ONLY option 📎 Umar Hayat 10:58
Re: Avoid possible deference NULL pointer (src/backend/optimizer/path/allpaths.c) Ranier Vilela 11:10
Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility. 📎 Shubham Khanna 11:24
Re: Better visualization of default values Marcos Pegoraro 11:45
Re: Remove useless casts to (char *) 📎 Dagfinn Ilmari Mannsåker 11:49
Re: Make COPY format extendable: Extract COPY TO format implementations 📎 Sutou Kouhei 12:06
Re: Proposal to CREATE FOREIGN TABLE LIKE Zhang Mingli 12:13
Re: Show WAL write and fsync stats in pg_stat_io Nazir Bilal Yavuz 12:19
Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints 📎 Rushabh Lathia 12:38
Re: Show WAL write and fsync stats in pg_stat_io Nazir Bilal Yavuz 12:39
Re: new commitfest transition guidance Jelte Fennema-Nio 12:53
Re: Virtual generated columns vignesh C 13:03
Re: Docs for pg_basebackup needs v17 note for incremental backup Andrew Dunstan 13:07
Re: SLRU_PAGES_PER_SEGMENT as configure parameter Daniel Gustafsson 13:23
Re: Introduce XID age and inactive timeout based replication slot invalidation vignesh C 13:56
Re: Docs for pg_basebackup needs v17 note for incremental backup David G. Johnston 14:43
Re: Re: proposal: schema variables jian he 14:49
Re: SQL Property Graph Queries (SQL/PGQ) 📎 Junwang Zhao 14:52
Re: Buffer overflow in zic Tom Lane 15:00
Re: Improve documentation regarding custom settings, placeholders, and the administrative functions Zhang Mingli 15:03
Re: Prevent COPY FREEZE on Foreign tables Zhang Mingli 15:10
Re: Better visualization of default values Greg Sabino Mullane 15:31
Re: Better visualization of default values David G. Johnston 15:34
Re: Optimization for lower(), upper(), casefold() functions. Alexander Borisov 15:39
Re: Remove unnecessary static specifier Daniel Gustafsson 15:39
Re: Trigger more frequent autovacuums of heavy insert tables 📎 Melanie Plageman 15:42
Re: Prevent COPY FREEZE on Foreign tables Nathan Bossart 16:20
Re: Prevent COPY FREEZE on Foreign tables Sami Imseih 16:26
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints Alvaro Herrera 16:28
Re: [PATCH] SVE popcount support Nathan Bossart 16:33
"Type does not exist" error when returning array of type in non-public schema Chris Cleveland 16:46
Re: "Type does not exist" error when returning array of type in non-public schema David G. Johnston 17:07
Re: "Type does not exist" error when returning array of type in non-public schema Chapman Flack 17:08
Re: new commitfest transition guidance Jeff Davis 17:52
Re: new commitfest transition guidance Jacob Brazeal 17:57
Re: Confine vacuum skip logic to lazy_scan_skip 📎 Melanie Plageman 18:06
Re: "Type does not exist" error when returning array of type in non-public schema Tom Lane 18:14
Re: new commitfest transition guidance Tom Lane 18:18
Re: Fix assert failure when decoding XLOG_PARAMETER_CHANGE on primary Masahiko Sawada 18:41
Re: Adjusting hash join memory limit to handle batch explosion 📎 Tomas Vondra 18:48
outdated comment in table_tuple_update definition Sergei Kornilov 19:00
Re: Optimization for lower(), upper(), casefold() functions. Jeff Davis 19:08
Re: Better visualization of default values Marcos Pegoraro 19:08
Re: Optimization for lower(), upper(), casefold() functions. Alexander Borisov 20:16
Re: Conflict detection for update_deleted in logical replication Masahiko Sawada 20:47
Re: Improving tracking/processing of buildfarm test failures Alexander Lakhin 21:00
Re: Using Expanded Objects other than Arrays from plpgsql Tom Lane 21:05
Re: "Type does not exist" error when returning array of type in non-public schema Chris Cleveland 21:06
Re: "Type does not exist" error when returning array of type in non-public schema Chapman Flack 21:13
Re: "Type does not exist" error when returning array of type in non-public schema David G. Johnston 21:16
Re: Prevent COPY FREEZE on Foreign tables Nathan Bossart 21:26
Re: outdated comment in table_tuple_update definition 📎 Daniel Gustafsson 21:38
Re: Better visualization of default values Peter Smith 21:43
Re: Docs for pg_basebackup needs v17 note for incremental backup Daniel Gustafsson 21:46
showing hashjoin batches/buckets in EXPLAIN (not ANALYZE) 📎 Tomas Vondra 22:02
Re: [PoC] Federated Authn/z with OAUTHBEARER 📎 Daniel Gustafsson 22:02
Tests for extended MCV stats compatibility with multi-filter conditions on a single column 📎 Ilia Evdokimov 22:03
Re: Test to dump and restore objects left behind by regression Michael Paquier 22:11
Expanding HOT updates for expression and partial indexes 📎 Burd, Greg 22:24
Re: Get rid of WALBufMappingLock 📎 Alexander Korotkov 22:26
Re: connection establishment versus parallel workers Thomas Munro 22:53
Should we allow ALTER OPERATOR CLASS to ADD/DROP operators and procedures? Tomas Vondra 23:25

Feb. 7, 2025

Thread Author Time
Re: Should we allow ALTER OPERATOR CLASS to ADD/DROP operators and procedures? Tom Lane 00:15
FSM doesn't recover after zeroing damaged page. 📎 Anton A. Melnikov 00:15
Re: Show WAL write and fsync stats in pg_stat_io Michael Paquier 00:47
Re: [PATCH] Optionally record Plan IDs to track plan changes for a query 📎 Sami Imseih 01:52
RE: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility. Hayato Kuroda (Fujitsu) 02:16
Re: Document NULL jian he 02:28
Re: Introduce XID age and inactive timeout based replication slot invalidation Peter Smith 02:29
Re: Document NULL David G. Johnston 02:42
Re: Add isolation test template in injection_points for wait/wakeup/detach 📎 Michael Paquier 04:41
Re: Fix assert failure when decoding XLOG_PARAMETER_CHANGE on primary Amit Kapila 05:30
Re: Conflict detection for update_deleted in logical replication Amit Kapila 05:47
Re: [PoC] Federated Authn/z with OAUTHBEARER 📎 Jacob Champion 05:48
Re: Introduce XID age and inactive timeout based replication slot invalidation Amit Kapila 05:52
Re: SLRU_PAGES_PER_SEGMENT as configure parameter 📎 Daniil Davydov 05:54
Fix for a crash caused by triggers in cross-partition updates 📎 Kyotaro Horiguchi 06:02
Re: Statistics Import and Export Michael Paquier 06:07
DOCS - inactive_since field readability 📎 Peter Smith 06:34
Re: Trigger more frequent autovacuums of heavy insert tables wenhui qiu 06:40
Re: Fix for a crash caused by triggers in cross-partition updates Michael Paquier 06:47
[PATCH] Fix Potential Memory Leak in pg_amcheck Code 📎 Saladin 07:04
Re: Avoid updating inactive_since for invalid replication slots Peter Smith 07:16
Re: Re: proposal: schema variables 📎 Pavel Stehule 07:24
Re: Better visualization of default values Vladlen Popolitov 07:39
Re: Fix assert failure when decoding XLOG_PARAMETER_CHANGE on primary Bertrand Drouvot 07:49
Re: Trigger more frequent autovacuums of heavy insert tables Japin Li 07:54
Coverage with clang will now works Nikolay Shaplov 08:00
Re: Fix assert failure when decoding XLOG_PARAMETER_CHANGE on primary Bertrand Drouvot 08:05
Re: Modern SHA2- based password hashes for pgcrypto Japin Li 08:17
Re: [PATCH] Fix Potential Memory Leak in pg_amcheck Code Daniel Gustafsson 08:28
Re: SLRU_PAGES_PER_SEGMENT as configure parameter Daniel Gustafsson 08:49
Re: Docs for pg_basebackup needs v17 note for incremental backup Álvaro Herrera 09:22
Re: Modern SHA2- based password hashes for pgcrypto Alvaro Herrera 09:31
Re: Increased work_mem for "logical replication tablesync worker" only? vignesh C 10:31
Re: Using Expanded Objects other than Arrays from plpgsql Andrey Borodin 10:40
Re: new commitfest transition guidance Aleksander Alekseev 10:48
Re: Get rid of WALBufMappingLock 📎 Yura Sokolov 11:02
Re: Support NOT VALID / VALIDATE constraint options for named NOT NULL constraints Alvaro Herrera 11:14
Re: Get rid of WALBufMappingLock 📎 Yura Sokolov 11:24
Re: Get rid of WALBufMappingLock Alexander Korotkov 11:39
Re: Virtual generated columns Peter Eisentraut 12:34
Re: Virtual generated columns Peter Eisentraut 12:36
Re: Make COPY format extendable: Extract COPY TO format implementations 📎 Sutou Kouhei 13:01
Re: Introduce XID age and inactive timeout based replication slot invalidation 📎 Nisha Moond 13:05
Re: Re: proposal: schema variables jian he 13:14
Re: add support for the old naming libs convention on windows (ssleay32.lib and libeay32.lib) Daniel Gustafsson 14:14
Re: add support for the old naming libs convention on windows (ssleay32.lib and libeay32.lib) Darek Ślusarczyk 14:20
Re: Proposal to CREATE FOREIGN TABLE LIKE Zhang Mingli 14:24
Draft for basic NUMA observability 📎 Jakub Wartak 14:32
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided. 📎 Shubham Khanna 14:41
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided. Shubham Khanna 14:45
Re: Enhance 'pg_createsubscriber' to retrieve databases automatically when no database is provided. Shubham Khanna 14:46
Re: Index AM API cleanup 📎 Peter Eisentraut 15:53
Re: Should we allow ALTER OPERATOR CLASS to ADD/DROP operators and procedures? Tomas Vondra 16:24
RE: AIX support Srirama Kucherlapati 16:50
Re: Proposal to CREATE FOREIGN TABLE LIKE 📎 Zhang Mingli 16:50
Re: Should we allow ALTER OPERATOR CLASS to ADD/DROP operators and procedures? Tom Lane 16:58
Draft back-branch release notes are up Tom Lane 17:01
Re: Fix for Extra Parenthesis in pgbench progress message Andres Freund 17:28
Re: Trigger more frequent autovacuums of heavy insert tables Nathan Bossart 17:37
Re: Fix for Extra Parenthesis in pgbench progress message Nathan Bossart 17:57
Re: Fix for Extra Parenthesis in pgbench progress message Tom Lane 17:58
Re: Fix assert failure when decoding XLOG_PARAMETER_CHANGE on primary Masahiko Sawada 18:00
Re: Fix for Extra Parenthesis in pgbench progress message Nathan Bossart 18:02
Re: Fix for Extra Parenthesis in pgbench progress message 📎 Tom Lane 18:10
Re: Fix for Extra Parenthesis in pgbench progress message Andres Freund 18:11
Re: Fix for Extra Parenthesis in pgbench progress message Nathan Bossart 18:13
Re: Fix for Extra Parenthesis in pgbench progress message Tom Lane 18:14
Re: Conflict detection for update_deleted in logical replication Masahiko Sawada 18:44
Re: should we have a fast-path planning for OLTP starjoins? James Hunter 19:11
Re: Collation & ctype method table, and extension hooks 📎 Jeff Davis 19:19
Re: Trigger more frequent autovacuums of heavy insert tables Melanie Plageman 19:21
Re: [18] separate collation and ctype versions, and cleanup of pg_database locale fields Jeff Davis 19:28
Re: explain analyze rows=%.0f Matheus Alcantara 19:59
Re: proposal: plpgsql, new check for extra_errors - strict_expr_check 📎 Pavel Stehule 20:00
Re: should we have a fast-path planning for OLTP starjoins? Tomas Vondra 20:09
Re: [PoC] Federated Authn/z with OAUTHBEARER Daniel Gustafsson 20:12
Re: Trigger more frequent autovacuums of heavy insert tables Nathan Bossart 20:38
Re: explain analyze rows=%.0f Ilia Evdokimov 20:41
Re: Trigger more frequent autovacuums of heavy insert tables Melanie Plageman 20:57
Re: explain analyze rows=%.0f Matheus Alcantara 21:01
Re: Trigger more frequent autovacuums of heavy insert tables Nathan Bossart 21:05
Re: explain analyze rows=%.0f 📎 Ilia Evdokimov 21:28
Re: Adjusting hash join memory limit to handle batch explosion Melanie Plageman 22:14
describe special values in GUC descriptions more consistently 📎 Nathan Bossart 22:27
Re: Cross-type index comparison support in contrib/btree_gin 📎 Tom Lane 22:41
Re: should we have a fast-path planning for OLTP starjoins? James Hunter 22:43
Re: pgbench with partitioned tables Melanie Plageman 23:15
Re: Fix for Extra Parenthesis in pgbench progress message Tatsuo Ishii 23:26
Re: should we have a fast-path planning for OLTP starjoins? Tomas Vondra 23:29

Browse Archives

Prev | Next