pgsql-hackers since 2021-05-07 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)

Browse Archives

Prev | Next

May 7, 2021

Thread Author Time
Re: pg_upgrade not preserving comments on predefined roles Chapman Flack 00:12
Re: alter table set TABLE ACCESS METHOD Jeff Davis 00:24
Re: Replication slot stats misgivings Masahiko Sawada 00:39
Re: Anti-critical-section assertion failure in mcxt.c reached by walsender Tom Lane 01:43
Re: Anti-critical-section assertion failure in mcxt.c reached by walsender Noah Misch 02:28
Re: Replication slot stats misgivings Amit Kapila 02:33
Re: Race condition in recovery? Kyotaro Horiguchi 02:53
Re: [BUG]"FailedAssertion" reported in lazy_scan_heap() when running logical replication Andres Freund 03:18
Parallel scan with SubTransGetTopmostTransaction assert coredump Pengchengliu 03:32
Re: Anti-critical-section assertion failure in mcxt.c reached by walsender Andres Freund 03:50
Re: Parallel scan with SubTransGetTopmostTransaction assert coredump Andres Freund 03:55
Re: Anti-critical-section assertion failure in mcxt.c reached by walsender Tom Lane 04:30
Re: Anti-critical-section assertion failure in mcxt.c reached by walsender Andres Freund 04:38
Re: Anti-critical-section assertion failure in mcxt.c reached by walsender Thomas Munro 04:42
Re: Anti-critical-section assertion failure in mcxt.c reached by walsender Tom Lane 04:53
Re: Implementing Incremental View Maintenance 📎 Yugo NAGATA 05:14
doc issue missing type name "multirange" in chapter title Pavel Stehule 05:17
Re: Race condition in recovery? Dilip Kumar 05:34
Re: Identify missing publications from publisher while create/alter subscription. Japin Li 06:02
Re: Identify missing publications from publisher while create/alter subscription. Dilip Kumar 06:20
RE: [bug?] Missed parallel safety checks, and wrong parallel safety [email protected] 06:21
Re: Removing unneeded self joins 📎 Andrey Lepikhov 07:23
Re: few ideas for pgbench Pavel Stehule 07:58
Re: AlterSubscription_refresh "wrconn" wrong variable? 📎 Peter Smith 08:09
Re: Race condition in recovery? Kyotaro Horiguchi 09:03
Re: few ideas for pgbench Fabien COELHO 09:28
RE: Allow batched insert during cross-partition updates [email protected] 09:39
Re: few ideas for pgbench Pavel Stehule 09:42
Re: Race condition in recovery? Dilip Kumar 09:46
Re: [PATCH] Full support for index LP_DEAD hint bits on standby Michail Nikolaev 09:46
batch fdw insert bug (Postgres 14) Pavel Stehule 09:48
Re: Asynchronous Append on postgres_fdw nodes. Andrey Lepikhov 09:59
Re: Bogus collation version recording in recordMultipleDependencies Thomas Munro 10:01
Re: pg_receivewal makes a bad daemon Magnus Hagander 10:03
Re: pg_receivewal makes a bad daemon Magnus Hagander 10:05
Re: Asynchronous Append on postgres_fdw nodes. 📎 Andrey Lepikhov 10:32
Re: Asynchronous Append on postgres_fdw nodes. Andrey Lepikhov 10:35
Re: batch fdw insert bug (Postgres 14) Pavel Stehule 10:41
Query regarding RANGE Partitioning Nitin Jadhav 10:50
Re: Query regarding RANGE Partitioning Ashutosh Bapat 11:14
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns ahsan hadi 11:50
Re: Identify missing publications from publisher while create/alter subscription. Bharath Rupireddy 12:08
Re: Identify missing publications from publisher while create/alter subscription. Dilip Kumar 12:14
Re: Logical Replication - behavior of TRUNCATE ... CASCADE Dilip Kumar 12:35
RE: batch fdw insert bug (Postgres 14) 📎 [email protected] 12:46
Re: Query regarding RANGE Partitioning Jeevan Ladhe 12:53
Re: Yet another fast GiST build 📎 Andrey Borodin 13:05
Re: Identify missing publications from publisher while create/alter subscription. 📎 vignesh C 13:14
Re: Use simplehash.h instead of dynahash in SMgr Yura Sokolov 13:18
Re: Multi-Column List Partitioning Jeevan Ladhe 14:05
Re: Anti-critical-section assertion failure in mcxt.c reached by walsender Tom Lane 14:29
Re: Copyright on perl files Andrew Dunstan 15:15
Re: Why do we have perl and sed versions of Gen_dummy_probes? 📎 Andrew Dunstan 15:19
Re: cache lookup failed for statistics object 123 Tomas Vondra 15:19
Re: Anti-critical-section assertion failure in mcxt.c reached by walsender Andrew Dunstan 15:27
Re: Asynchronous Append on postgres_fdw nodes. Etsuro Fujita 15:55
Re: Asynchronous Append on postgres_fdw nodes. Etsuro Fujita 16:05
Inherited UPDATE/DELETE vs async execution 📎 Etsuro Fujita 16:20
Draft back-branch release notes are up Tom Lane 16:22
Parallelize correlated subqueries that execute within each worker 📎 James Coleman 16:30
[PATCH] Add configure cache checkpoints before fatal checks 📎 Joel Jacobson 16:43
Re: Draft back-branch release notes are up Matthias van de Meent 16:43
Re: Draft back-branch release notes are up Tom Lane 17:00
Re: Why do we have perl and sed versions of Gen_dummy_probes? Tom Lane 17:04
Re: Anti-critical-section assertion failure in mcxt.c reached by walsender Tom Lane 17:18
Re: Why do we have perl and sed versions of Gen_dummy_probes? Andres Freund 17:20
Re: Why do we have perl and sed versions of Gen_dummy_probes? Andres Freund 17:36
Re: Draft back-branch release notes are up Jonathan S. Katz 17:49
Re: Draft back-branch release notes are up Tom Lane 17:56
Re: [HACKERS] Comparing primary/HS standby in tests Andres Freund 18:04
Re: Processing btree walks as a batch to parallelize IO James Coleman 18:11
plan with result cache is very slow when work_mem is not enough Pavel Stehule 18:24
Re: Why do we have perl and sed versions of Gen_dummy_probes? Andrew Dunstan 18:31
Re: plan with result cache is very slow when work_mem is not enough Pavel Stehule 18:45
Re: plan with result cache is very slow when work_mem is not enough Yura Sokolov 19:06
Re: plan with result cache is very slow when work_mem is not enough Tomas Vondra 19:17
Re: plan with result cache is very slow when work_mem is not enough Pavel Stehule 19:18
Re: Draft back-branch release notes are up Alvaro Herrera 19:23
Re: Anti-critical-section assertion failure in mcxt.c reached by walsender Andrew Dunstan 19:47
Re: Anti-critical-section assertion failure in mcxt.c reached by walsender Andres Freund 19:49
Re: plan with result cache is very slow when work_mem is not enough David Rowley 19:56
Re: plan with result cache is very slow when work_mem is not enough Pavel Stehule 20:18
JSON doc example (matchiness) 📎 Erik Rijkers 20:18
Re: Draft back-branch release notes are up Tom Lane 20:25
Re: Anti-critical-section assertion failure in mcxt.c reached by walsender Tom Lane 20:30
Re: batch fdw insert bug (Postgres 14) Tomas Vondra 20:43
Re: batch fdw insert bug (Postgres 14) Pavel Stehule 20:46
Re: plan with result cache is very slow when work_mem is not enough David Rowley 21:04
Re: Binary search in ScalarArrayOpExpr for OR'd constant arrays James Coleman 21:14
Re: plan with result cache is very slow when work_mem is not enough Tomas Vondra 21:16
Re: Processing btree walks as a batch to parallelize IO Greg Stark 22:33
Re: Processing btree walks as a batch to parallelize IO Peter Geoghegan 22:56
Will Postgres12 installed on a RHEL 6 server continue to function after the server get O/S upgrade to RHEL 7? Peter Lee 23:22

May 8, 2021

Thread Author Time
Re: Anti-critical-section assertion failure in mcxt.c reached by walsender 📎 Noah Misch 00:14
Re: Binary search in ScalarArrayOpExpr for OR'd constant arrays David Rowley 00:38
Re: Binary search in ScalarArrayOpExpr for OR'd constant arrays Tom Lane 01:16
Re: Anti-critical-section assertion failure in mcxt.c reached by walsender Michael Paquier 01:33
Re: Small issues with CREATE TABLE COMPRESSION Michael Paquier 01:34
Re: Binary search in ScalarArrayOpExpr for OR'd constant arrays James Coleman 01:36
Re: Anti-critical-section assertion failure in mcxt.c reached by walsender Michael Paquier 01:38
Re: JSON doc example (matchiness) Michael Paquier 01:48
Re: Binary search in ScalarArrayOpExpr for OR'd constant arrays James Coleman 01:49
Re: Binary search in ScalarArrayOpExpr for OR'd constant arrays David Rowley 02:04
Re: Anti-critical-section assertion failure in mcxt.c reached by walsender Andres Freund 02:08
Re: Anti-critical-section assertion failure in mcxt.c reached by walsender Tom Lane 02:18
Re: Have I found an interval arithmetic bug? 📎 Bruce Momjian 02:23
Re: Have I found an interval arithmetic bug? Zhihong Yu 02:23
Re: plan with result cache is very slow when work_mem is not enough 📎 David Rowley 02:26
Re: Have I found an interval arithmetic bug? Zhihong Yu 02:39
Re: Have I found an interval arithmetic bug? Bruce Momjian 02:42
Re: plan with result cache is very slow when work_mem is not enough Justin Pryzby 02:43
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns Japin Li 03:17
Re: plan with result cache is very slow when work_mem is not enough David Rowley 03:26
Re: Anti-critical-section assertion failure in mcxt.c reached by walsender Noah Misch 03:30
Inaccurate error message when set fdw batch_size to 0 📎 [email protected] 03:38
Re: Binary search in ScalarArrayOpExpr for OR'd constant arrays 📎 David Rowley 04:50
Re: Anti-critical-section assertion failure in mcxt.c reached by walsender Thomas Munro 04:57
Re: Small issues with CREATE TABLE COMPRESSION Dilip Kumar 05:48
Re: Inaccurate error message when set fdw batch_size to 0 Dilip Kumar 05:52
RE: Enhanced error message to include hint messages for redundant options error [email protected] 06:31
Re: plan with result cache is very slow when work_mem is not enough Yura Sokolov 07:03
Re: plan with result cache is very slow when work_mem is not enough David Rowley 07:39
Re: Query regarding RANGE Partitioning Nitin Jadhav 08:19
Re: Binary search in ScalarArrayOpExpr for OR'd constant arrays Zhihong Yu 08:21
Re: Binary search in ScalarArrayOpExpr for OR'd constant arrays David Rowley 08:29
Re: Small issues with CREATE TABLE COMPRESSION Michael Paquier 08:37
Re: Multi-Column List Partitioning Nitin Jadhav 08:42
Re: Simplify backend terminate and wait logic in postgres_fdw test Michael Paquier 08:46
Re: Enhanced error message to include hint messages for redundant options error Bharath Rupireddy 08:50
Re: plan with result cache is very slow when work_mem is not enough Tomas Vondra 10:33
Re: plan with result cache is very slow when work_mem is not enough David Rowley 11:27
Re: plan with result cache is very slow when work_mem is not enough Tomas Vondra 12:07
Re: Small issues with CREATE TABLE COMPRESSION 📎 Michael Paquier 13:13
Re: Small issues with CREATE TABLE COMPRESSION Justin Pryzby 13:22
Re: Enhanced error message to include hint messages for redundant options error vignesh C 13:36
Re: Small issues with CREATE TABLE COMPRESSION Justin Pryzby 14:06
Re: Small issues with CREATE TABLE COMPRESSION Dilip Kumar 14:33
Re: Small issues with CREATE TABLE COMPRESSION 📎 Dilip Kumar 14:49
Re: [PATCH] Identify LWLocks in tracepoints Peter Eisentraut 15:04
Re: plan with result cache is very slow when work_mem is not enough Pavel Stehule 15:29
Re: JSON doc example (matchiness) Erik Rijkers 16:08
Re: [PATCH] force_parallel_mode and GUC categories Tom Lane 16:39
Re: Anti-critical-section assertion failure in mcxt.c reached by walsender Noah Misch 16:55
Re: [PATCH] Identify LWLocks in tracepoints Tom Lane 17:13
Re: plan with result cache is very slow when work_mem is not enough Tom Lane 17:21
Re: SQL/JSON: functions 📎 Andrew Dunstan 18:21
Re: SQL/JSON: JSON_TABLE 📎 Andrew Dunstan 18:23
Re: [BUG] Logical replication failure "ERROR: could not map filenode "base/13237/442428" to relation OID" with catalog modifying txns Ahsan Hadi 18:51
Reducing opr_sanity test's runtime under CLOBBER_CACHE_ALWAYS 📎 Tom Lane 19:44
Re: Will Postgres12 installed on a RHEL 6 server continue to function after the server get O/S upgrade to RHEL 7? Tom Lane 19:52
2021-05-13 release announcement draft 📎 Jonathan S. Katz 21:53
Re: Will Postgres12 installed on a RHEL 6 server continue to function after the server get O/S upgrade to RHEL 7? Peter Lee 23:35
Re: plan with result cache is very slow when work_mem is not enough David Rowley 23:45
Re: SQL/JSON: functions Zhihong Yu 23:54

May 9, 2021

Thread Author Time
Re: plan with result cache is very slow when work_mem is not enough David Rowley 01:01
Re: JSON doc example (matchiness) 📎 Alexander Korotkov 01:01
Re: plan with result cache is very slow when work_mem is not enough Pavel Stehule 04:07
Re: [Patch] ALTER SYSTEM READ ONLY Amul Sul 05:26
Re: 2021-05-13 release announcement draft Noah Misch 07:47
seawasp failing, maybe in glibc allocator Thomas Munro 09:23
Corrected documentation of data type for the logical replication message formats. 📎 vignesh C 12:37
Re: Enhanced error message to include hint messages for redundant options error Bharath Rupireddy 12:39
Re: plan with result cache is very slow when work_mem is not enough Yura Sokolov 12:57
Re: Corrected documentation of data type for the logical replication message formats. Peter Smith 13:13
Re: Corrected documentation of data type for the logical replication message formats. Euler Taveira 13:23
Re: COPY table_name (single_column) FROM 'unknown.txt' DELIMITER E'\n' Daniel Verite 13:39
Re: Reducing opr_sanity test's runtime under CLOBBER_CACHE_ALWAYS Julien Rouhaud 13:53
Re: Reducing opr_sanity test's runtime under CLOBBER_CACHE_ALWAYS Andrew Dunstan 14:30
Re: Reducing opr_sanity test's runtime under CLOBBER_CACHE_ALWAYS Tom Lane 17:01
Re: [PATCH] Identify LWLocks in tracepoints Andres Freund 18:55
Re: plan with result cache is very slow when work_mem is not enough Andres Freund 19:04
Non-reproducible valgrind failure on HEAD 📎 Tom Lane 19:29
Re: JSON doc example (matchiness) Alexander Korotkov 20:17
Re: Non-reproducible valgrind failure on HEAD Andres Freund 21:02
Re: Non-reproducible valgrind failure on HEAD Tom Lane 21:12
Re: Non-reproducible valgrind failure on HEAD Andres Freund 21:17
Re: Non-reproducible valgrind failure on HEAD 📎 Tom Lane 22:17
Is template1 intended to have oid 1 ? Chapman Flack 22:35
Re: Non-reproducible valgrind failure on HEAD Andres Freund 22:40
Re: Is template1 intended to have oid 1 ? Tom Lane 22:40
Re: Is template1 intended to have oid 1 ? Chapman Flack 23:01
Re: Non-reproducible valgrind failure on HEAD Tom Lane 23:36
Re: [PATCH] Identify LWLocks in tracepoints Tom Lane 23:51

May 10, 2021

Thread Author Time
Re: Inherited UPDATE/DELETE vs async execution Justin Pryzby 00:20
RE: Enhanced error message to include hint messages for redundant options error [email protected] 00:30
Re: Small issues with CREATE TABLE COMPRESSION Michael Paquier 00:36
Re: JSON doc example (matchiness) Michael Paquier 00:41
RE: batch fdw insert bug (Postgres 14) [email protected] 01:19
RE: Inaccurate error message when set fdw batch_size to 0 [email protected] 01:26
Re: Corrected documentation of data type for the logical replication message formats. Peter Smith 01:41
Re: AlterSubscription_refresh "wrconn" wrong variable? Peter Smith 02:20
Re: Inherited UPDATE/DELETE vs async execution Etsuro Fujita 02:20
Re: Asynchronous Append on postgres_fdw nodes. 📎 Etsuro Fujita 03:03
Re: [HACKERS] logical decoding of two-phase transactions vignesh C 03:31
Re: AlterSubscription_refresh "wrconn" wrong variable? Bharath Rupireddy 03:53
Re: WIP: WAL prefetch (another approach) Thomas Munro 04:11
Re: Reducing opr_sanity test's runtime under CLOBBER_CACHE_ALWAYS Julien Rouhaud 05:14
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith 05:21
Remove "FROM" in "DELETE FROM" when using tab-completion 📎 [email protected] 05:36
Re: Remove "FROM" in "DELETE FROM" when using tab-completion Julien Rouhaud 05:48

Browse Archives

Prev | Next