Mailing lists [pgsql-hackers]

22 March 2022

• 00:09   RE: WIP: Aggregation push-down Fujii.Yuki@df.MitsubishiElectric.co.jp"
• 00:30   Re: shared-memory based stats collector - v67 Andres Freund
• 00:30   Re: freeing bms explicitly Zhihong Yu
• 00:38   Re: [PATCH] add relation and block-level filtering to pg_waldump Thomas Munro
• 00:41   Re: shared-memory based stats collector - v66 Melanie Plageman
• 00:54   Re: logical decoding and replication of sequences Tomas Vondra
• 01:05   Re: freeing bms explicitly Tom Lane
• 01:12   Re: Estimating HugePages Requirements? Nathan Bossart
• 01:13   Re: freeing bms explicitly Zhihong Yu
• 01:57   Re: Concurrent deadlock scenario with DROP INDEX on partitioned index Jimmy Yih
• 02:01   Re: [PATCH] add relation and block-level filtering to pg_waldump David Christensen
• 02:08   Re: New Object Access Type hooks Mark Dilger
• 02:31   Re: Pluggable toaster Nikita Malakhov
• 02:35   Re: PoC: using sampling to estimate joins / complex conditions Andres Freund
• 02:45   Re: Add sub-transaction overflow status in pg_stat_activity Andres Freund
• 02:49   Re: TAP output format in pg_regress Andres Freund
• 02:50   Re: Add parameter jit_warn_above_fraction Andres Freund
• 02:51   Re: pgcrypto: Remove internal padding implementation Nathan Bossart
• 02:58   Re: Fast COPY FROM based on batch insert Andres Freund
• 02:59   Re: Identify missing publications from publisher while create/alter subscription. Andres Freund
• 03:01   Re: Make mesage at end-of-recovery less scary. Andres Freund
• 03:04   Re: Parameter for planner estimate of recursive queries Andres Freund
• 03:07   Re: [PATCH] Full support for index LP_DEAD hint bits on standby Andres Freund
• 03:08   Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors Yugo NAGATA
• 03:09   Re: [PATCH] Add TOAST support for several system tables Andres Freund
• 03:10   Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors Yugo NAGATA
• 03:13   Re: Add connection active, idle time to pg_stat_activity Andres Freund
• 03:15   Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?) Andres Freund
• 03:15   Re: Mingw task for Cirrus CI Andres Freund
• 03:17   Re: PoC: using sampling to estimate joins / complex conditions Tomas Vondra
• 03:18   Re: PATCH: generate fractional cheapest paths in generate_orderedappend_path Andres Freund
• 03:20   Re: Extensible storage manager API - smgr hooks Andres Freund
• 03:30   Re: Allow batched insert during cross-partition updates Andres Freund
• 03:31   Re: Fix overflow in DecodeInterval Tom Lane
• 03:32   Re: Supply restore_command to pg_rewind via CLI argument Andres Freund
• 03:33   Re: PATCH: generate fractional cheapest paths in generate_orderedappend_path Tomas Vondra
• 03:34   Re: [WIP] Allow pg_upgrade to copy segments of the same relfilenode in parallel Andres Freund
• 03:37   Re: [PATCH] Proof of concept for GUC improvements Andres Freund
• 03:40   Re: Proposal: allow database-specific role memberships Andres Freund
• 03:43   Re: Logical insert/update/delete WAL records for custom table AMs Andres Freund
• 03:44   Re: Map WAL segment files on PMEM as WAL buffers Andres Freund
• 03:46   Re: [PATCH] New [relation] option engine Andres Freund
• 03:46   Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors Tatsuo Ishii
• 03:48   Re: Parallelize correlated subqueries that execute within each worker Andres Freund
• 03:48   RE: logical replication empty transactions houzj.fnst@fujitsu.com
• 03:49   Re: Partial aggregates pushdown Andres Freund
• 03:51   Re: Pluggable toaster Andres Freund
• 03:52   Re: preserving db/ts/relfilenode OIDs across pg_upgrade (was Re: storing an explicit nonce) Andres Freund
• 03:53   Re: [PATCH] Proof of concept for GUC improvements Tom Lane
• 03:54   Re: Reducing power consumption on idle servers Andres Freund
• 03:58   Re: Removing unneeded self joins Andres Freund
• 04:00   Re: WIN32 pg_import_system_collations Andres Freund
• 04:04   Re: logical replication restrictions Andres Freund
• 04:05   Re: Temporary tables versus wraparound... again Andres Freund
• 04:07   Re: Window Function "Run Conditions" Andres Freund
• 04:09   Re: WaitLatchOrSocket seems to not count to 4 right... Andres Freund
• 04:09   Re: logical replication restrictions Euler Taveira
• 04:11   Re: LogwrtResult contended spinlock Andres Freund
• 04:12   Re: pg14 psql broke \d datname.nspname.relname Andres Freund
• 04:15   Re: Separate the result of \watch for each query execution (psql) Andres Freund
• 04:17   Re: [PATCH] pg_stat_toast v8 Andres Freund
• 04:17   Re: Allow batched insert during cross-partition updates Amit Langote
• 04:18   Re: a misbehavior of partition row movement (?) Amit Langote
• 04:18   Re: postgres_fdw: using TABLESAMPLE to collect remote sample Andres Freund
• 04:23   Re: [PATCH] sort leaf pages by ctid for gist indexes built using sorted method Andres Freund
• 04:25   Re: speed up a logical replica setup Andres Freund
• 04:27   Re: Temporary tables versus wraparound... again Greg Stark
• 04:28   Re: pg_ls_tmpdir to show directories and shared filesets (and pg_ls_*) Andres Freund
• 04:32   Re: pg14 psql broke \d datname.nspname.relname Mark Dilger
• 04:34   Re: MDAM techniques and Index Skip Scan patch Andres Freund
• 04:41   Re: Condition pushdown: why (=) is pushed down into join, but BETWEEN or >= is not? Andres Freund
• 04:44   Re: speed up a logical replica setup Fabrízio de Royes Mello
• 04:48   Re: Commitfest manager for 2022-03 Andres Freund
• 04:51   Re: Frontend error logging style Andres Freund
• 04:54   Re: Fast COPY FROM based on batch insert Etsuro Fujita
• 04:54   Re: Per-table storage parameters for TableAM/IndexAM extensions Andres Freund
• 04:55   RE: logical replication empty transactions houzj.fnst@fujitsu.com
• 04:55   RE: Logical replication timeout problem wangw.fnst@fujitsu.com
• 05:00   Re: Frontend error logging style Tom Lane
• 05:13   Re: Frontend error logging style Andres Freund
• 05:16   Re: Why is src/test/modules/committs/t/002_standby.pl flaky? Thomas Munro
• 05:22   Re: [RFC] building postgres with meson -v8 Andres Freund
• 05:34   Re: Make mesage at end-of-recovery less scary. Kyotaro Horiguchi
• 05:36   Re: Fast COPY FROM based on batch insert Etsuro Fujita
• 05:47   Broken make dependency somewhere near win32ver.o? Thomas Munro
• 05:48   Re: On login trigger: take three Andres Freund
• 05:56   Re: shared-memory based stats collector - v67 Kyotaro Horiguchi
• 06:13   Re: Why is src/test/modules/committs/t/002_standby.pl flaky? Tom Lane
• 06:14   Re: Broken make dependency somewhere near win32ver.o? Andres Freund
• 06:19   Re: Add index scan progress to pg_stat_progress_vacuum Masahiko Sawada
• 06:24   Re: Why is src/test/modules/committs/t/002_standby.pl flaky? Thomas Munro
• 06:28   Re: Add index scan progress to pg_stat_progress_vacuum Andres Freund
• 06:31   Re: A test for replay of regression tests Masahiko Sawada
• 06:34   Re: Per-table storage parameters for TableAM/IndexAM extensions Sadhuprasad Patro
• 06:58   Re: A test for replay of regression tests Thomas Munro
• 07:01   Re: simplifying foreign key/RI checks Amit Langote
• 07:01   Re: Commitfest manager for 2022-03 Greg Stark
• 07:27   Re: Out-of-tree certificate interferes ssltest Michael Paquier
• 07:32   Re: [PATCH] Accept IP addresses in server certificate SANs Kyotaro Horiguchi
• 07:58   Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints Dilip Kumar
• 08:03   Re: New Object Access Type hooks Thomas Munro
• 08:06   Re: Add sub-transaction overflow status in pg_stat_activity Dilip Kumar
• 08:09   Re: Broken make dependency somewhere near win32ver.o? Thomas Munro
• 10:08   Skipping schema changes in publication vignesh C
• 10:27   Re: Add index scan progress to pg_stat_progress_vacuum Imseih (AWS), Sami
• 10:35   Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15) Aleksander Alekseev
• 10:48   Re: Add index scan progress to pg_stat_progress_vacuum Masahiko Sawada
• 11:01   Re: pgcrypto: Remove internal padding implementation Peter Eisentraut
• 11:09   Re: logical decoding and replication of sequences Peter Eisentraut
• 11:27   Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors Yugo NAGATA
• 11:31   Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15) Pavel Borisov
• 11:43   Re: On login trigger: take three Daniel Gustafsson
• 11:53   Re: Tab completion for ALTER MATERIALIZED VIEW ... SET ACCESS METHOD Yugo NAGATA
• 12:00   Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints Dilip Kumar
• 12:23   Re: Supply restore_command to pg_rewind via CLI argument Alexey Kondratov
• 12:37   Re: [PATCH] Add native windows on arm64 support Niyas Sait
• 12:44   Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors Tatsuo Ishii
• 12:52   Re: SQL/JSON: JSON_TABLE Matthias Kurz
• 12:53   Re: Identify missing publications from publisher while create/alter subscription. vignesh C
• 13:30   Re: [PATCH] Add native windows on arm64 support Julien Rouhaud
• 14:02   Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Bharath Rupireddy
• 14:23   Re: [PATCH] pg_stat_toast v9 Gunnar \"Nick\" Bluth
• 14:31   Re: [PATCH] Add reloption for views to enable RLS Dean Rasheed
• 14:50   Re: logical replication empty transactions Amit Kapila
• 14:54   Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15) Maxim Orlov
• 15:07   Re: Patch proposal - parameter to limit amount of FPW because of hint bits per second Michail Nikolaev
• 15:09   Re: logical decoding and replication of sequences Amit Kapila
• 15:11   Re: logical decoding and replication of sequences Petr Jelinek
• 15:18   Re: Pluggable toaster Nikita Malakhov
• 15:21   Re: Allow file inclusion in pg_hba and pg_ident files Aleksander Alekseev
• 15:28   Re: Partial aggregates pushdown Tomas Vondra
• 15:32   Re: Allow file inclusion in pg_hba and pg_ident files Aleksander Alekseev
• 15:44   Re: generic plans and "initial" pruning Amit Langote
• 16:15   Re: New Object Access Type hooks Mark Dilger
• 16:21   Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15) Aleksander Alekseev
• 16:25   Re: New Object Access Type hooks Andrew Dunstan
• 16:28   Re: SQL/JSON: JSON_TABLE Oleg Bartunov
• 16:38   Re: Allow file inclusion in pg_hba and pg_ident files Julien Rouhaud
• 16:49   Re: LogwrtResult contended spinlock Alvaro Herrera
• 16:52   Re: [PATCH] Full support for index LP_DEAD hint bits on standby Michail Nikolaev
• 16:59   Re: LogwrtResult contended spinlock Tom Lane
• 17:19   Re: Why is src/test/modules/committs/t/002_standby.pl flaky? Tom Lane
• 17:31   Re: SQL/JSON: JSON_TABLE Andrew Dunstan
• 17:41   Re: New Object Access Type hooks Andrew Dunstan
• 17:42   Re: add checkpoint stats of snapshot and mapping files of pg_logical dir Andres Freund
• 17:51   Re: SQL/JSON: JSON_TABLE Matthias Kurz
• 17:52   Re: psql - add SHOW_ALL_RESULTS option Peter Eisentraut
• 17:53   Re: SQL/JSON: JSON_TABLE Alvaro Herrera
• 17:55   Re: SQL/JSON: JSON_TABLE Daniel Gustafsson
• 18:01   Re: psql - add SHOW_ALL_RESULTS option Peter Eisentraut
• 18:08   Re: Use generation context to speed up tuplesorts David Rowley
• 18:14   Re: New Object Access Type hooks Julien Rouhaud
• 18:23   Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints Robert Haas
• 18:24   Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints Robert Haas
• 18:26   Re: SQL/JSON: JSON_TABLE Oleg Bartunov
• 18:26   Re: New Object Access Type hooks Mark Dilger
• 18:27   Re: SQL/JSON: JSON_TABLE Andrew Dunstan
• 18:28   Re: SQL/JSON: JSON_TABLE Andrew Dunstan
• 18:30   Re: Broken make dependency somewhere near win32ver.o? Andres Freund
• 18:37   Re: refactoring basebackup.c (zstd workers) Robert Haas
• 18:40   Re: [PATCH] pgbench: add multiconnect option David Christensen
• 18:42   Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints Andres Freund
• 18:48   Re: New Object Access Type hooks Andrew Dunstan
• 18:49   Re: preserving db/ts/relfilenode OIDs across pg_upgrade (was Re: storing an explicit nonce) Robert Haas
• 18:55   Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints Robert Haas
• 19:00   Re: Mingw task for Cirrus CI Melih Mutlu
• 19:02   Re: New Object Access Type hooks Tom Lane
• 19:09   Re: New Object Access Type hooks Andrew Dunstan
• 19:11   Re: New Object Access Type hooks Mark Dilger
• 19:11   Re: LogwrtResult contended spinlock Alvaro Herrera
• 19:15   Re: Partial aggregates pushdown Alexander Pyhalov
• 19:15   Re: New Object Access Type hooks Mark Dilger
• 19:26   Re: New Object Access Type hooks Tom Lane
• 19:27   Re: pg_walinspect - a new extension to get raw WAL data and WAL stats Bharath Rupireddy
• 19:33   Re: New Object Access Type hooks Tom Lane
• 19:48   Re: New Object Access Type hooks Mark Dilger
• 19:56   Re: [PATCH] New [relation] option engine Nikolay Shaplov
• 19:58   Re: New Object Access Type hooks Tom Lane
• 20:04   Re: New Object Access Type hooks Andrew Dunstan
• 20:04   Re: New Object Access Type hooks Mark Dilger
• 20:08   Re: New Object Access Type hooks Tom Lane
• 20:22   Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15) Maxim Orlov
• 20:43   LockAcquireExtended() dontWait vs weaker lock levels than already held Andres Freund
• 20:47   Re: New Object Access Type hooks Andrew Dunstan
• 21:00   Re: pg_walinspect - a new extension to get raw WAL data and WAL stats Andres Freund
• 21:01   Re: New Object Access Type hooks Tom Lane
• 21:04   Re: pg14 psql broke \d datname.nspname.relname Robert Haas
• 21:15   Re: [PATCH] Proof of concept for GUC improvements David Christensen
• 21:20   Re: LockAcquireExtended() dontWait vs weaker lock levels than already held Robert Haas
• 21:58   Re: LogwrtResult contended spinlock Alvaro Herrera
• 22:01   Re: LockAcquireExtended() dontWait vs weaker lock levels than already held Andres Freund
• 22:04   Re: [PATCH] Proof of concept for GUC improvements Andres Freund
• 22:04   Re: LockAcquireExtended() dontWait vs weaker lock levels than already held Robert Haas
• 22:24   Re: Column Filtering in Logical Replication Alvaro Herrera
• 23:00   Re: MDAM techniques and Index Skip Scan patch Dmitry Dolgov
• 23:33   Re: MDAM techniques and Index Skip Scan patch Thomas Munro
• 23:34   Re: Optimize external TOAST storage Robert Haas
• 23:34   Re: New Object Access Type hooks Andrew Dunstan
• 23:42   Re: [PATCH] Accept IP addresses in server certificate SANs Jacob Champion
• 23:44   Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints Robert Haas
• 23:55   Re: MDAM techniques and Index Skip Scan patch Tom Lane