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

Thread	Author	Time
Re: [patch] [doc] Minor variable related cleanup and rewording of plpgsql docs	David Steele	00:28
Re: [HACKERS] logical decoding of two-phase transactions 📎	Ajin Cherian	00:58
Re: documentation fix for SET ROLE 📎	Bossart, Nathan	01:27
Re: Boundary value check in lazy_tid_reaped() 📎	Masahiko Sawada	01:29
Re: Columns correlation and adaptive query optimization	Tomas Vondra	02:00
pgsql: Enable parallel SELECT for "INSERT INTO ... SELECT ...".	Amit Kapila	02:17
RE: Avoid CommandCounterIncrement in RI trigger when INSERT INTO referencing table	[email protected]	02:24
Re: shared-memory based stats collector 📎	Kyotaro Horiguchi	03:10
Re: Add some tests for pg_stat_statements compatibility verification under contrib	Julien Rouhaud	03:35
Re: pgsql: Enable parallel SELECT for "INSERT INTO ... SELECT ...".	Tom Lane	03:37
Re: Removing vacuum_cleanup_index_scale_factor 📎	Peter Geoghegan	03:42
Re: a verbose option for autovacuum 📎	Masahiko Sawada	03:46
Re: pgsql: Enable parallel SELECT for "INSERT INTO ... SELECT ...".	Amit Kapila	04:16
Re: New Table Access Methods for Multi and Single Inserts 📎	Bharath Rupireddy	04:51
Re: pgbench: option delaying queries till connections establishment?	Thomas Munro	04:54
RE: libpq debug log 📎	[email protected]	05:03
Re: About to add WAL write/fsync statistics to pg_stat_wal view	Masahiro Ikeda	05:11
Re: Confusing behavior of psql's \e	Tom Lane	05:13
Logical Replication - improve error message while adding tables to the publication in check_publication_add_relation 📎	Bharath Rupireddy	05:14
Re: [HACKERS] logical decoding of two-phase transactions	Peter Smith	05:37
Re: [PATCH] Identify LWLocks in tracepoints 📎	Craig Ringer	05:38
pgsql: Move tablespace path re-creation from the makefiles to pg_regres	Michael Paquier	05:55
Re: shared-memory based stats collector	Fujii Masao	06:20
Re: Occasional tablespace.sql failures in check-world -jnn	Michael Paquier	06:40
Re: Add some tests for pg_stat_statements compatibility verification under contrib 📎	Erica Zhang	06:51
Re: Freeze the inserted tuples during CTAS?	Paul Guo	06:57
Re: a misbehavior of partition row movement (?)	Masahiko Sawada	07:50
Re: Logical Replication - improve error message while adding tables to the publication in check_publication_add_relation	Jeevan Ladhe	07:56
Re: About to add WAL write/fsync statistics to pg_stat_wal view	Fujii Masao	08:08
Queries for PostgreSQL DDL convert 📎	杨逸存	08:09
Re: Release SPI plans for referential integrity with DISCARD ALL 📎	yuzuko	08:19
Re: cryptohash: missing locking functions for OpenSSL <= 1.0.2? 📎	Michael Paquier	08:21
Re: OpenSSL 3.0.0 compatibility	Daniel Gustafsson	08:23
RE: Avoid CommandCounterIncrement in RI trigger when INSERT INTO referencing table	[email protected]	08:24
Re: Improvements and additions to COPY progress reporting	Matthias van de Meent	08:35
Re: shared-memory based stats collector 📎	Kyotaro Horiguchi	08:51
Re: Procedures versus the "fastpath" API	Laurenz Albe	09:03
Re: Parallel INSERT (INTO ... SELECT ...)	Amit Kapila	09:18
Re: Confusing behavior of psql's \e	Juan José Santamaría Flecha	10:16
Re: [PATCH] Provide more information to filter_prepare	Amit Kapila	10:18
Re: Confusing behavior of psql's \e 📎	Laurenz Albe	10:32
Do we support upgrade of logical replication?	vignesh C	10:33
Re: [PATCH] Provide more information to filter_prepare	Markus Wanner	10:56
Re: Logical Replication - improve error message while adding tables to the publication in check_publication_add_relation	Bharath Rupireddy	11:33
RE: Parallel Inserts in CREATE TABLE AS	[email protected]	11:39
Re: [HACKERS] Custom compression methods 📎	Dilip Kumar	11:51
Re: Logical Replication - improve error message while adding tables to the publication in check_publication_add_relation	Euler Taveira	12:17
Re: Allow batched insert during cross-partition updates	Georgios	12:23
Re: Allow batched insert during cross-partition updates 📎	Georgios	12:30
Re: [HACKERS] logical decoding of two-phase transactions 📎	Peter Smith	12:47
Re: shared-memory based stats collector 📎	Fujii Masao	12:47
Re: Change JOIN tutorial to focus more on explicit joins	David Steele	13:06
Re: error_severity of brin work item	David Steele	13:24
Re: libpq debug log 📎	'[email protected]'	13:31
Re: get rid of <foreignphrase> tags in the docs? 📎	John Naylor	13:47
Re: proposal: unescape_text function	David Steele	13:52
Re: Parallel INSERT (INTO ... SELECT ...)	Dilip Kumar	14:00
Re: Lowering the ever-growing heap->pd_lower 📎	Matthias van de Meent	14:01
Re: [PATCH] SET search_path += octopus	David Steele	14:24
Re: libpq debug log 📎	'[email protected]'	14:35
Re: WIP: document the hook system	David Steele	14:38
Re: Boundary value check in lazy_tid_reaped()	Peter Eisentraut	14:53
Re: Huge memory consumption on partitioned table with FKs 📎	Amit Langote	15:44
Re: pg_amcheck contrib application 📎	Mark Dilger	16:10
Re: [PATCH] Covering SPGiST index	David Steele	16:48
Re: WIP: document the hook system	David Fetter	16:48
Re: WIP: System Versioned Temporal Table	Surafel Temesgen	16:49
Re: Evaluate expression at planning time for two more cases	Surafel Temesgen	16:58
Re: WIP: System Versioned Temporal Table	Vik Fearing	17:02
Re: cryptohash: missing locking functions for OpenSSL <= 1.0.2?	Jacob Champion	17:05
Re: Add header support to text format and matching feature	David Steele	17:13
Re: Consider parallel for lateral subqueries with limit	David Steele	17:31
Re: get rid of <foreignphrase> tags in the docs?	Tom Lane	17:39
Re: Speeding up GIST index creation for tsvectors	John Naylor	18:08
Re: Huge memory consumption on partitioned table with FKs	Tom Lane	19:24
Re: libpq debug log	'[email protected]'	19:43
Re: libpq debug log	Tom Lane	20:03
Re: Occasional tablespace.sql failures in check-world -jnn	Andres Freund	20:17
fdatasync performance problem with large number of DB files	Michael Brown	20:21
Re: libpq debug log	Tom Lane	20:25
Re: pg_amcheck contrib application	Robert Haas	20:28
Re: [HACKERS] Custom compression methods	Robert Haas	20:50
Re: libpq debug log	'[email protected]'	21:26
Re: libpq debug log	'[email protected]'	21:29
Re: libpq debug log 📎	Tom Lane	21:33
Re: Replace buffer I/O locks with condition variables (reviving an old patch)	Thomas Munro	21:48
Re: GiST comment improvement	Bruce Momjian	22:03
Re: libpq debug log	Alvaro Herrera	22:25
Re: automatic analyze: readahead - add "IO read time" log message	Tomas Vondra	22:29
Re: fdatasync performance problem with large number of DB files	Thomas Munro	22:38
Re: Speeding up GIST index creation for tsvectors 📎	John Naylor	22:55
Re: Columns correlation and adaptive query optimization	Tomas Vondra	23:03
Re: PROXY protocol support	Jacob Champion	23:05
Re: Hybrid Hash/Nested Loop joins and caching results from subplans 📎	David Rowley	23:17
Re: libpq debug log	Tom Lane	23:24
Re: fdatasync performance problem with large number of DB files	Thomas Munro	23:30

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

Browse Archives

Prev | Next