pgsql-hackers since 2021-03-11 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 11, 2021

Thread	Author	Time
Re: fdatasync performance problem with large number of DB files	Tom Lane	00:16
Re: fdatasync performance problem with large number of DB files	Thomas Munro	00:17
Re: About to add WAL write/fsync statistics to pg_stat_wal view 📎	Masahiro Ikeda	00:38
Re: Huge memory consumption on partitioned table with FKs	Amit Langote	00:39
Re: [HACKERS] Custom compression methods	Justin Pryzby	00:40
Re: Improve join selectivity estimation using extended statistics	Tomas Vondra	00:47
Re: shared-memory based stats collector	Kyotaro Horiguchi	00:47
Re: pgbench - add pseudo-random permutation function	Bruce Momjian	00:58
Re: fdatasync performance problem with large number of DB files	Fujii Masao	01:00
Re: Boundary value check in lazy_tid_reaped()	Masahiko Sawada	01:01
RE: Enhance traceability of wal_level changes for backup management	[email protected]	01:02
Re: Huge memory consumption on partitioned table with FKs	Keisuke Kuroda	01:06
Re: Removing vacuum_cleanup_index_scale_factor	Peter Geoghegan	01:11
Re: libpq debug log	Kyotaro Horiguchi	01:20
Re: fdatasync performance problem with large number of DB files	Thomas Munro	01:20
Re: fdatasync performance problem with large number of DB files	Tom Lane	01:25
Re: fdatasync performance problem with large number of DB files	Thomas Munro	01:32
Re: 64-bit XIDs in deleted nbtree pages 📎	Peter Geoghegan	01:34
Re: libpq debug log	Tom Lane	01:38
Re: [HACKERS] logical decoding of two-phase transactions 📎	Peter Smith	01:46
Re: [HACKERS] logical decoding of two-phase transactions 📎	Peter Smith	01:50
RE: libpq debug log	[email protected]	01:51
Re: Removing vacuum_cleanup_index_scale_factor	Masahiko Sawada	02:00
Re: Replace buffer I/O locks with condition variables (reviving an old patch)	Julien Rouhaud	02:27
Re: [HACKERS] Custom compression methods 📎	Justin Pryzby	02:28
RE: Parallel INSERT (INTO ... SELECT ...)	[email protected]	02:44
Re: [HACKERS] Custom compression methods	Dilip Kumar	02:47
Re: About to add WAL write/fsync statistics to pg_stat_wal view 📎	Fujii Masao	02:52
Re: Replace buffer I/O locks with condition variables (reviving an old patch)	Thomas Munro	02:54
RE: libpq debug log	[email protected]	03:01
Re: libpq debug log	Kyotaro Horiguchi	03:02
Re: libpq debug log	Kyotaro Horiguchi	03:06
Re: Replace buffer I/O locks with condition variables (reviving an old patch)	Julien Rouhaud	03:11
Re: libpq debug log	Kyotaro Horiguchi	03:11
Re: [HACKERS] Custom compression methods	Justin Pryzby	03:20
Re: shared-memory based stats collector	Andres Freund	03:21
Re: PostmasterIsAlive() in recovery (non-USE_POST_MASTER_DEATH_SIGNAL builds)	Thomas Munro	03:37
Re: [PATCH] Provide more information to filter_prepare	Amit Kapila	03:58
Re: pg_amcheck contrib application 📎	Mark Dilger	04:02
RE: libpq debug log	[email protected]	04:12
Re: shared-memory based stats collector	Andres Freund	04:26
Re: libpq debug log	Kyotaro Horiguchi	04:31
Re: [HACKERS] Custom compression methods	Dilip Kumar	04:37
Re: shared-memory based stats collector	Kyotaro Horiguchi	04:42
Re: Huge memory consumption on partitioned table with FKs	Tatsuro Yamada	06:10
Re: shared-memory based stats collector	Fujii Masao	06:33
Re: PostmasterIsAlive() in recovery (non-USE_POST_MASTER_DEATH_SIGNAL builds)	Michael Paquier	06:34
RE: Parallel INSERT (INTO ... SELECT ...)	[email protected]	06:52
Re: Freeze the inserted tuples during CTAS?	Masahiko Sawada	06:55
Re: [PATCH] pg_permissions 📎	Joel Jacobson	07:00
Re: Queries for PostgreSQL DDL convert	Julien Rouhaud	07:28
Re: Parallel INSERT (INTO ... SELECT ...)	Amit Langote	07:56
Re: [PATCH] Identify LWLocks in tracepoints	Peter Eisentraut	07:57
Re: POC: Cleaning up orphaned files using undo logs	Antonin Houska	07:57
Re: Allow batched insert during cross-partition updates	Amit Langote	08:09
Re: pg_amcheck contrib application	Peter Eisentraut	08:12
Re: cryptohash: missing locking functions for OpenSSL <= 1.0.2?	Michael Paquier	08:18
Re: Parallel INSERT (INTO ... SELECT ...)	Greg Nancarrow	08:33
Re: 回复：Re: Cache relation sizes? 📎	Thomas Munro	08:34
Re: Allow batched insert during cross-partition updates	Amit Langote	08:42
Performance degradation of REFRESH MATERIALIZED VIEW	Masahiko Sawada	08:44
Re: [PATCH] Provide more information to filter_prepare	Markus Wanner	09:14
Re: OpenSSL 3.0.0 compatibility	Peter Eisentraut	10:03
Re: WIP: Aggregation push-down	Antonin Houska	10:10
Re: OpenSSL 3.0.0 compatibility	Daniel Gustafsson	10:41
Re: [HACKERS] Custom compression methods 📎	Dilip Kumar	10:51
first add newly loaded plugin to the list then invoke _PG_init	mickiewicz	11:29
A micro-optimisation for ProcSendSignal() 📎	Thomas Munro	11:31
Re: pg_amcheck contrib application	Andrey Borodin	11:36
Re: Allow batched insert during cross-partition updates	gkokolatos	11:36
Re: New IndexAM API controlling index vacuum strategies	Masahiko Sawada	11:41
Re: first add newly loaded plugin to the list then invoke _PG_init	Julien Rouhaud	11:42
RE: Avoid CommandCounterIncrement in RI trigger when INSERT INTO referencing table 📎	[email protected]	12:01
Re: About to add WAL write/fsync statistics to pg_stat_wal view	Masahiro Ikeda	12:29
Re: [PATCH] Hooks at XactCommand level	David Steele	12:41
Re: [PATCH] Hooks at XactCommand level	Julien Rouhaud	13:01
RE: Parallel INSERT (INTO ... SELECT ...) 📎	[email protected]	13:01
Re: OpenSSL 3.0.0 compatibility	Michael Paquier	13:08
Re: Disallow cancellation of waiting for synchronous replication	David Steele	13:09
Re: WIP: Aggregation push-down	David Steele	13:34
Re: non-HOT update not looking at FSM for large tuple update	Matthias van de Meent	13:45
Self-join optimisation	Hywel Carver	14:06
Re: WIP: System Versioned Temporal Table	Surafel Temesgen	14:14
Re: Disallow cancellation of waiting for synchronous replication	Fujii Masao	14:15
Re: Self-join optimisation	Matthias van de Meent	14:32
Re: About to add WAL write/fsync statistics to pg_stat_wal view	Fujii Masao	14:33
Re: Self-join optimisation	Hywel Carver	14:39
Re: Logical Replication - improve error message while adding tables to the publication in check_publication_add_relation 📎	Bharath Rupireddy	14:56
Re: documentation fix for SET ROLE	Laurenz Albe	14:57
Re: pg_amcheck contrib application	Mark Dilger	15:14
Re: non-HOT update not looking at FSM for large tuple update	John Naylor	15:16
Re: pg_amcheck contrib application	Mark Dilger	15:30
Re: Self-join optimisation	Justin Pryzby	15:30
Re: pg_amcheck contrib application	Robert Haas	15:46
Re: MultiXact\SLRU buffers configuration	Gilles Darold	15:50
Re: [HACKERS] PATCH: Batch/pipelining support for libpq 📎	Alvaro Herrera	16:00
Re: Autovacuum on partitioned table (autoanalyze)	David Steele	16:06
Re: documentation fix for SET ROLE	David G. Johnston	16:08
Re: pg_amcheck contrib application	Robert Haas	16:09
Re: WIP: BRIN multi-range indexes 📎	Tomas Vondra	16:26
Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY 📎	Alvaro Herrera	16:26
Re: Disallow cancellation of waiting for synchronous replication	Andrey Borodin	16:28
Re: New IndexAM API controlling index vacuum strategies	Robert Haas	16:31
Re: pgbench - add pseudo-random permutation function 📎	Dean Rasheed	16:31
Re: Huge memory consumption on partitioned table with FKs	Tom Lane	17:01
Re: pg_amcheck contrib application	Andrey Borodin	17:10
Re: pg_amcheck contrib application	Mark Dilger	17:42
Re: Huge memory consumption on partitioned table with FKs	Tom Lane	17:44
Re: Parallel INSERT (INTO ... SELECT ...)	Tom Lane	18:00
Re: Performance degradation of REFRESH MATERIALIZED VIEW	Andres Freund	18:13
Re: [HACKERS] Custom compression methods 📎	Justin Pryzby	18:25
Re: [HACKERS] PATCH: Batch/pipelining support for libpq	Tom Lane	18:49
Re: A qsort template	Andres Freund	18:58
Re: pgbench - add pseudo-random permutation function	David Bowen	19:06
Re: New IndexAM API controlling index vacuum strategies	Matthias van de Meent	19:21
Re: pg_amcheck contrib application	Robert Haas	19:34
Re: pgbench - add pseudo-random permutation function	Dean Rasheed	19:34
Re: libpq debug log	Tom Lane	19:45
Re: documentation fix for SET ROLE 📎	Bossart, Nathan	20:00
Re: documentation fix for SET ROLE	David G. Johnston	20:09
Re: Is Recovery actually paused?	Robert Haas	20:34
Re: Parallel INSERT (INTO ... SELECT ...)	Justin Pryzby	21:10
Re: [HACKERS] Custom compression methods	Justin Pryzby	21:24
Re: pg_amcheck contrib application 📎	Robert Haas	21:59
Re: cursor sensitivity misunderstanding	Peter Eisentraut	22:02
Re: [PATCH] Covering SPGiST index	Tom Lane	22:18
Re: documentation fix for SET ROLE 📎	Bossart, Nathan	22:30
Re: Self-join optimisation	Tomas Vondra	22:50
Re: OpenSSL 3.0.0 compatibility 📎	Peter Eisentraut	23:04
Re: OpenSSL 3.0.0 compatibility	Daniel Gustafsson	23:22
Re: Parallel INSERT (INTO ... SELECT ...)	Greg Nancarrow	23:26
Re: [Patch] Optimize dropping of relation buffers using dlist	Thomas Munro	23:27

March 12, 2021

Thread	Author	Time
Re: automatic analyze: readahead - add "IO read time" log message 📎	Stephen Frost	00:11
Re: shared-memory based stats collector 📎	Kyotaro Horiguchi	00:23
Re: automatic analyze: readahead - add "IO read time" log message	Tomas Vondra	00:29
Re: Hybrid Hash/Nested Loop joins and caching results from subplans	David Rowley	00:31
Re: Hybrid Hash/Nested Loop joins and caching results from subplans	David Rowley	00:38
Re: automatic analyze: readahead - add "IO read time" log message	Stephen Frost	00:41
Re: [PATCH] Covering SPGiST index	Tom Lane	00:42
Re: compression libraries and CF bot	Thomas Munro	00:44
Re: Is Recovery actually paused?	Dilip Kumar	00:51
Re: shared-memory based stats collector	Fujii Masao	01:03
Re: New IndexAM API controlling index vacuum strategies	Peter Geoghegan	01:05
Re: shared-memory based stats collector	Kyotaro Horiguchi	01:07
Re: shared-memory based stats collector	Kyotaro Horiguchi	01:16
Re: shared-memory based stats collector	Kyotaro Horiguchi	01:38
Re: Hybrid Hash/Nested Loop joins and caching results from subplans 📎	David Rowley	01:49
Re: Procedures versus the "fastpath" API	Noah Misch	01:52
Re: Hybrid Hash/Nested Loop joins and caching results from subplans	Tom Lane	01:59
HotStandbyActive() issue in postgres 📎	Hao Wu	02:14
Re: Allow batched insert during cross-partition updates	Amit Langote	02:45
Re: Hybrid Hash/Nested Loop joins and caching results from subplans	David Rowley	03:01
Re: [HACKERS] Custom compression methods	Dilip Kumar	03:08
Re: shared-memory based stats collector	Andres Freund	03:22
Re: [HACKERS] Custom compression methods	Justin Pryzby	03:24
Re: Key management with tests 📎	Bruce Momjian	03:31
Re: [HACKERS] Custom compression methods	Justin Pryzby	03:33
Re: Huge memory consumption on partitioned table with FKs	Tatsuro Yamada	03:35
Re: About to add WAL write/fsync statistics to pg_stat_wal view	Fujii Masao	03:39
RE: Parallel INSERT (INTO ... SELECT ...)	[email protected]	04:03
Re: [HACKERS] Custom compression methods	Dilip Kumar	04:07
Re: [HACKERS] Custom compression methods	Dilip Kumar	04:08
Re: [Patch] Optimize dropping of relation buffers using dlist	Amit Kapila	04:20
Re: [HACKERS] Custom compression methods	Dilip Kumar	04:22
Re: [Patch] Optimize dropping of relation buffers using dlist	Thomas Munro	04:27
RE: [Patch] Optimize dropping of relation buffers using dlist	[email protected]	04:30
Re: Performance degradation of REFRESH MATERIALIZED VIEW	Masahiko Sawada	04:32
Re: shared-memory based stats collector 📎	Kyotaro Horiguchi	04:49
Re: pg_amcheck contrib application 📎	Mark Dilger	05:00
Re: [HACKERS] logical decoding of two-phase transactions	vignesh C	05:07
Re: [HACKERS] Custom compression methods 📎	Justin Pryzby	05:15
Re: About to add WAL write/fsync statistics to pg_stat_wal view	Fujii Masao	05:25
RE: [Patch] Optimize dropping of relation buffers using dlist 📎	[email protected]	05:26
Re: shared-memory based stats collector	Kyotaro Horiguchi	05:32
RE: [POC] Fast COPY FROM command for the table with foreign partitions 📎	[email protected]	05:54
Re: [HACKERS] Custom compression methods	Dilip Kumar	05:54
Re: [PATCH] Hooks at XactCommand level	Julien Rouhaud	05:55
Re: [Patch] Optimize dropping of relation buffers using dlist	Kyotaro Horiguchi	06:10
Re: shared-memory based stats collector	Fujii Masao	06:13
Re: [HACKERS] Custom compression methods	Justin Pryzby	06:25
Re: [HACKERS] Custom compression methods	Dilip Kumar	06:30
RE: [Patch] Optimize dropping of relation buffers using dlist 📎	[email protected]	06:36
RE: [Patch] Optimize dropping of relation buffers using dlist	[email protected]	06:55
Re: PostmasterIsAlive() in recovery (non-USE_POST_MASTER_DEATH_SIGNAL builds)	Thomas Munro	06:55
Re: Parallel INSERT (INTO ... SELECT ...)	Amit Langote	07:05
Re: Parallel INSERT (INTO ... SELECT ...) 📎	Greg Nancarrow	07:23
RE: Enhance traceability of wal_level changes for backup management	[email protected]	07:25
Re: Different compression methods for FPI 📎	Justin Pryzby	07:45
Re: OpenSSL 3.0.0 compatibility	Peter Eisentraut	07:51
Re: Enhance traceability of wal_level changes for backup management	Peter Eisentraut	08:03
RE: Parallel INSERT (INTO ... SELECT ...)	[email protected]	08:03
Re: [PATCH] Disable bgworkers during servers start in pg_upgrade	Julien Rouhaud	08:23
Re: shared-memory based stats collector 📎	Kyotaro Horiguchi	08:24
Re: [HACKERS] logical decoding of two-phase transactions 📎	Peter Smith	08:39
Re: [HACKERS] Custom compression methods	Dilip Kumar	08:42
Re: HotStandbyActive() issue in postgres	Fujii Masao	08:58
Re: [HACKERS] logical decoding of two-phase transactions	Peter Smith	08:59
Re: Removing unneeded self joins	Hywel Carver	09:05
Re: documentation fix for SET ROLE	Laurenz Albe	09:16
Re: Self-join optimisation	Hywel Carver	09:20

Browse Archives

Prev | Next