pgsql-hackers - March 2024

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

March 1, 2024

Thread Author Time
Re: [PoC] Federated Authn/z with OAUTHBEARER Jacob Champion 00:04
Avoiding inadvertent debugging mode for pgbench 📎 Greg Sabino Mullane 00:05
Re: [PoC] Federated Authn/z with OAUTHBEARER Jacob Champion 00:11
Showing applied extended statistics in explain Part 2 📎 Tatsuro Yamada 00:19
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman 00:29
Re: Pre-proposal: unicode normalized text 📎 Jeff Davis 01:02
Re: [PoC] Federated Authn/z with OAUTHBEARER 📎 Jacob Champion 01:08
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman 01:18
Re: Infinite loop in XLogPageRead() on standby Kyotaro Horiguchi 01:29
Re: ALTER TABLE SET ACCESS METHOD on partitioned tables 📎 Michael Paquier 01:56
Re: Injection points: some tools to wait and wake Michael Paquier 02:02
Re: Propagate sanity checks of ProcessUtility() to standard_ProcessUtility()? Michael Paquier 02:05
RE: Synchronizing slots from primary to standby 📎 Zhijie Hou (Fujitsu) 02:17
RE: Synchronizing slots from primary to standby Zhijie Hou (Fujitsu) 02:18
RE: Synchronizing slots from primary to standby Zhijie Hou (Fujitsu) 02:18
Re: Infinite loop in XLogPageRead() on standby Kyotaro Horiguchi 03:04
Re: Synchronizing slots from primary to standby shveta malik 03:27
Re: Infinite loop in XLogPageRead() on standby Kyotaro Horiguchi 03:37
RE: Synchronizing slots from primary to standby 📎 Zhijie Hou (Fujitsu) 03:42
Re: Statistics Import and Export Corey Huinker 03:55
Re: Improve readability by using designated initializers when possible Michael Paquier 04:08
Re: Improve readability by using designated initializers when possible Michael Paquier 04:12
Re: [PoC] Improve dead tuple storage for lazy vacuum John Naylor 04:15
Re: Infinite loop in XLogPageRead() on standby Kyotaro Horiguchi 04:16
Re: Synchronizing slots from primary to standby Peter Smith 04:22
Re: Synchronizing slots from primary to standby 📎 Amit Kapila 04:31
Re: Improve readability by using designated initializers when possible 📎 Jelte Fennema-Nio 04:34
Re: ALTER TABLE SET ACCESS METHOD on partitioned tables Jelte Fennema-Nio 04:43
Re: Add new error_action COPY ON_ERROR "log" Michael Paquier 04:51
Re: ALTER TABLE SET ACCESS METHOD on partitioned tables Michael Paquier 05:03
Re: Built-in CTYPE provider 📎 Jeff Davis 05:05
Re: Improve readability by using designated initializers when possible Michael Paquier 05:08
Re: ALTER TABLE SET ACCESS METHOD on partitioned tables Michael Paquier 05:14
Re: Make query cancellation keys longer Jelte Fennema-Nio 05:19
Re: ALTER TABLE SET ACCESS METHOD on partitioned tables Jelte Fennema-Nio 05:25
Re: Improve readability by using designated initializers when possible 📎 Jelte Fennema-Nio 05:30
Re: Make COPY format extendable: Extract COPY TO format implementations Michael Paquier 05:31
Re: DOCS: Avoid using abbreviation "aka" Amit Kapila 05:38
Re: Add system identifier to backup manifest Michael Paquier 05:58
Re: DOCS: Avoid using abbreviation "aka" Michael Paquier 05:59
Re: Synchronizing slots from primary to standby Masahiko Sawada 06:10
Re: Synchronizing slots from primary to standby Peter Smith 06:21
Re: Make COPY format extendable: Extract COPY TO format implementations Sutou Kouhei 06:29
Re: Make COPY format extendable: Extract COPY TO format implementations Sutou Kouhei 06:44
Re: Synchronizing slots from primary to standby Amit Kapila 06:45
Re: Injection points: some tools to wait and wake 📎 Bertrand Drouvot 06:52
Re: [PoC] Improve dead tuple storage for lazy vacuum 📎 John Naylor 06:58
Re: Improve readability by using designated initializers when possible 📎 jian he 07:03
Re: Synchronizing slots from primary to standby Bertrand Drouvot 07:15
Re: "type with xxxx does not exist" when doing ExecMemoize() 📎 Tender Wang 07:18
RE: Synchronizing slots from primary to standby Zhijie Hou (Fujitsu) 07:21
Re: [PoC] Improve dead tuple storage for lazy vacuum Masahiko Sawada 08:00
Re: index prefetching Jakub Wartak 08:20
Re: Synchronizing slots from primary to standby 📎 Ajin Cherian 09:09
Re: Synchronizing slots from primary to standby Amit Kapila 09:21
Re: Improve readability by using designated initializers when possible 📎 Peter Eisentraut 09:26
Missing LWLock protection in pgstat_reset_replslot() 📎 Bertrand Drouvot 10:15
Re: Regardign RecentFlushPtr in WalSndWaitForWal() Bertrand Drouvot 10:35
Re: Volatile write caches on macOS and Windows, redux 📎 Thomas Munro 11:04
Re: Regardign RecentFlushPtr in WalSndWaitForWal() Matthias van de Meent 11:10
src/include/miscadmin.h outdated comments jian he 11:19
Re: src/include/miscadmin.h outdated comments Matthias van de Meent 11:26
Re: Commitfest Manager for March Daniel Gustafsson 12:29
Re: btree: implement dynamic prefix truncation (was: Improving btree performance through specializing by key shape, take 2) 📎 Matthias van de Meent 13:48
Re: Commitfest Manager for March Andrey M. Borodin 13:57
Re: make BuiltinTrancheNames less ugly 📎 Alvaro Herrera 14:00
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra 14:05
Re: pread, pwrite, etc return ssize_t not int Peter Eisentraut 14:12
Re: Make query cancellation keys longer Peter Eisentraut 14:19
Re: Introduce XID age and inactive timeout based replication slot invalidation 📎 Bharath Rupireddy 14:32
double precisoin type Fabrice Chapuis 14:46
Re: index prefetching Tomas Vondra 14:58
Re: index prefetching Tomas Vondra 15:18
Re: POC, WIP: OR-clause support for indexes Alexander Korotkov 15:33
Re: double precisoin type Tom Lane 16:12
Re: make BuiltinTrancheNames less ugly Tristan Partin 16:42
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman 16:51
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra 17:08
Re: Statistics Import and Export Nathan Bossart 17:13
Re: Statistics Import and Export Stephen Frost 17:16
Re: [PoC] Federated Authn/z with OAUTHBEARER 📎 Jacob Champion 17:46
Re: index prefetching Peter Geoghegan 17:47
Re: [Patch] add multiple client certificate selection feature 📎 Cary Huang 19:14
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman 19:31
Re: SQL:2011 application time 📎 Paul Jungwirth 20:38
Re: speed up a logical replica setup 📎 Euler Taveira 20:48
Re: ALTER TABLE SET ACCESS METHOD on partitioned tables Justin Pryzby 21:03
Re: pread, pwrite, etc return ssize_t not int Thomas Munro 21:23
Re: Popcount optimization using AVX512 Nathan Bossart 21:44
Re: Experiments with Postgres and SSL Jacob Champion 21:49
Re: SQL:2011 application time 📎 Paul Jungwirth 21:56
Re: Introduce XID age and inactive timeout based replication slot invalidation Nathan Bossart 22:11
Re: Avoiding inadvertent debugging mode for pgbench Nathan Bossart 22:41
Re: Parallel Bitmap Heap Scan reports per-worker stats in EXPLAIN ANALYZE Melanie Plageman 22:44
Re: Avoiding inadvertent debugging mode for pgbench Tomas Vondra 23:07

March 2, 2024

Thread Author Time
Re: Showing applied extended statistics in explain Part 2 Tomas Vondra 00:11
Re: Avoiding inadvertent debugging mode for pgbench Euler Taveira 00:41
Re: Optimizing nbtree ScalarArrayOp execution, allowing multi-column ordered scans, skip scan 📎 Peter Geoghegan 01:30
RE: Synchronizing slots from primary to standby 📎 Zhijie Hou (Fujitsu) 03:51
RE: Synchronizing slots from primary to standby Zhijie Hou (Fujitsu) 03:51
Re: pread, pwrite, etc return ssize_t not int Peter Eisentraut 05:16
Re: New Table Access Methods for Multi and Single Inserts 📎 Bharath Rupireddy 06:32
Re: Synchronizing slots from primary to standby 📎 Amit Kapila 10:54
Re: Regardign RecentFlushPtr in WalSndWaitForWal() Amit Kapila 11:14
Re: Seeking Clarification on Logical Replication Start LSN Amit Kapila 11:35
Re: Shared detoast Datum proposal Nikita Malakhov 12:33
Re: BitmapHeapScan streaming read user and prelim refactoring 📎 Tomas Vondra 15:05
Re: RFC: Logging plan of the running query James Coleman 15:46
Re: Commitfest Manager for March Daniel Gustafsson 17:34
Re: Documentation: warn about two_phase when altering a subscription Andrey M. Borodin 18:14
CF entries for 17 to be reviewed Andrey M. Borodin 18:32
Re: CF entries for 17 to be reviewed Melanie Plageman 20:19
Failures in constraints regression test, "read only 0 of 8192 bytes" Thomas Munro 21:39
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman 22:11
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman 22:28
Re: Failures in constraints regression test, "read only 0 of 8192 bytes" Tomas Vondra 22:29
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra 22:41
Re: BitmapHeapScan streaming read user and prelim refactoring Tomas Vondra 22:51
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman 22:52
Re: Built-in CTYPE provider 📎 Jeff Davis 23:02
Re: Streaming read-ready sequential scan code 📎 Melanie Plageman 23:07
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman 23:39
Re: Synchronizing slots from primary to standby Peter Smith 23:46
Re: BitmapHeapScan streaming read user and prelim refactoring 📎 Tomas Vondra 23:59
Re: pub/sub - specifying optional parameters without values. Peter Smith 23:59

March 3, 2024

Thread Author Time
Re: BitmapHeapScan streaming read user and prelim refactoring Melanie Plageman 00:15
Re: Shared detoast Datum proposal Andy Fan 01:52
psql: fix variable existence tab completion 📎 Steve Chavez 02:00
Re: Synchronizing slots from primary to standby Amit Kapila 03:56
Re: Documentation: warn about two_phase when altering a subscription Amit Kapila 04:03
[docs] revise ORDER BY documentation 📎 Dian Fay 04:13
Re: [PoC] Improve dead tuple storage for lazy vacuum John Naylor 05:43
Re: Shared detoast Datum proposal 📎 Andy Fan 06:10
Re: Make query cancellation keys longer Jelte Fennema-Nio 06:59
a wrong index choose when statistics is out of date Andy Fan 07:01
RE: Synchronizing slots from primary to standby Zhijie Hou (Fujitsu) 07:51
RE: Synchronizing slots from primary to standby 📎 Zhijie Hou (Fujitsu) 07:56
Re: POC, WIP: OR-clause support for indexes Alena Rybakina 09:26
Re: POC, WIP: OR-clause support for indexes Alena Rybakina 09:48
Re: RangeTblEntry.inh vs. RTE_SUBQUERY Peter Eisentraut 10:02
Re: Table AM Interface Enhancements Alexander Korotkov 11:48
Re: Table AM Interface Enhancements Alexander Korotkov 11:50
Re: SLRU optimization - configurable buffer pool and partitioning the SLRU lock Alvaro Herrera 13:58
Re: Make query cancellation keys longer Jelte Fennema-Nio 14:27
Re: pgsql: Improve performance of subsystems on top of SLRU 📎 Alvaro Herrera 14:29
Re: BitmapHeapScan streaming read user and prelim refactoring 📎 Tomas Vondra 14:36
Re: psql: fix variable existence tab completion Erik Wienhold 15:37
PostgreSQL Contributors Updates Joe Conway 15:57
Re: Make query cancellation keys longer Jelte Fennema-Nio 17:27
Re: Refactoring backend fork+exec code Heikki Linnakangas 17:40
Re: Introduce XID age and inactive timeout based replication slot invalidation Bharath Rupireddy 18:10
Re: Shared detoast Datum proposal Tomas Vondra 20:08
Re: Shared detoast Datum proposal Tomas Vondra 20:29
Re: Shared detoast Datum proposal Tomas Vondra 20:41
Re: pgsql: Improve performance of subsystems on top of SLRU Tom Lane 21:14
Re: Introduce XID age and inactive timeout based replication slot invalidation Nathan Bossart 21:44
Re: Add new error_action COPY ON_ERROR "log" Bharath Rupireddy 23:30
Re: Improve readability by using designated initializers when possible Michael Paquier 23:46

March 4, 2024

Thread Author Time
Re: Injection points: some tools to wait and wake Michael Paquier 00:55
Re: initdb's -c option behaves wrong way? 📎 Tom Lane 01:01
Re: Shared detoast Datum proposal Andy Fan 01:17
Re: Shared detoast Datum proposal Andy Fan 01:23
Re: Synchronizing slots from primary to standby Peter Smith 01:27
Re: Improve readability by using designated initializers when possible jian he 01:29
Re: Shared detoast Datum proposal Andy Fan 01:29
Re: Introduce XID age and inactive timeout based replication slot invalidation Michael Paquier 01:32
Re: Injection points: some tools to wait and wake Michael Paquier 01:44
Re: Support boolcol IS [NOT] UNKNOWN in partition pruning David Rowley 01:46
Re: Synchronizing slots from primary to standby Peter Smith 01:55
Re: POC, WIP: OR-clause support for indexes 📎 jian he 02:26
Re: Support "Right Semi Join" plan shapes wenhui qiu 02:33
Re: Incremental View Maintenance, take 2 Yugo NAGATA 02:53
Re: Incremental View Maintenance, take 2 Yugo NAGATA 02:53
Re: Incremental View Maintenance, take 2 📎 Yugo NAGATA 02:58
Re: PostgreSQL Contributors Updates Amit Kapila 03:12
Re: Synchronizing slots from primary to standby Amit Kapila 03:38
Re: Synchronizing slots from primary to standby Amit Kapila 03:49
Re: Synchronizing slots from primary to standby Peter Smith 03:57
Re: Synchronizing slots from primary to standby Peter Smith 04:05
Re: Injection points: some tools to wait and wake Jelte Fennema-Nio 04:17
Re: POC, WIP: OR-clause support for indexes Andrei Lepikhov 04:31
Re: Avoid stack frame setup in performance critical routines using tail calls David Rowley 04:43
Re: a wrong index choose when statistics is out of date Andrei Lepikhov 04:57
Re: Make COPY format extendable: Extract COPY TO format implementations 📎 Sutou Kouhei 05:11
Re: Injection points: some tools to wait and wake Andrey M. Borodin 05:16
Re: PostgreSQL Contributors Updates Andrey M. Borodin 05:18
Re: PostgreSQL Contributors Updates Amul Sul 05:20
Some shared memory chunks are allocated even if related processes won't start 📎 Hayato Kuroda (Fujitsu) 05:26
Re: Injection points: some tools to wait and wake Michael Paquier 05:27
Re: PostgreSQL Contributors Updates Michael Paquier 05:29
Re: Add system identifier to backup manifest Amul Sul 05:32
Re: a wrong index choose when statistics is out of date David Rowley 05:33
Re: Some shared memory chunks are allocated even if related processes won't start Tom Lane 05:33
Re: Add system identifier to backup manifest 📎 Amul Sul 05:34
Re: Permute underscore separated components of columns before fuzzy matching Andrey M. Borodin 05:49
Re: [PoC] Improve dead tuple storage for lazy vacuum 📎 Masahiko Sawada 06:05
Re: Schema variables - new implementation for Postgres 15 📎 Pavel Stehule 06:05
RE: Some shared memory chunks are allocated even if related processes won't start Hayato Kuroda (Fujitsu) 06:10
Re: Fix log_line_prefix to display the transaction id (%x) for statements not in a transaction block Andrey M. Borodin 06:11
Re: pgsql: Improve performance of subsystems on top of SLRU Dilip Kumar 06:14

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