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

Thread	Author	Time
Re: PITR promote bug: Checkpointer writes to older timeline	Michael Paquier	00:07
Re: Log message for GSS connection is missing once connection authorization is successful.	Michael Paquier	00:09
Why logical replication lancher exits 1?	Tatsuo Ishii	00:11
Re: Using COPY FREEZE in pgbench	Tatsuo Ishii	00:22
Re: About to add WAL write/fsync statistics to pg_stat_wal view 📎	ikedamsh	00:50
Re: shared-memory based stats collector	Kyotaro Horiguchi	00:55
PostgreSQL 14 Feature Freeze + Release Management Team (RMT)	Michael Paquier	01:17
Re: Why logical replication lancher exits 1?	Thomas Munro	01:53
Re: row filtering for logical replication	Euler Taveira	01:58
Re: row filtering for logical replication 📎	Euler Taveira	02:15
Re: Wrong statistics for size of XLOG_SWITCH during pg_waldump. 📎	Fujii Masao	02:22
Re: replication cleanup code incorrect way to use of HTAB HASH_REMOVE ?	Amit Kapila	02:27
Re: Columns correlation and adaptive query optimization	Yugo NAGATA	02:29
Re: Add client connection check during the execution of the query 📎	Thomas Munro	02:29
Re: Why logical replication lancher exits 1?	Tatsuo Ishii	02:36
Re: Replication slot stats misgivings	Amit Kapila	02:56
Re: Type of wait events WalReceiverWaitStart and WalSenderWaitForWAL	Kyotaro Horiguchi	03:01
Re: shared-memory based stats collector	Kyotaro Horiguchi	03:02
Re: [PATCH] pgbench: improve \sleep meta command	Fujii Masao	03:06
Re: Support ALTER SUBSCRIPTION ... ADD/DROP PUBLICATION ... syntax	Bharath Rupireddy	03:14
Re: a verbose option for autovacuum 📎	Masahiko Sawada	03:17
RE: Parallel INSERT (INTO ... SELECT ...)	[email protected]	03:30
Re: proposal - psql - use pager for \watch command	Thomas Munro	03:55
Re: proposal - psql - use pager for \watch command	Pavel Stehule	04:09
RE: Disable WAL logging to speed up data loading	[email protected]	04:18
Re: Replication slot stats misgivings	Masahiko Sawada	04:25
Can we remove extra memset in BloomInitPage, GinInitPage and SpGistInitPage when we have it in PageInit? 📎	Bharath Rupireddy	04:46
Re: Type of wait events WalReceiverWaitStart and WalSenderWaitForWAL 📎	Fujii Masao	04:59
RE: Wrong statistics for size of XLOG_SWITCH during pg_waldump.	Shinya11.Kato	05:03
Re: [HACKERS] make async slave to wait for lsn to be replayed 📎	Kyotaro Horiguchi	05:05
Re: Wrong statistics for size of XLOG_SWITCH during pg_waldump. 📎	Fujii Masao	05:07
Re: WIP: BRIN multi-range indexes 📎	Tomas Vondra	05:27
Re: Can we remove extra memset in BloomInitPage, GinInitPage and SpGistInitPage when we have it in PageInit?	Mahendra Singh Thalor	05:28
Re: Permission failures with WAL files in 13~ on Windows	Michael Paquier	05:46
RE: Avoid CommandCounterIncrement in RI trigger when INSERT INTO referencing table 📎	[email protected]	05:57
Re: Get memory contexts of an arbitrary backend process 📎	torikoshia	06:09
Re: Proposal: Save user's original authenticated identity for logging 📎	Michael Paquier	06:16
[CLOBBER_CACHE]Server crashed with segfault 11 while executing clusterdb	Neha Sharma	06:23
Re: [Patch] ALTER SYSTEM READ ONLY 📎	Amul Sul	06:43
Re: Replication slot stats misgivings	Masahiko Sawada	06:49
Re: Parallel INSERT (INTO ... SELECT ...)	Greg Nancarrow	06:58
Re: [HACKERS] logical decoding of two-phase transactions 📎	Peter Smith	07:27
RE: Parallel INSERT (INTO ... SELECT ...)	[email protected]	07:27
Re: Using COPY FREEZE in pgbench	Fabien COELHO	07:47
Re: [HACKERS] Custom compression methods (mac+lz4.h)	Dilip Kumar	07:50
Re: About to add WAL write/fsync statistics to pg_stat_wal view 📎	Fujii Masao	07:50
Re: PG13 fails to startup even though the current transaction is equal to the target transaction	Kyotaro Horiguchi	07:59
Re: [CLOBBER_CACHE]Server crashed with segfault 11 while executing clusterdb 📎	Amul Sul	08:25
Re: problem with RETURNING and update row movement 📎	Amit Langote	08:33
Re: [PATCH] Bug fix in initdb output	Juan José Santamaría Flecha	08:36
Re: [PATCH] Identify LWLocks in tracepoints	Peter Eisentraut	08:38
UPDATE ... SET (single_column) = row_constructor is a bit broken from V10 906bfcad7ba7c	Mahendra Singh Thalor	08:40
Re: Wrong statistics for size of XLOG_SWITCH during pg_waldump.	Kyotaro Horiguchi	08:49
Re: [PATCH] Provide more information to filter_prepare 📎	Markus Wanner	08:50
Re: [PATCH] Identify LWLocks in tracepoints	Peter Eisentraut	09:00
Re: Built-in connection pooler	Konstantin Knizhnik	09:05
Re: [PATCH] pg_stat_statements dealloc field ignores manual deallocation	Andrei Zubkov	09:06
[PATCH] Tracking statements entry timestamp in pg_stat_statements 📎	Andrei Zubkov	09:07
Re: WIP: BRIN multi-range indexes	Tomas Vondra	09:10
Re: [HACKERS] logical decoding of two-phase transactions 📎	Peter Smith	09:11
RE: [HACKERS] logical decoding of two-phase transactions	[email protected]	09:12
Re: [HACKERS] Custom compression methods	Dilip Kumar	09:18
Re: [CLOBBER_CACHE]Server crashed with segfault 11 while executing clusterdb	Amit Langote	09:32
RE: should INSERT SELECT use a BulkInsertState?	[email protected]	09:44
Re: proposal: schema variables - doc 📎	Pavel Stehule	09:47
Re: Parallel INSERT (INTO ... SELECT ...) 📎	Greg Nancarrow	10:27
Re: Columns correlation and adaptive query optimization	Yugo NAGATA	10:29
Re: About to add WAL write/fsync statistics to pg_stat_wal view 📎	ikedamsh	11:25
Re: proposal - psql - use pager for \watch command	Thomas Munro	12:13
Re: PG13 fails to startup even though the current transaction is equal to the target transaction	Sean Jezewski	12:40
RE: Support tab completion for upper character inputs in psql 📎	[email protected]	12:41
Re: [PATCH] Bug fix in initdb output	Andrew Dunstan	12:47
Re: default result formats setting 📎	Peter Eisentraut	12:50
Re: [HACKERS] logical decoding of two-phase transactions 📎	Amit Kapila	12:50
Re: proposal - psql - use pager for \watch command	Pavel Stehule	12:52
Re: New IndexAM API controlling index vacuum strategies	Masahiko Sawada	13:39
Re: Failed assertion on standby while shutdown 📎	Fujii Masao	13:40
Re: pgbench - add pseudo-random permutation function 📎	Dean Rasheed	13:43
Re: Disable WAL logging to speed up data loading	Stephen Frost	13:46
Re: New IndexAM API controlling index vacuum strategies	Robert Haas	14:05
Re: Minimal logical decoding on standbys	Fabrízio de Royes Mello	14:10
Re: PG13 fails to startup even though the current transaction is equal to the target transaction	Fujii Masao	14:37
Re: [HACKERS] Custom compression methods	Robert Haas	14:41
Re: [HACKERS] Custom compression methods (mac+lz4.h)	Tom Lane	14:41
Re: [HACKERS] Custom compression methods	Justin Pryzby	14:44
Re: Minimal logical decoding on standbys	Drouvot, Bertrand	14:57
Re: make the stats collector shutdown without writing the statsfiles if the immediate shutdown is requested.	Fujii Masao	14:59
Re: Disable WAL logging to speed up data loading	Laurenz Albe	14:59
Re: [HACKERS] Custom compression methods	Robert Haas	15:05
Re: Disable WAL logging to speed up data loading	Stephen Frost	15:05
Re: [HACKERS] Custom compression methods	Justin Pryzby	15:13
Re: [HACKERS] Custom compression methods (mac+lz4.h) 📎	Dilip Kumar	15:27
Re: [HACKERS] Custom compression methods (mac+lz4.h)	Robert Haas	15:29
Re: [HACKERS] Custom compression methods (mac+lz4.h)	Tom Lane	15:47
Re: Minimal logical decoding on standbys 📎	Drouvot, Bertrand	15:56
Re: [HACKERS] Custom compression methods (mac+lz4.h)	Robert Haas	15:59
Re: [HACKERS] Custom compression methods (mac+lz4.h)	Tom Lane	16:04
Re: [HACKERS] Custom compression methods	Robert Haas	16:16
Re: Add docs stub for recovery.conf 📎	Stephen Frost	17:02
Re: Disable WAL logging to speed up data loading	Laurenz Albe	17:09
Re: Change default of checkpoint_completion_target 📎	Stephen Frost	17:11
Re: Protect syscache from bloating with negative cache entries	Bruce Momjian	17:12
Re: Disable WAL logging to speed up data loading	Stephen Frost	17:22
Re: Proposal: Save user's original authenticated identity for logging	Magnus Hagander	17:22
Re: Wired if-statement in gen_partprune_steps_internal	Ryan Lambert	17:24
Re: [HACKERS] Custom compression methods 📎	Robert Haas	17:38
Re: Autovacuum worker doesn't immediately exit on postmaster death 📎	Stephen Frost	17:48
Re: Nicer error when connecting to standby with hot_standby=off 📎	Fujii Masao	17:49
Re: [HACKERS] Custom compression methods	Justin Pryzby	17:58
Re: Fix pg_upgrade to preserve datdba 📎	Jan Wieck	18:07
Re: [HACKERS] Custom compression methods	Tom Lane	18:10
Re: Nicer error when connecting to standby with hot_standby=off 📎	James Coleman	18:25
Re: New IndexAM API controlling index vacuum strategies	Peter Geoghegan	18:26
Re: [POC] Fast COPY FROM command for the table with foreign partitions	Andrey Lepikhov	18:33
Re: Proposal: Save user's original authenticated identity for logging	Jacob Champion	18:51
Re: Nicer error when connecting to standby with hot_standby=off	Fujii Masao	18:52
Re: Nicer error when connecting to standby with hot_standby=off	James Coleman	18:59
Re: Proposal: Save user's original authenticated identity for logging 📎	Jacob Champion	19:17
Re: shared-memory based stats collector	Andres Freund	19:33
[PATCH] rename column if exists 📎	David Oksman	19:40
Re: [HACKERS] Custom compression methods	Robert Haas	19:47
Re: Autovacuum worker doesn't immediately exit on postmaster death	Robert Haas	20:07
Re: postgres_fdw: IMPORT FOREIGN SCHEMA ... LIMIT TO (partition)	Bernd Helmle	20:16
Re: [HACKERS] Custom compression methods 📎	Robert Haas	20:33
Re: [HACKERS] Custom compression methods 📎	Robert Haas	20:57
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch 📎	Peter Eisentraut	20:58
Re: proposal - psql - use pager for \watch command	Thomas Munro	21:07
Re: UPDATE ... SET (single_column) = row_constructor is a bit broken from V10 906bfcad7ba7c	Justin Pryzby	21:13
Re: pg_upgrade failing for 200+ million Large Objects	Zhihong Yu	21:36
tool to migrate database	isabelle Ross	21:47
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? 📎	Bruce Momjian	21:55
Re: [HACKERS] Custom compression methods	Justin Pryzby	23:04
Re: shared-memory based stats collector	Andres Freund	23:17
Re: Allow an alias to be attached directly to a JOIN ... USING 📎	Tom Lane	23:18
Re: pg_upgrade failing for 200+ million Large Objects	Jan Wieck	23:18
Re: proposal - psql - use pager for \watch command 📎	Thomas Munro	23:35
Re: Support for NSS as a libpq TLS backend 📎	Daniel Gustafsson	23:38
Re: [HACKERS] logical decoding of two-phase transactions 📎	Peter Smith	23:44
Re: [HACKERS] Custom compression methods	Tom Lane	23:53

March 23, 2021

Thread	Author	Time
Re: make the stats collector shutdown without writing the statsfiles if the immediate shutdown is requested. 📎	Masahiro Ikeda	00:05
Re: shared-memory based stats collector	Andres Freund	00:15
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Zhihong Yu	00:17
Re: Key management with tests	Bruce Momjian	00:38
Re: create table like: ACCESS METHOD 📎	Justin Pryzby	00:39
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Bruce Momjian	00:43
Re: Wrong statistics for size of XLOG_SWITCH during pg_waldump.	Fujii Masao	01:01
Re: WIP: BRIN multi-range indexes 📎	Tomas Vondra	01:13
Re: Type of wait events WalReceiverWaitStart and WalSenderWaitForWAL	Fujii Masao	01:16
Handling of opckeytype / CREATE OPERATOR CLASS (bug?) 📎	Tomas Vondra	01:34
Re: New IndexAM API controlling index vacuum strategies	Masahiko Sawada	01:40
Re: PostmasterIsAlive() in recovery (non-USE_POST_MASTER_DEATH_SIGNAL builds) 📎	Fujii Masao	01:43
Re: PostmasterIsAlive() in recovery (non-USE_POST_MASTER_DEATH_SIGNAL builds)	Thomas Munro	01:52
RE: [POC] Fast COPY FROM command for the table with foreign partitions 📎	[email protected]	02:01
RE: [PATCH] Tracking statements entry timestamp in pg_stat_statements	[email protected]	02:13
Re: Handling of opckeytype / CREATE OPERATOR CLASS (bug?)	Tom Lane	02:13
Re: Key management with tests	Bruce Momjian	02:19
Re: shared-memory based stats collector	Kyotaro Horiguchi	02:20
Re: make the stats collector shutdown without writing the statsfiles if the immediate shutdown is requested.	Fujii Masao	02:40
RE: Disable WAL logging to speed up data loading	[email protected]	03:11
Re: [POC] Fast COPY FROM command for the table with foreign partitions	Zhihong Yu	03:18
Re: shared memory stats: high level design decisions: consistency, dropping	Greg Stark	03:20
Re: [POC] Fast COPY FROM command for the table with foreign partitions	Justin Pryzby	03:23
Re: New IndexAM API controlling index vacuum strategies	Peter Geoghegan	03:28
Re: Disable WAL logging to speed up data loading	Laurenz Albe	03:33
Re: New IndexAM API controlling index vacuum strategies	Peter Geoghegan	03:33
Re: New IndexAM API controlling index vacuum strategies	Peter Geoghegan	03:41
Re: Handling of opckeytype / CREATE OPERATOR CLASS (bug?)	Tomas Vondra	03:43
Re: UPDATE ... SET (single_column) = row_constructor is a bit broken from V10 906bfcad7ba7c	Mahendra Singh Thalor	03:51
Re: proposal - psql - use pager for \watch command	Pavel Stehule	04:25
Re: a verbose option for autovacuum	Michael Paquier	04:31
Re: [CLOBBER_CACHE]Server crashed with segfault 11 while executing clusterdb	Amul Sul	04:38
Re: Type of wait events WalReceiverWaitStart and WalSenderWaitForWAL	Kyotaro Horiguchi	04:50
RE: [POC] Fast COPY FROM command for the table with foreign partitions 📎	[email protected]	05:05
Re: Handling of opckeytype / CREATE OPERATOR CLASS (bug?)	Tom Lane	05:15
Re: Proposal: Save user's original authenticated identity for logging	Michael Paquier	05:21
Re: [CLOBBER_CACHE]Server crashed with segfault 11 while executing clusterdb	Neha Sharma	05:22
Re: replication cleanup code incorrect way to use of HTAB HASH_REMOVE ?	Amit Kapila	05:22
Re: Proposal: Save user's original authenticated identity for logging	Michael Paquier	05:24
Re: proposal - psql - use pager for \watch command	Pavel Stehule	05:30
Re: Change default of checkpoint_completion_target	Michael Paquier	05:31
Re: a verbose option for autovacuum	Masahiko Sawada	05:41
Re: Nicer error when connecting to standby with hot_standby=off	Fujii Masao	05:46
Re: PostmasterIsAlive() in recovery (non-USE_POST_MASTER_DEATH_SIGNAL builds)	Fujii Masao	05:49
Re: make the stats collector shutdown without writing the statsfiles if the immediate shutdown is requested. 📎	Masahiro Ikeda	05:54
Re: Replication slot stats misgivings	Amit Kapila	06:09
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Julien Rouhaud	06:31
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Julien Rouhaud	06:36
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements	Andrei Zubkov	06:50
Re: make the stats collector shutdown without writing the statsfiles if the immediate shutdown is requested.	Fujii Masao	06:50
Re: New IndexAM API controlling index vacuum strategies	Masahiko Sawada	06:53
Re: New IndexAM API controlling index vacuum strategies	Masahiko Sawada	06:54
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements	Julien Rouhaud	07:03
Re: About to add WAL write/fsync statistics to pg_stat_wal view	Fujii Masao	07:10
Re: [CLOBBER_CACHE]Server crashed with segfault 11 while executing clusterdb	Michael Paquier	07:12
Re: Is it useful to record whether plans are generic or custom? 📎	torikoshia	07:32
Re: Global snapshots 📎	Andrey V. Lepikhov	07:54
Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements	Andrei Zubkov	07:55
RE: [PATCH] Tracking statements entry timestamp in pg_stat_statements	[email protected]	08:09
Re: Get memory contexts of an arbitrary backend process	Kyotaro Horiguchi	08:24
Re: tool to migrate database	Joel Jacobson	08:49

Browse Archives

Prev | Next