pgsql-hackers since 2022-03-22 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

March 22, 2022

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

Browse Archives

Prev | Next