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

Jan. 10, 2025

Thread Author Time
Re: IANA timezone abbreviations versus timezone_abbreviations 📎 Tom Lane 00:13
Re: per backend WAL statistics Michael Paquier 00:14
Re: Collation & ctype method table, and extension hooks 📎 Jeff Davis 00:19
Re: Conflict detection for update_deleted in logical replication Masahiko Sawada 00:42
Re: Why doesn't GiST VACUUM require a super-exclusive lock, like nbtree VACUUM? Michail Nikolaev 01:09
Re: IANA timezone abbreviations versus timezone_abbreviations Tom Lane 01:21
Re: Log a warning in pg_createsubscriber for max_slot_wal_keep_size Peter Smith 01:26
Re: New GUC autovacuum_max_threshold ? wenhui qiu 01:45
Re: Make pg_stat_io view count IOs as bytes instead of blocks 📎 Michael Paquier 01:46
Re: Proposal: add new API to stringinfo 📎 Tatsuo Ishii 02:31
pgbench error: (setshell) of script 0; execution of meta-command failed Andy Fan 02:45
Re: Log a warning in pg_createsubscriber for max_slot_wal_keep_size Peter Smith 02:50
Re: Question about behavior of deletes with REPLICA IDENTITY NOTHING 📎 Robert Treat 03:10
Re: CREATE SUBSCRIPTION - add missing test case Peter Smith 03:11
Re: Removing unneeded self joins 📎 Alexander Korotkov 03:13
Re: Question about behavior of deletes with REPLICA IDENTITY NOTHING Peter Smith 03:41
Re: Adding support for SSLKEYLOGFILE in the frontend 📎 Abhishek Chanda 03:59
Re: Some ExecSeqScan optimizations 📎 David Rowley 04:06
Re: Small refactoring around vacuum_open_relation Ashutosh Bapat 04:37
Re: WAL-logging facility for pgstats kinds 📎 Michael Paquier 04:46
Re: An improvement of ProcessTwoPhaseBuffer logic Michael Paquier 04:49
Re: Small refactoring around vacuum_open_relation Michael Paquier 04:57
Re: Infinite loop in XLogPageRead() on standby Michael Paquier 05:54
Re: Change COPY ... ON_ERROR ignore to ON_ERROR ignore_row 📎 jian he 06:38
Re: pgbench error: (setshell) of script 0; execution of meta-command failed 📎 Andy Fan 07:09
Re: Make pg_stat_io view count IOs as bytes instead of blocks Nazir Bilal Yavuz 07:15
Re: Psql meta-command conninfo+ Hunaid Sohail 07:47
Re: IWYU annotations 📎 Peter Eisentraut 08:10
Re: Make pg_stat_io view count IOs as bytes instead of blocks Bertrand Drouvot 08:23
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart Masahiko Sawada 08:33
Re: ecpg command does not warn COPY ... FROM STDIN; 📎 Ryo Kanbayashi 08:45
Re: Conflict detection for update_deleted in logical replication Nisha Moond 08:50
Re: Some ExecSeqScan optimizations 📎 Amit Langote 09:22
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart Masahiko Sawada 09:27
Re: why there is not VACUUM FULL CONCURRENTLY? Antonin Houska 09:31
Re: per backend WAL statistics 📎 Bertrand Drouvot 09:40
RE: Windows meson build 📎 Kohei Harikae (Fujitsu) 09:43
Re: Some ExecSeqScan optimizations Vladlen Popolitov 09:53
Re: Adding a '--two-phase' option to 'pg_createsubscriber' utility. Ajin Cherian 10:08
Re: Incorrect CHUNKHDRSZ in nodeAgg.c 📎 David Rowley 10:30
Re: AIO v2.0 Ants Aasma 10:33
Re: ecpg command does not warn COPY ... FROM STDIN; 📎 Ryo Kanbayashi 10:34
Re: Some ExecSeqScan optimizations David Rowley 10:36
Re: Some ExecSeqScan optimizations David Rowley 10:37
Re: Add Pipelining support in psql 📎 Anthonin Bonnefoy 10:59
RE: Conflict detection for update_deleted in logical replication Zhijie Hou (Fujitsu) 11:05
Re: Potential null pointer dereference in postgres.c 📎 Maxim Orlov 11:08
Re: [PATCH] Hex-coding optimizations using SVE on ARM. Chiranmoy.Bhattacharya@fujitsu.com 11:10
Re: why there is not VACUUM FULL CONCURRENTLY? Marcos Pegoraro 11:10
Re: [PATCH] SVE popcount support 📎 Chiranmoy.Bhattacharya@fujitsu.com 11:19
Re: Some ExecSeqScan optimizations 📎 Amit Langote 11:22
Re: psql: Add leakproof field to \dAo+ meta-command results Dean Rasheed 11:31
RE: Conflict detection for update_deleted in logical replication 📎 Hayato Kuroda (Fujitsu) 11:42
Adding extension default version to \dx 📎 Magnus Hagander 12:04
Re: Vacuum statistics 📎 Alena Rybakina 12:04
Re: Adding extension default version to \dx Julien Rouhaud 12:37
Re: pgbench error: (setshell) of script 0; execution of meta-command failed Fujii Masao 12:41
Re: [RFC] Lock-free XLog Reservation from WAL Yura Sokolov 12:42
Re: [PoC] Federated Authn/z with OAUTHBEARER Peter Eisentraut 13:27
Re: per backend I/O statistics Bertrand Drouvot 13:56
Re: pgbench error: (setshell) of script 0; execution of meta-command failed Nazir Bilal Yavuz 14:29
Re: POC: track vacuum/analyze cumulative time per relation Alena Rybakina 14:37
Re: Logical Replication of sequences 📎 vignesh C 14:37
Re: pgbench error: (setshell) of script 0; execution of meta-command failed Fujii Masao 14:39
Re: Some ExecSeqScan optimizations Vladlen Popolitov 14:49
tests for pg_stat_progress_copy.tuples_skipped 📎 jian he 14:50
Re: Vacuum statistics Alena Rybakina 14:51
Re: Adjusting hash join memory limit to handle batch explosion Melanie Plageman 14:54
Re: Adding extension default version to \dx Michael Banck 14:56
Re: pgbench error: (setshell) of script 0; execution of meta-command failed Tom Lane 14:57
Re: pgbench error: (setshell) of script 0; execution of meta-command failed Tom Lane 14:58
Re: pgbench error: (setshell) of script 0; execution of meta-command failed Nazir Bilal Yavuz 15:08
Re: POC: track vacuum/analyze cumulative time per relation Bertrand Drouvot 15:09
Re: pgbench error: (setshell) of script 0; execution of meta-command failed Tom Lane 15:20
Re: Adding support for SSLKEYLOGFILE in the frontend Daniel Gustafsson 15:29
Re: Vacuum statistics Alena Rybakina 15:31
Re: [PATCH] Hex-coding optimizations using SVE on ARM. Nathan Bossart 15:38
Re: POC: track vacuum/analyze cumulative time per relation Sami Imseih 16:07
Re: Adjusting hash join memory limit to handle batch explosion Tomas Vondra 16:18
Re: POC: track vacuum/analyze cumulative time per relation Sami Imseih 16:21
Re: use a non-locking initial test in TAS_SPIN on AArch64 Nathan Bossart 16:51
Re: [RFC] Lock-free XLog Reservation from WAL Matthias van de Meent 16:53
Re: Why doesn't GiST VACUUM require a super-exclusive lock, like nbtree VACUUM? 📎 Michail Nikolaev 17:06
Re: pg_dump, pg_dumpall, pg_restore: Add --no-policies option Greg Sabino Mullane 17:44
Proposal: "query_work_mem" GUC, to distribute working memory to the query's individual operators James Hunter 18:00
Re: [RFC] Lock-free XLog Reservation from WAL Yura Sokolov 18:33
Re: Reorder shutdown sequence, to flush pgstats later Andres Freund 18:42
Memory leak in plpython3u (with testcase and patch) 📎 Mat Arye 18:43
Re: Reorder shutdown sequence, to flush pgstats later Andres Freund 18:43
Re: pg_dump, pg_dumpall, pg_restore: Add --no-policies option 📎 Nikolay Samokhvalov 18:50
Re: Reorder shutdown sequence, to flush pgstats later 📎 Andres Freund 19:07
Re: use a non-locking initial test in TAS_SPIN on AArch64 Nathan Bossart 19:19
Re: Possible integer overflow in bringetbitmap() 📎 James Hunter 19:22
Re: Proposal: add new API to stringinfo Nathan Bossart 19:26
Re: IANA timezone abbreviations versus timezone_abbreviations 📎 Tom Lane 20:19
Re: SQL function which allows to distinguish a server being in point in time recovery mode and an ordinary replica 📎 m.litsarev 20:39
Re: [PATCH] Hex-coding optimizations using SVE on ARM. Nathan Bossart 20:46
Re: Memory leak in plpython3u (with testcase and patch) Tom Lane 21:37
Re: Moving the vacuum GUCs' docs out of the Client Connection Defaults section 📎 Melanie Plageman 22:09
Re: POC: track vacuum/analyze cumulative time per relation 📎 Sami Imseih 22:26
Restore support for USE_ASSERT_CHECKING in extensions only 📎 Andrew Kane 22:26
Re: Memory leak in plpython3u (with testcase and patch) 📎 Tom Lane 22:45
Re: Moving the vacuum GUCs' docs out of the Client Connection Defaults section Daniel Gustafsson 22:59
Re: Adjusting hash join memory limit to handle batch explosion Melanie Plageman 23:09
Re: Adding support for SSLKEYLOGFILE in the frontend 📎 Abhishek Chanda 23:16
Re: Restore support for USE_ASSERT_CHECKING in extensions only 📎 David Rowley 23:17
pgsql: Consolidate docs for vacuum-related GUCs in new subsection Melanie Plageman 23:22
Re: Proposal: add new API to stringinfo Tatsuo Ishii 23:25
Re: Moving the vacuum GUCs' docs out of the Client Connection Defaults section Melanie Plageman 23:31
Re: Restore support for USE_ASSERT_CHECKING in extensions only Tom Lane 23:32
Re: Restore support for USE_ASSERT_CHECKING in extensions only David Rowley 23:40
Re: Restore support for USE_ASSERT_CHECKING in extensions only Tom Lane 23:48
Re: Restore support for USE_ASSERT_CHECKING in extensions only 📎 Andrew Kane 23:55
Re: Restore support for USE_ASSERT_CHECKING in extensions only David Rowley 23:56

Jan. 11, 2025

Thread Author Time
Re: Restore support for USE_ASSERT_CHECKING in extensions only David Rowley 00:05
Re: Restore support for USE_ASSERT_CHECKING in extensions only Tom Lane 00:15
Re: Add CASEFOLD() function. 📎 Jeff Davis 00:27
Re: Unicode full case mapping: PG_UNICODE_FAST, and standard-compliant UCS_BASIC 📎 Jeff Davis 00:36
Re: Restore support for USE_ASSERT_CHECKING in extensions only David Rowley 00:46
Re: Restore support for USE_ASSERT_CHECKING in extensions only Andrew Kane 01:00
Re: Row pattern recognition 📎 Tatsuo Ishii 05:46
Re: Non-text mode for pg_dumpall 📎 jian he 05:48
Re: Non-text mode for pg_dumpall Mahendra Singh Thalor 07:45
Re: Non-text mode for pg_dumpall Alvaro Herrera 08:44
Re: Some ExecSeqScan optimizations Junwang Zhao 08:57
Re: Some ExecSeqScan optimizations Junwang Zhao 09:00
Re: pgsql: Consolidate docs for vacuum-related GUCs in new subsection Alvaro Herrera 09:02
Re: explain analyze rows=%.0f Guillaume Lelarge 09:15
Re:Re: Re:Re:Re: backup server core when redo btree_xlog_insert that type is XLOG_BTREE_INSERT_POST yuansong 09:40
Re: Include patch id in commitfest page Peter Eisentraut 09:40
Re: Change COPY ... ON_ERROR ignore to ON_ERROR ignore_row Kirill Reshke 09:53
Re: improve DEBUG1 logging of parallel workers for CREATE INDEX? Guillaume Lelarge 10:29
Re: Some ExecSeqScan optimizations Junwang Zhao 10:39
Re: explain analyze rows=%.0f 📎 Ilia Evdokimov 11:10
Missing quotes when deparsing XMLTABLE() and SQL/JSON query functions 📎 Dean Rasheed 12:30
Re: Include patch id in commitfest page Magnus Hagander 12:51
Re: Question about behavior of deletes with REPLICA IDENTITY NOTHING 📎 Robert Treat 13:58
Re: why there is not VACUUM FULL CONCURRENTLY? Andrew Dunstan 14:01
Re: explain analyze rows=%.0f Guillaume Lelarge 14:02
Re: Non-text mode for pg_dumpall Mahendra Singh Thalor 14:38
Re: why there is not VACUUM FULL CONCURRENTLY? Sami Imseih 15:01
Re: Missing quotes when deparsing XMLTABLE() and SQL/JSON query functions Tom Lane 15:42
Re: Non-text mode for pg_dumpall jian he 15:59
Re: Non-text mode for pg_dumpall Mahendra Singh Thalor 16:08
Re: ecpg command does not warn COPY ... FROM STDIN; 📎 Ryo Kanbayashi 17:04
Re: NOT ENFORCED constraint feature Peter Eisentraut 17:13
Re: NOT ENFORCED constraint feature Amul Sul 17:26
Re: explain analyze rows=%.0f Ilia Evdokimov 18:21
Re: pgbench error: (setshell) of script 0; execution of meta-command failed 📎 Tom Lane 19:04
llvm dependency and space concerns Jeremy Schneider 20:56
Re: llvm dependency and space concerns Jeremy Schneider 21:01
Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch) 📎 Shayon Mukherjee 21:10
Re: llvm dependency and space concerns Tom Lane 21:14
Re: llvm dependency and space concerns Jeremy Schneider 21:22
Re: Non-text mode for pg_dumpall 📎 Mahendra Singh Thalor 21:30
Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch) Sami Imseih 22:50
Re: SQL:2011 application time 📎 Paul Jungwirth 23:19
Re: llvm dependency and space concerns Christoph Moench-Tegeder 23:33
Re: Adjusting hash join memory limit to handle batch explosion Tomas Vondra 23:49

Jan. 12, 2025

Thread Author Time
Re: llvm dependency and space concerns Andres Freund 00:03
Re: Possible integer overflow in bringetbitmap() Michael Paquier 00:11
Re: Adjusting hash join memory limit to handle batch explosion 📎 Tomas Vondra 00:42
Re: Recovering from detoast-related catcache invalidations Noah Misch 01:26
Re: Reduce TupleHashEntryData struct size by half David Rowley 01:54
Re: llvm dependency and space concerns Jeremy Schneider 02:37
Re: ecpg command does not warn COPY ... FROM STDIN; Fujii Masao 03:56
Re: ecpg command does not warn COPY ... FROM STDIN; Ryo Kanbayashi 09:27
Re: Parallel heap vacuum 📎 Masahiko Sawada 09:34
Compression of bigger WAL records 📎 Andrey M. Borodin 12:43
Re: Missing quotes when deparsing XMLTABLE() and SQL/JSON query functions Dean Rasheed 14:10
benign bug in BufFileLoadBuffer / incorrect sizeof 📎 Tomas Vondra 16:10
Re: Strange assertion in procarray.c Michail Nikolaev 16:40
Re: Compression of bigger WAL records Kirill Reshke 18:36
Re: POC, WIP: OR-clause support for indexes 📎 Alexander Korotkov 18:39
Re: pgsql: Consolidate docs for vacuum-related GUCs in new subsection Daniel Gustafsson 19:07
Re: benign bug in BufFileLoadBuffer / incorrect sizeof Daniel Gustafsson 19:16
Re: pgsql: Consolidate docs for vacuum-related GUCs in new subsection Tom Lane 19:21
Re: Proposal to Enable/Disable Index using ALTER INDEX (with patch) 📎 Shayon Mukherjee 19:58
Re: POC, WIP: OR-clause support for indexes Alena Rybakina 20:38
Re: CREATE OR REPLACE MATERIALIZED VIEW 📎 Erik Wienhold 21:33
Re: Re: Re:Re:Re: backup server core when redo btree_xlog_insert that type is XLOG_BTREE_INSERT_POST Peter Geoghegan 22:43
Re: Include patch id in commitfest page Jelte Fennema-Nio 23:11
Re: Pgoutput not capturing the generated columns 📎 Peter Smith 23:55

Jan. 13, 2025

Thread Author Time
Re: Pgoutput not capturing the generated columns Peter Smith 00:15
Re: Adding a '--two-phase' option to 'pg_createsubscriber' utility. Ajin Cherian 00:16
Re: POC, WIP: OR-clause support for indexes 📎 Yura Sokolov 00:47
Issue with markers in isolation tester? Or not? 📎 Michail Nikolaev 01:02
Re: POC, WIP: OR-clause support for indexes Alexander Korotkov 01:06
Re: Question about behavior of deletes with REPLICA IDENTITY NOTHING Peter Smith 01:11
Re: pg_createsubscriber TAP test wrapping makes command options hard to read. Peter Smith 01:37
Re: Eager aggregation, take 3 📎 Richard Guo 02:04
Re: Enhancing Memory Context Statistics Reporting 📎 Rahila Syed 02:36
Re: Support for NO INHERIT to INHERIT state change with named NOT NULL constraints 📎 Suraj Kharage 02:56
Re: POC, WIP: OR-clause support for indexes 📎 Andrei Lepikhov 03:39
Re: Question about behavior of deletes with REPLICA IDENTITY NOTHING Amit Kapila 04:00
Re: Question about behavior of deletes with REPLICA IDENTITY NOTHING Robert Treat 04:51
Re: Compression of bigger WAL records Andrey Borodin 05:14
Re: Conflict detection for update_deleted in logical replication Amit Kapila 06:36
Re: Introduce XID age and inactive timeout based replication slot invalidation vignesh C 06:52
Re: POC: enable logical decoding when wal_level = 'replica' without a server restart 📎 Peter Smith 06:52

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