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

April 3, 2022

Thread	Author	Time
Re: [PATCH] Improve amcheck to also check UNIQUE constraint in btree index.	Greg Stark	00:02
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements	Tom Lane	00:30
Re: Skipping logical replication transactions on subscriber side	Noah Misch	00:45
CFBot failing with "Failed to start an instance"	Greg Stark	01:06
Re: Pluggable toaster	Greg Stark	01:20
Re: Pluggable toaster	Andres Freund	02:06
Re: Higher level questions around shared memory stats	Andres Freund	02:45
Re: CFBot failing with "Failed to start an instance"	Thomas Munro	02:52
CLUSTER sort on abbreviated expressions is broken 📎	Thomas Munro	04:05
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements 📎	Andrei Zubkov	04:32
Re: A qsort template 📎	Thomas Munro	05:46
Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors	Tatsuo Ishii	06:28
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements	Julien Rouhaud	07:07
Re: Fix overflow in DecodeInterval	Tom Lane	07:09
Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors	Fabien COELHO	08:20
Re: CLUSTER sort on abbreviated expressions is broken	John Naylor	08:22
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements	Andrei Zubkov	08:34
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements 📎	Andrei Zubkov	09:29
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements	Julien Rouhaud	09:56
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements	Andrei Zubkov	10:24
Re: Defer selection of asynchronous subplans until the executor initialization stage 📎	Etsuro Fujita	10:29
Re: generic plans and "initial" pruning	Alvaro Herrera	11:21
Re: Higher level questions around shared memory stats	Alvaro Herrera	11:34
Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors	Tatsuo Ishii	11:44
Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors	Alvaro Herrera	11:54
Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors	Tatsuo Ishii	12:59
Re: Pluggable toaster	Nikita Malakhov	13:15
Re: Skip partition tuple routing with constant partition key	Greg Stark	13:31
Re: pg_ls_tmpdir to show directories and shared filesets (and pg_ls_*)	Greg Stark	13:39
Re: Defer selection of asynchronous subplans until the executor initialization stage	Zhihong Yu	14:42
Re: Fix overflow in DecodeInterval	Joseph Koshakow	15:23
Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors	Tom Lane	15:43
Re: Fix overflow in DecodeInterval	Tom Lane	15:44
Re: Fix overflow in DecodeInterval	Tom Lane	16:03
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints	Andres Freund	16:21
Re: Fix overflow in DecodeInterval	Joseph Koshakow	16:22
Re: Fix overflow in DecodeInterval	Tom Lane	16:30
Re: A qsort template	Andres Freund	16:32
Re: Enables to call Unregister*XactCallback() in Call*XactCallback()	Andres Freund	16:39
Re: Fix overflow in DecodeInterval	Joseph Koshakow	16:44
Re: Add index scan progress to pg_stat_progress_vacuum	Andres Freund	16:50
Re: Fix overflow in DecodeInterval 📎	Joseph Koshakow	17:00
Re: unlogged sequences 📎	Peter Eisentraut	17:19
Re: unlogged sequences	David G. Johnston	18:50
Run pg_amcheck in 002_pg_upgrade.pl and 027_stream_regress.pl?	Andres Freund	18:53
Re: Removing more vacuumlazy.c special cases, relfrozenxid optimizations	Andres Freund	19:05
Re: Fix overflow in DecodeInterval 📎	Tom Lane	19:06
Re: PATCH: add "--config-file=" option to pg_rewind 📎	Michael Banck	19:31
Re: unlogged sequences	Peter Eisentraut	19:36
Re: logical decoding and replication of sequences 📎	Tomas Vondra	21:40
Re: CLUSTER sort on abbreviated expressions is broken	Thomas Munro	22:04
Re: Fix overflow in DecodeInterval	Joseph Koshakow	22:19
Re: JSON constructors and window functions	Andrew Dunstan	22:56
Re: A qsort template	Thomas Munro	23:01
Re: CLUSTER sort on abbreviated expressions is broken	Peter Geoghegan	23:11
Re: CLUSTER sort on abbreviated expressions is broken	Thomas Munro	23:33
Re: unlogged sequences	David G. Johnston	23:58

April 4, 2022

Thread	Author	Time
Re: JSON constructors and window functions	Andres Freund	00:11
Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors 📎	Tatsuo Ishii	01:14
Re: unlogged sequences	David G. Johnston	01:16
Re: Skipping logical replication transactions on subscriber side 📎	Masahiko Sawada	01:28
Re: Removing more vacuumlazy.c special cases, relfrozenxid optimizations	Peter Geoghegan	01:52
Re: Run pg_amcheck in 002_pg_upgrade.pl and 027_stream_regress.pl?	Peter Geoghegan	02:10
Re: Skipping logical replication transactions on subscriber side	Noah Misch	02:31
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements	Julien Rouhaud	02:31
Re: JSON constructors and window functions	Andrew Dunstan	02:46
Re: Skipping logical replication transactions on subscriber side	Amit Kapila	02:50
Re: Extensible Rmgr for Table AMs 📎	Jeff Davis	03:03
Re: PostgreSQL shutdown modes	Kyotaro Horiguchi	03:04
Re: Skipping logical replication transactions on subscriber side	Masahiko Sawada	03:10
Re: WIP: WAL prefetch (another approach)	Julien Rouhaud	03:12
Re: Skipping logical replication transactions on subscriber side	Amit Kapila	03:32
Re: pg_walinspect - a new extension to get raw WAL data and WAL stats	Bharath Rupireddy	03:45
Re: Defer selection of asynchronous subplans until the executor initialization stage	Etsuro Fujita	04:06
Re: shared-memory based stats collector - v68 📎	Andres Freund	04:15
Re: Naming of the different stats systems / "stats collector"	Andres Freund	04:22
Re: Showing I/O timings spent reading/writing temp buffers in EXPLAIN	Julien Rouhaud	04:30
Re: Extensible Rmgr for Table AMs	Andres Freund	04:33
Race condition in server-crash testing	Tom Lane	04:50
Re: Race condition in server-crash testing	Andres Freund	05:07
Re: Extensible Rmgr for Table AMs	Bharath Rupireddy	05:45
Re: Race condition in server-crash testing	Noah Misch	05:52
Re: logical decoding and replication of sequences	Masahiko Sawada	06:12
Re: Skipping logical replication transactions on subscriber side	Noah Misch	06:26
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements 📎	Andrei Zubkov	06:59
Re: unlogged sequences	Peter Eisentraut	07:20
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements	Julien Rouhaud	08:08
Re: Removing unneeded self joins 📎	Andrey V. Lepikhov	08:27
Re: standby recovery fails (tablespace related) (tentative patch and discussion)	Kyotaro Horiguchi	08:29
collect_corrupt_items_vacuum.patch 📎	Daniel Shelepanov	08:51
Re: standby recovery fails (tablespace related) (tentative patch and discussion)	Kyotaro Horiguchi	08:54
Re: [PATCH] Improve amcheck to also check UNIQUE constraint in btree index. 📎	Pavel Borisov	09:18
Re: Defer selection of asynchronous subplans until the executor initialization stage	Andrey V. Lepikhov	09:30
Re: Skipping logical replication transactions on subscriber side	Masahiko Sawada	09:55
Re: [Proposal] Fully WAL logged CREATE DATABASE - No Checkpoints 📎	Dilip Kumar	10:24
Re: Use generation context to speed up tuplesorts	David Rowley	11:18
Re: logical decoding and replication of sequences	Amit Kapila	11:45
Re: Reword docs of feature "Remove temporary files after backend crash"	Daniel Gustafsson	12:29
Re: generic plans and "initial" pruning 📎	Amit Langote	12:55
Re: CLUSTER on partitioned index	Justin Pryzby	12:59
Re: [PATCH v2] use has_privs_for_role for predefined roles	Robert Haas	13:05
Re: pg_rewind copies	Peter Eisentraut	13:08
Re: shared-memory based stats collector - v68	Thomas Munro	13:16
GSoC: pgmoneta, storage API	Mariam Fahmy	13:16
Re: PostgreSQL shutdown modes	Robert Haas	13:19
Re: Handle infinite recursion in logical replication setup	Ashutosh Bapat	13:20
Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors	Fabien COELHO	13:20
Re: GSoC: pgmoneta, storage API	Jesper Pedersen	13:23
Re: use has_privs_of_role() for pg_hba.conf	Joshua Brindle	13:36
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file	David Steele	13:56
Re: Run pg_amcheck in 002_pg_upgrade.pl and 027_stream_regress.pl?	Robert Haas	14:02
Re: wrong fds used for refilenodes after pg_upgrade relfilenode changes Reply-To:	Robert Haas	14:18
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file 📎	Nathan Bossart	14:22
Re: use has_privs_of_role() for pg_hba.conf	Nathan Bossart	14:25
Re: basebackup/lz4 crash	Robert Haas	14:45
Re: JSON constructors and window functions	Andrew Dunstan	15:09
Re: Add non-blocking version of PQcancel 📎	Jelte Fennema	15:21
Re: Granting SET and ALTER SYSTE privileges for GUCs	Tom Lane	15:36
Re: PATCH: add "--config-file=" option to pg_rewind 📎	Greg Stark	15:39
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file 📎	Nathan Bossart	15:42
Re: JSON constructors and window functions	Tom Lane	15:43
Re: standby recovery fails (tablespace related) (tentative patch and discussion)	Dilip Kumar	15:44
Re: Granting SET and ALTER SYSTE privileges for GUCs	Mark Dilger	15:47
Re: Showing I/O timings spent reading/writing temp buffers in EXPLAIN	Masahiko Sawada	15:51
Re: JSON constructors and window functions	Greg Stark	15:54
Re: Pluggable toaster 📎	Nikita Malakhov	16:12
Re: New Object Access Type hooks	Mark Dilger	16:16
Re: JSON constructors and window functions	Andres Freund	16:21
Re: Run pg_amcheck in 002_pg_upgrade.pl and 027_stream_regress.pl?	Peter Geoghegan	16:27
Re: Run pg_amcheck in 002_pg_upgrade.pl and 027_stream_regress.pl?	Mark Dilger	16:30
Re: Showing I/O timings spent reading/writing temp buffers in EXPLAIN	Julien Rouhaud	16:31
Re: Granting SET and ALTER SYSTE privileges for GUCs 📎	Mark Dilger	16:31
Re: JSON constructors and window functions	Andres Freund	16:33
Re: Pluggable toaster	Robert Haas	16:39
Re: A test for replay of regression tests	Tom Lane	16:39
Re: New Object Access Type hooks	Tom Lane	17:03
Re: Postgres restart in the middle of exclusive backup and the presence of backup_label file	David Steele	17:11
Re: New Object Access Type hooks	Tom Lane	17:41
Re: New Object Access Type hooks	Mark Dilger	17:44
Re: New Object Access Type hooks	Tom Lane	17:51
Re: shared-memory based stats collector - v68	Andres Freund	17:54
Re: New Object Access Type hooks 📎	Mark Dilger	17:56
Re: New Object Access Type hooks	Tom Lane	18:07
Re: New Object Access Type hooks 📎	Mark Dilger	18:09
Re: Run pg_amcheck in 002_pg_upgrade.pl and 027_stream_regress.pl?	Andres Freund	18:16
Re: JSON constructors and window functions	Andrew Dunstan	18:19
Re: JSON constructors and window functions	Andrew Dunstan	18:25
Re: Run pg_amcheck in 002_pg_upgrade.pl and 027_stream_regress.pl?	Robert Haas	18:31
Re: New Object Access Type hooks	Mark Dilger	18:32
Re: New Object Access Type hooks	Tom Lane	19:01
Re: New Object Access Type hooks	Tom Lane	19:05
Re: shared-memory based stats collector - v68	Andres Freund	19:08
Re: Pluggable toaster	Greg Stark	19:32
Re: Higher level questions around shared memory stats	Andres Freund	19:34
pushdown of joinquals beyond group by/distinct on 📎	Arne Roland	19:39
Re: Pluggable toaster	Nikita Malakhov	20:05
Re: Pluggable toaster	Robert Haas	20:17
Re: New Object Access Type hooks	Mark Dilger	20:28
Re: Mingw task for Cirrus CI	Andres Freund	20:41
Re: shared-memory based stats collector - v68	David G. Johnston	20:45
Re: New Object Access Type hooks	Tom Lane	20:47
Re: New Object Access Type hooks	Mark Dilger	20:50
Re: shared-memory based stats collector - v68	Andres Freund	21:06
Re: shared-memory based stats collector - v68	David G. Johnston	21:25
Re: Granting SET and ALTER SYSTE privileges for GUCs	Tom Lane	21:26
Re: psql - add SHOW_ALL_RESULTS option	Peter Eisentraut	21:32
Re: shared-memory based stats collector - v68	Andres Freund	21:54
Re: Granting SET and ALTER SYSTE privileges for GUCs	Andrew Dunstan	22:15
Re: shared-memory based stats collector - v68	David G. Johnston	22:24
Re: wrong fds used for refilenodes after pg_upgrade relfilenode changes Reply-To:	Thomas Munro	22:24
Re: shared-memory based stats collector - v68	Andres Freund	22:44
Re: pushdown of joinquals beyond group by/distinct on	David Rowley	23:09
Re: shared-memory based stats collector - v67	Andres Freund	23:31
Re: [HACKERS] WIP aPatch: Pgbench Serialization and deadlock errors 📎	Tatsuo Ishii	23:38
Re: Run pg_amcheck in 002_pg_upgrade.pl and 027_stream_regress.pl?	Michael Paquier	23:46

April 5, 2022

Thread	Author	Time
Re: Granting SET and ALTER SYSTE privileges for GUCs	Mark Dilger	00:01
Re: Window Function "Run Conditions" 📎	David Rowley	00:04
Re: Extensible Rmgr for Table AMs	Jeff Davis	00:10
Re: Granting SET and ALTER SYSTE privileges for GUCs	Tom Lane	00:12
Re: Granting SET and ALTER SYSTE privileges for GUCs	Mark Dilger	00:16
Re: Skipping logical replication transactions on subscriber side	Noah Misch	00:21
Re: Extensible Rmgr for Table AMs 📎	Jeff Davis	00:25
Re: Run pg_amcheck in 002_pg_upgrade.pl and 027_stream_regress.pl?	Andres Freund	00:39
Re: Handle infinite recursion in logical replication setup	Peter Smith	00:51
Re: Skipping logical replication transactions on subscriber side	Masahiko Sawada	01:13
Re: Add LZ4 compression in pg_dump 📎	Michael Paquier	01:34
Re: Showing I/O timings spent reading/writing temp buffers in EXPLAIN 📎	Masahiko Sawada	01:40
Re: Skipping logical replication transactions on subscriber side	Noah Misch	01:46
Re: Handle infinite recursion in logical replication setup	vignesh C	01:54
Re: shared-memory based stats collector - v68	David G. Johnston	02:03
Re: PATCH: add "--config-file=" option to pg_rewind	Michael Paquier	02:10
Re: New Object Access Type hooks	Tom Lane	02:10
Re: Run pg_amcheck in 002_pg_upgrade.pl and 027_stream_regress.pl?	Michael Paquier	02:12
Re: standby recovery fails (tablespace related) (tentative patch and discussion)	Kyotaro Horiguchi	02:16
Re: wrong fds used for refilenodes after pg_upgrade relfilenode changes Reply-To:	Thomas Munro	02:19
Re: Lowering the ever-growing heap->pd_lower	Peter Geoghegan	02:24
Re: generic plans and "initial" pruning 📎	Amit Langote	02:29
Re: Removing more vacuumlazy.c special cases, relfrozenxid optimizations	Peter Geoghegan	02:32
Re: Window Function "Run Conditions"	Andy Fan	02:35
Re: Handle infinite recursion in logical replication setup	Amit Kapila	02:36

Browse Archives

Prev | Next