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

Thread	Author	Time
Parallel INSERT SELECT take 2	[email protected]	01:21
Re: Table refer leak in logical replication	Amit Langote	01:29
回复：Bug on update timing of walrcv->flushedUpto variable	蔡梦娟 (玊于)	02:01
Re: Have I found an interval arithmetic bug?	Zhihong Yu	02:33
Re: psql - add SHOW_ALL_RESULTS option	Michael Paquier	03:10
Re: Replication slot stats misgivings	vignesh C	03:41
Re: psql - add SHOW_ALL_RESULTS option	Tom Lane	03:44
Re: Set access strategy for parallel vacuum workers	Amit Kapila	04:11
Re: psql - add SHOW_ALL_RESULTS option	Michael Paquier	04:19
RE: Truncate in synchronous logical replication failed	[email protected]	04:33
Re: Replication slot stats misgivings 📎	Masahiko Sawada	04:56
Re: [PATCH] force_parallel_mode and GUC categories	Michael Paquier	05:01
Re: Uninitialized scalar variable (UNINIT) (src/backend/statistics/extended_stats.c)	Michael Paquier	05:07
Re: pgsql: Move tablespace path re-creation from the makefiles to pg_regres	Michael Paquier	05:25
Re: [PATCH] force_parallel_mode and GUC categories	Bharath Rupireddy	05:28
Re: [PATCH] force_parallel_mode and GUC categories	Tom Lane	05:40
Re: [PATCH] Identify LWLocks in tracepoints	Craig Ringer	05:46
Re: Simplify backend terminate and wait logic in postgres_fdw test	Michael Paquier	05:48
Re: Simplify backend terminate and wait logic in postgres_fdw test 📎	Bharath Rupireddy	05:59
Re: Uninitialized scalar variable (UNINIT) (src/backend/statistics/extended_stats.c)	Tom Lane	06:04
Problems around compute_query_id	Michael Paquier	06:12
Re: Performance degradation of REFRESH MATERIALIZED VIEW 📎	Masahiko Sawada	06:20
Re: [PATCH] Identify LWLocks in tracepoints	Craig Ringer	06:31
Re: missing documentation for streaming in-progress transactions	Amit Kapila	06:32
Re: Problems around compute_query_id	Julien Rouhaud	06:56
Re: Truncate in synchronous logical replication failed	Amit Kapila	06:58
Re: Problems around compute_query_id	Michael Banck	07:20
Re: Problems around compute_query_id	Julien Rouhaud	07:26
Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY	Amit Langote	07:42
Re: Wired if-statement in gen_partprune_steps_internal 📎	Andy Fan	07:58
Re: pgsql: Move tablespace path re-creation from the makefiles to pg_regres	Christoph Berg	08:09
vacuum freeze - possible improvements	Virender Singla	08:19
Re: Problems around compute_query_id	Julien Rouhaud	08:43
Re: Replication slot stats misgivings	Amit Kapila	09:19
Re: Replication slot stats misgivings 📎	vignesh C	09:27
RE: Could you help testing logical replication?	[email protected]	10:50
RE: Could you help testing logical replication?	[email protected]	10:55
Re: Replication slot stats misgivings	Masahiko Sawada	11:04
Re: Replication slot stats misgivings	Amit Kapila	11:08
Re: Replication slot stats misgivings	vignesh C	11:15
Re: Replication slot stats misgivings	Amit Kapila	11:16
Re: TRUNCATE on foreign table	Fujii Masao	11:31
撤回: Could you help testing logical replication?	[email protected]	11:40
撤回: Could you help testing logical replication?	[email protected]	11:48
Re: Replication slot stats misgivings	Masahiko Sawada	11:58
Re: allow partial union-all and improve parallel subquery costing 📎	Luc Vlaming	12:01
Re: Lazy JIT IR code generation to increase JIT speed with partitions 📎	Luc Vlaming	12:11
Re: Replication slot stats misgivings 📎	vignesh C	12:16
"could not find pathkey item to sort" for TPC-DS queries 94-96	Luc Vlaming	12:24
interaction between csps with dummy tlists and set_customscan_references	Luc Vlaming	12:31
Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY 📎	Amit Langote	12:32
Re: TRUNCATE on foreign table	Fujii Masao	12:36
Re: Replication slot stats misgivings	Amit Kapila	12:36
Re: "could not find pathkey item to sort" for TPC-DS queries 94-96	Tomas Vondra	12:36
Re: multi-install PostgresNode fails with older postgres versions 📎	Jehan-Guillaume de Rorthais	12:59
pg_upgrade check for invalid role-specific default config	Charlie Hornsby	13:28
Re: Replication slot stats misgivings	Masahiko Sawada	13:33
Re: multi-install PostgresNode fails with older postgres versions	Andrew Dunstan	13:52
[GSoC 2021 proposal] pl/julia extension 📎	Konstantina Skovola	13:56
Re: [Patch] ALTER SYSTEM READ ONLY 📎	Amul Sul	14:04
Re: psql - add SHOW_ALL_RESULTS option	Fabien COELHO	14:25
Re: multi-install PostgresNode fails with older postgres versions	Jehan-Guillaume de Rorthais	14:57
Contribution to PostgreSQL - please give an advice	Ian Zagorskikh	15:21
Re: SQL/JSON: JSON_TABLE	Erik Rijkers	15:34
Core dump happens when execute sql CREATE VIEW v1(c1) AS (SELECT ('4' COLLATE "C")::INT FROM generate_series(1, 10));	Yulin PEI	15:39
Re: Replication slot stats misgivings	vignesh C	16:09
Re: Contribution to PostgreSQL - please give an advice	Pavel Stehule	16:11
Re: Have I found an interval arithmetic bug?	Bruce Momjian	16:18
Re: PANIC: wrong buffer passed to visibilitymap_clear 📎	Tom Lane	16:19
Re: psql - add SHOW_ALL_RESULTS option	Tom Lane	16:23
Re: Contribution to PostgreSQL - please give an advice	Justin Pryzby	16:38
Re: Uninitialized scalar variable (UNINIT) (src/backend/statistics/extended_stats.c)	Ranier Vilela	16:55
Re: Core dump happens when execute sql CREATE VIEW v1(c1) AS (SELECT ('4' COLLATE "C")::INT FROM generate_series(1, 10)); 📎	Tom Lane	16:59
Re: Uninitialized scalar variable (UNINIT) (src/backend/statistics/extended_stats.c)	Tomas Vondra	17:03
Re: Uninitialized scalar variable (UNINIT) (src/backend/statistics/extended_stats.c)	Tom Lane	17:04
Re: Uninitialized scalar variable (UNINIT) (src/backend/statistics/extended_stats.c)	Justin Pryzby	17:05
Proposal for working on open source with PostgreSQL	Nandni Mehla	17:56
Re: PANIC: wrong buffer passed to visibilitymap_clear	Peter Geoghegan	18:03
Re: [PATCH] Identify LWLocks in tracepoints	Andres Freund	18:23
Re: psql - add SHOW_ALL_RESULTS option	Bossart, Nathan	19:08
Re: Proposal for working on open source with PostgreSQL	Laurenz Albe	19:08
Re: psql - add SHOW_ALL_RESULTS option	Alvaro Herrera	19:33
Re: Proposal for working on open source with PostgreSQL	Alvaro Herrera	19:36
Allowing to create LEAKPROOF functions to non-superuser	Andrey Borodin	20:31
Re: Allowing to create LEAKPROOF functions to non-superuser	Tom Lane	20:37
Re: PANIC: wrong buffer passed to visibilitymap_clear	Andres Freund	20:40
Re: Allowing to create LEAKPROOF functions to non-superuser	Tomas Vondra	20:42
Re: Allowing to create LEAKPROOF functions to non-superuser	Andrey Borodin	20:51
Re: Allowing to create LEAKPROOF functions to non-superuser	Andres Freund	20:51
Re: Allowing to create LEAKPROOF functions to non-superuser	Andres Freund	20:54
Curious test case added by collation version tracking patch	Tom Lane	20:59
Re: Allowing to create LEAKPROOF functions to non-superuser	Andrey Borodin	20:59
Re: Allowing to create LEAKPROOF functions to non-superuser	Andres Freund	21:01
Re: Allowing to create LEAKPROOF functions to non-superuser	Andrey Borodin	21:10
Re: Allowing to create LEAKPROOF functions to non-superuser	Tom Lane	21:14
Re: pg_upgrade check for invalid role-specific default config	Bruce Momjian	21:16
Re: pg_upgrade check for invalid role-specific default config	Tom Lane	21:29
Re: Allowing to create LEAKPROOF functions to non-superuser	Andres Freund	21:35
Re: pg_upgrade check for invalid role-specific default config	Tom Lane	21:46
Re: Curious test case added by collation version tracking patch	Thomas Munro	22:08
Re: Have I found an interval arithmetic bug?	Bryn Llewellyn	22:09
Re: Curious test case added by collation version tracking patch	Tom Lane	22:47
Teaching users how they can get the most out of HOT in Postgres 14	Peter Geoghegan	23:11
Re: Have I found an interval arithmetic bug?	Bruce Momjian	23:22
Re: Binary search in ScalarArrayOpExpr for OR'd constant arrays 📎	David Rowley	23:23
Re: Teaching users how they can get the most out of HOT in Postgres 14	Andres Freund	23:30
Re: psql - add SHOW_ALL_RESULTS option	Michael Paquier	23:31
Re: pg_upgrade check for invalid role-specific default config 📎	Tom Lane	23:33
Re: Teaching users how they can get the most out of HOT in Postgres 14	Peter Geoghegan	23:35
Re: Binary search in ScalarArrayOpExpr for OR'd constant arrays	David Rowley	23:35
Re: Have I found an interval arithmetic bug?	Tom Lane	23:38
Re: Binary search in ScalarArrayOpExpr for OR'd constant arrays	Tom Lane	23:42
Re: Binary search in ScalarArrayOpExpr for OR'd constant arrays	David Rowley	23:49
Re: Teaching users how they can get the most out of HOT in Postgres 14	Michael Paquier	23:52
Re: Teaching users how they can get the most out of HOT in Postgres 14	Peter Geoghegan	23:53

April 13, 2021

Thread	Author	Time
Re: Have I found an interval arithmetic bug?	Bruce Momjian	00:00
Re: Have I found an interval arithmetic bug?	Bryn Llewellyn	00:06
Re: Have I found an interval arithmetic bug?	Bryn Llewellyn	00:20
Re: Have I found an interval arithmetic bug?	Bruce Momjian	00:25
Re: wal stats questions	Fujii Masao	00:33
Re: Teaching users how they can get the most out of HOT in Postgres 14	Andres Freund	00:37
Re: TRUNCATE on foreign table 📎	Justin Pryzby	00:57
Re: Possible SSI bug in heap_update	Thomas Munro	01:05
Re: Teaching users how they can get the most out of HOT in Postgres 14	Peter Geoghegan	01:12
Re: TRUNCATE on foreign table	Bharath Rupireddy	01:21
Re: PANIC: wrong buffer passed to visibilitymap_clear	Tom Lane	01:33
Re: PANIC: wrong buffer passed to visibilitymap_clear	Peter Geoghegan	01:54
Re: Binary search in ScalarArrayOpExpr for OR'd constant arrays	James Coleman	02:07
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? 📎	Bruce Momjian	02:12
Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY	Amit Langote	02:13
Re: vacuum freeze - possible improvements	Masahiko Sawada	02:22
RE: WIP: WAL prefetch (another approach) 📎	Shinoda, Noriyoshi (PN Japan FSIP)	02:33
Re: [PATCH] Identify LWLocks in tracepoints	Craig Ringer	02:34
Re: pg_stat_bgwriter.buffers_backend is pretty meaningless (and more?) 📎	Melanie Plageman	02:49
Re: [HACKERS] logical decoding of two-phase transactions 📎	Peter Smith	02:56
Re: pg_amcheck contrib application 📎	Mark Dilger	03:06
Re: [PATCH] Identify LWLocks in tracepoints	Andres Freund	03:06
Re: TRUNCATE on foreign table	Fujii Masao	03:38
Re: TRUNCATE on foreign table	Justin Pryzby	03:46
PG Docs - logical decoding output plugins - fix typo 📎	Peter Smith	04:23
Re: doc review for v14 📎	Justin Pryzby	04:39
Re: vacuum freeze - possible improvements	Virender Singla	04:51
Re: Replication slot stats misgivings	Masahiko Sawada	05:15
Re: TRUNCATE on foreign table	Kohei KaiGai	05:22
Re: PG Docs - logical decoding output plugins - fix typo	Fujii Masao	05:23
Re: pgsql: Move tablespace path re-creation from the makefiles to pg_regres	Noah Misch	05:36
Re: Extensions not dumped when --schema is used	Michael Paquier	05:43
Retry in pgbench	Tatsuo Ishii	05:51
Re: New IndexAM API controlling index vacuum strategies	Masahiko Sawada	06:05
Re: Contribution to PostgreSQL - please give an advice	Ian Zagorskikh	06:35
Re: TRUNCATE on foreign table	Fujii Masao	06:44
Re: Retry in pgbench	Thomas Munro	07:02
Re: Retry in pgbench	Tatsuo Ishii	07:12
Re: TRUNCATE on foreign table	Fujii Masao	07:17
Re: pgsql: Move tablespace path re-creation from the makefiles to pg_regres	Michael Paquier	07:26
Re: [PATCH] force_parallel_mode and GUC categories	Michael Paquier	07:34
Unresolved repliaction hang and stop problem.	Krzysztof Kois	07:36
Re: Simplify backend terminate and wait logic in postgres_fdw test	Michael Paquier	07:39
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Julien Rouhaud	08:06
Re: Replication slot stats misgivings 📎	vignesh C	08:06
回复: Core dump happens when execute sql CREATE VIEW v1(c1) AS (SELECT ('4' COLLATE "C")::INT FROM generate_series(1, 10));	Yulin PEI	08:27
Re: TRUNCATE on foreign table	Kyotaro Horiguchi	08:29
Re: TRUNCATE on foreign table	Kohei KaiGai	09:07
回复: Core dump happens when execute sql CREATE VIEW v1(c1) AS (SELECT ('4' COLLATE "C")::INT FROM generate_series(1, 10)); 📎	Yulin PEI	09:27
Performance Evaluation of Result Cache by using TPC-DS 📎	Yuya Watari	09:29
Re: Performance Evaluation of Result Cache by using TPC-DS	David Rowley	10:13
Re: Old Postgresql version on i7-1165g7	Yura Sokolov	10:20
Re: vacuum freeze - possible improvements	David Rowley	11:05
Re: Old Postgresql version on i7-1165g7	Justin Pryzby	11:58
Re: TRUNCATE on foreign table	Bharath Rupireddy	12:03
Re: [PATCH] force_parallel_mode and GUC categories 📎	Justin Pryzby	12:31
Re: vacuum freeze - possible improvements	Masahiko Sawada	12:32
Monitoring stats docs inconsistency 📎	vignesh C	12:38
Re: Identify missing publications from publisher while create/alter subscription. 📎	vignesh C	12:52
Re: [PATCH] Identify LWLocks in tracepoints	Craig Ringer	13:05
CTE push down	Alexander Pyhalov	13:28
potential deadlock in parallel hashjoin grow-buckets-barrier and blocking nodes?	Luc Vlaming	13:34
Re: [PATCH] Identify LWLocks in tracepoints 📎	Craig Ringer	13:40
Re: vacuum freeze - possible improvements	Virender Singla	13:49
RE: Truncate in synchronous logical replication failed	[email protected]	13:54
Re: Have I found an interval arithmetic bug?	Zhihong Yu	14:07
Re: [PATCH] force_parallel_mode and GUC categories	Tom Lane	14:12
Re: TRUNCATE on foreign table	Kohei KaiGai	14:25
Re: Identify missing publications from publisher while create/alter subscription.	Bharath Rupireddy	14:31
More sepgsql weirdness	Dave Page	14:33
Re: Truncate in synchronous logical replication failed	Petr Jelinek	14:37
Re: Old Postgresql version on i7-1165g7	Tom Lane	14:45
Re: [PATCH] Identify LWLocks in tracepoints	Craig Ringer	14:48
Re: TRUNCATE on foreign table	Fujii Masao	15:00
Re: Extensions not dumped when --schema is used	Noah Misch	15:00
Re: Proposal: Save user's original authenticated identity for logging	Jacob Champion	15:47
Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY	Alvaro Herrera	16:10
pgsql: Avoid improbable PANIC during heap_update.	Tom Lane	16:17
Proposal for working open source with PostgreSQL	Nandni Mehla	16:31
Re: More sepgsql weirdness	Robert Haas	17:21
Re: pg_upgrade check for invalid role-specific default config	Charlie Hornsby	17:28
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Alvaro Herrera	17:30
Re: Binary search in ScalarArrayOpExpr for OR'd constant arrays 📎	James Coleman	17:40
Re: Have I found an interval arithmetic bug?	Bryn Llewellyn	17:55
Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY	Justin Pryzby	17:58

Browse Archives

Prev | Next