pgsql-hackers - May 2021

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 1, 2021

Thread Author Time
Re: Granting control of SUSET gucs to non-superusers Chapman Flack 00:02
Re: Granting control of SUSET gucs to non-superusers Tom Lane 00:13
Re: Transactions involving multiple postgres foreign servers, take 2 Masahiko Sawada 00:22
Re: RFE: Make statistics robust for unplanned events Peter Geoghegan 00:23
Re: Granting control of SUSET gucs to non-superusers Mark Dilger 02:00
Re: Granting control of SUSET gucs to non-superusers Isaac Morland 03:27
Re: Transactions involving multiple postgres foreign servers, take 2 Masahiko Sawada 04:09
New assertion failed in lazy_scan_heap() on mereswine Thomas Munro 04:43
Re: New assertion failed in lazy_scan_heap() on mereswine Dilip Kumar 05:11
Re: New assertion failed in lazy_scan_heap() on mereswine Justin Pryzby 05:11
Re: Log enhancement for aclcheck permissions failures Bharath Rupireddy 05:12
Re: Enhanced error message to include hint messages for redundant options error Bharath Rupireddy 05:12
Re: Enhanced error message to include hint messages for redundant options error Dilip Kumar 05:17
Re: function for testing that causes the backend to terminate Bharath Rupireddy 05:58
Re: Identify missing publications from publisher while create/alter subscription. 📎 vignesh C 07:19
Hook for extensible parsing. 📎 Julien Rouhaud 07:24
Re: Incorrect snapshots while promoting hot standby node when 2PC is used Andrey Borodin 12:35
Re: Enhanced error message to include hint messages for redundant options error 📎 vignesh C 13:55
Re: Enhanced error message to include hint messages for redundant options error vignesh C 13:56
Re: Granting control of SUSET gucs to non-superusers Chapman Flack 14:07
Re: Identify missing publications from publisher while create/alter subscription. Bharath Rupireddy 14:28
Re: Dump public schema ownership & seclabels Asif Rehman 15:15
Re: Enhanced error message to include hint messages for redundant options error Bharath Rupireddy 15:31
Re: function for testing that causes the backend to terminate Andrew Dunstan 15:56
Re: Granting control of SUSET gucs to non-superusers Mark Dilger 16:13
Re: Transactions involving multiple postgres foreign servers, take 2 Zhihong Yu 16:27
Re: Granting control of SUSET gucs to non-superusers Chapman Flack 16:37
Re: Dump public schema ownership & seclabels Zhihong Yu 16:43
Re: [PATCH] Identify LWLocks in tracepoints Dmitry Dolgov 16:58
Re: Enhanced error message to include hint messages for redundant options error Alvaro Herrera 17:24
Re: Enhanced error message to include hint messages for redundant options error Bharath Rupireddy 17:55
Regex performance regression induced by match-all code 📎 Tom Lane 19:46
Re: Re: Perform COPY FROM encoding conversions in larger chunks Chapman Flack 20:06
Re: performance benchmark Yu Zhao 20:27
Re: Granting control of SUSET gucs to non-superusers Michael Banck 21:31
Re: Enhanced error message to include hint messages for redundant options error Alvaro Herrera 22:57

May 2, 2021

Thread Author Time
Re: WIP: WAL prefetch (another approach) Tom Lane 03:16
Re: Some oversights in query_id calculation Julien Rouhaud 04:27
Re: Regex performance regression induced by match-all code Joel Jacobson 05:46
Re: Enhanced error message to include hint messages for redundant options error vignesh C 10:30
Re: Enhanced error message to include hint messages for redundant options error Julien Rouhaud 11:42
Re: Enhanced error message to include hint messages for redundant options error 📎 vignesh C 15:12
Re: Enhanced error message to include hint messages for redundant options error vignesh C 15:14
Re: Clarify how triggers relate to transactions Euler Taveira 15:45
Re: Identify missing publications from publisher while create/alter subscription. 📎 vignesh C 16:34
Re: Regex performance regression induced by match-all code 📎 Tom Lane 16:53
Re: websearch_to_tsquery() returns queries that don't match to_tsvector() 📎 Alexander Korotkov 17:45
Re: websearch_to_tsquery() returns queries that don't match to_tsvector() Tom Lane 17:52
Re: websearch_to_tsquery() returns queries that don't match to_tsvector() 📎 Alexander Korotkov 17:57
Re: websearch_to_tsquery() returns queries that don't match to_tsvector() Tom Lane 18:04
Re: websearch_to_tsquery() returns queries that don't match to_tsvector() Zhihong Yu 18:09
Re: websearch_to_tsquery() returns queries that don't match to_tsvector() 📎 Alexander Korotkov 18:12
Re: websearch_to_tsquery() returns queries that don't match to_tsvector() Alexander Korotkov 18:12
Re: websearch_to_tsquery() returns queries that don't match to_tsvector() 📎 Alexander Korotkov 18:19
Re: websearch_to_tsquery() returns queries that don't match to_tsvector() Zhihong Yu 18:21
Re: websearch_to_tsquery() returns queries that don't match to_tsvector() Tom Lane 18:37
Re: websearch_to_tsquery() returns queries that don't match to_tsvector() Alexander Korotkov 18:41
pg_upgrade not preserving comments on predefined roles Chapman Flack 19:52
Re: pg_upgrade not preserving comments on predefined roles Tom Lane 23:25

May 3, 2021

Thread Author Time
Re: WIP: WAL prefetch (another approach) Thomas Munro 01:23
Re: Remove redundant variable from transformCreateStmt Amul Sul 03:56
Logical Replication - behavior of TRUNCATE ... CASCADE Bharath Rupireddy 05:12
Re: Identify missing publications from publisher while create/alter subscription. Dilip Kumar 05:18
Re: Replication slot stats misgivings Amit Kapila 05:26
Re: Replication slot stats misgivings Amit Kapila 05:29
Re: Identify missing publications from publisher while create/alter subscription. Bharath Rupireddy 05:41
Re: WIP: WAL prefetch (another approach) Thomas Munro 05:42
Re: Dump public schema ownership & seclabels 📎 Noah Misch 05:57
Re: Logical Replication - behavior of TRUNCATE ... CASCADE Dilip Kumar 06:29
Re: Enhanced error message to include hint messages for redundant options error Bharath Rupireddy 06:38
Re: Logical Replication - behavior of TRUNCATE ... CASCADE Bharath Rupireddy 07:07
Re: Logical Replication - behavior of TRUNCATE ... CASCADE Dilip Kumar 07:31
Re: Enhanced error message to include hint messages for redundant options error Dilip Kumar 08:11
Re: Identify missing publications from publisher while create/alter subscription. Dilip Kumar 08:15
how to correctly cast json value to text? Pavel Stehule 09:15
Re: how to correctly cast json value to text? Pavel Stehule 09:23
Re: how to correctly cast json value to text? Marko Tiikkaja 09:25
Re: how to correctly cast json value to text? Pavel Stehule 09:35
Re: strange error reporting Peter Eisentraut 10:08
Re: Replication slot stats misgivings Masahiko Sawada 12:18
Re: Replication slot stats misgivings Masahiko Sawada 12:18
Re: Transactions involving multiple postgres foreign servers, take 2 Masahiko Sawada 12:24
Re: Logical Replication - behavior of TRUNCATE ... CASCADE Bharath Rupireddy 12:38
Toast compression method options 📎 Dilip Kumar 12:57
Re: Enhanced error message to include hint messages for redundant options error vignesh C 13:11
Re: [PATCH] Allow CustomScan nodes to signal projection support 📎 Aleksander Alekseev 13:18
Re: Replication slot stats misgivings Amit Kapila 13:20
Re: Transactions involving multiple postgres foreign servers, take 2 Zhihong Yu 14:15
Re: strange error reporting Robert Haas 14:21
Re: Lowering the ever-growing heap->pd_lower John Naylor 14:26
Re: Identify missing publications from publisher while create/alter subscription. 📎 vignesh C 14:28
Re: Identify missing publications from publisher while create/alter subscription. vignesh C 14:29
Re: Lowering the ever-growing heap->pd_lower Matthias van de Meent 14:39
Re: MaxOffsetNumber for Table AMs Robert Haas 14:41
Re: strange error reporting Tom Lane 14:47
Re: MaxOffsetNumber for Table AMs Robert Haas 15:03
Re: Granting control of SUSET gucs to non-superusers Robert Haas 15:22
Re: MaxOffsetNumber for Table AMs Peter Geoghegan 15:26
Re: Granting control of SUSET gucs to non-superusers Chapman Flack 15:44
Re: MaxOffsetNumber for Table AMs Peter Geoghegan 15:48
Re: Granting control of SUSET gucs to non-superusers Mark Dilger 16:25
Re: pg_amcheck contrib application Robert Haas 16:34
Re: MaxOffsetNumber for Table AMs Robert Haas 16:45
Update maintenance_work_mem/autovacuum_work_mem to reflect the 1GB limitation with VACUUM Martín Marqués 16:48
Re: MaxOffsetNumber for Table AMs Peter Geoghegan 16:59
Re: MaxOffsetNumber for Table AMs Robert Haas 17:22
Re: MaxOffsetNumber for Table AMs Matthias van de Meent 17:22
Re: Granting control of SUSET gucs to non-superusers Robert Haas 17:23
Re: Granting control of SUSET gucs to non-superusers Robert Haas 17:33
Re: MaxOffsetNumber for Table AMs Peter Geoghegan 17:38
Re: Granting control of SUSET gucs to non-superusers Chapman Flack 17:43
Re: function for testing that causes the backend to terminate Dave Cramer 17:51
Re: MaxOffsetNumber for Table AMs Jeff Davis 17:57
Re: MaxOffsetNumber for Table AMs Peter Geoghegan 18:05
Re: Incorrect snapshots while promoting hot standby node when 2PC is used Andres Freund 18:10
Re: MaxOffsetNumber for Table AMs Jeff Davis 18:13
Re: MaxOffsetNumber for Table AMs Jeff Davis 18:36
Re: Granting control of SUSET gucs to non-superusers Stephen Frost 18:41
Re: MaxOffsetNumber for Table AMs Peter Geoghegan 18:43
Re: Granting control of SUSET gucs to non-superusers Tom Lane 18:48
Re: Granting control of SUSET gucs to non-superusers Robert Haas 18:50
Re: Some oversights in query_id calculation Bruce Momjian 18:59
Re: Granting control of SUSET gucs to non-superusers Robert Haas 19:01
Re: MaxOffsetNumber for Table AMs Matthias van de Meent 19:06
Re: [PATCH] Identify LWLocks in tracepoints Peter Eisentraut 19:06
PG in container w/ pid namespace is init, process exits cause restart Andres Freund 19:07
Re: Granting control of SUSET gucs to non-superusers Stephen Frost 19:12
Re: PG in container w/ pid namespace is init, process exits cause restart Alvaro Herrera 19:25
Re: Regex performance regression induced by match-all code Joel Jacobson 19:31
Re: PG in container w/ pid namespace is init, process exits cause restart Tom Lane 19:37
Re: Regex performance regression induced by match-all code Tom Lane 19:38
Re: Regex performance regression induced by match-all code Joel Jacobson 19:43
Re: PG in container w/ pid namespace is init, process exits cause restart Tom Lane 19:43
Re: MaxOffsetNumber for Table AMs Peter Geoghegan 19:45
Re: PG in container w/ pid namespace is init, process exits cause restart Alvaro Herrera 19:53
Re: PG in container w/ pid namespace is init, process exits cause restart Andres Freund 20:12
Re: PG in container w/ pid namespace is init, process exits cause restart Tom Lane 20:20
Re: PG in container w/ pid namespace is init, process exits cause restart Andres Freund 20:23
Re: PG in container w/ pid namespace is init, process exits cause restart Alvaro Herrera 20:28
Re: PG in container w/ pid namespace is init, process exits cause restart Andrew Dunstan 20:32
Re: PG in container w/ pid namespace is init, process exits cause restart Andres Freund 20:35
.ready and .done files considered harmful Robert Haas 20:49
Re: MaxOffsetNumber for Table AMs Jeff Davis 21:03
Re: PG in container w/ pid namespace is init, process exits cause restart Dagfinn Ilmari Mannsåker 21:13
Re: PG in container w/ pid namespace is init, process exits cause restart Tom Lane 21:13
Re: Avoiding smgrimmedsync() during nbtree index builds 📎 Melanie Plageman 21:24
Re: MaxOffsetNumber for Table AMs Peter Geoghegan 22:07
Re: Simplify backend terminate and wait logic in postgres_fdw test Tom Lane 22:42
Re: Performance Evaluation of Result Cache by using TPC-DS David Rowley 23:02
AlterSubscription_refresh "wrconn" wrong variable? 📎 Peter Smith 23:29

May 4, 2021

Thread Author Time
Re: MaxOffsetNumber for Table AMs Jeff Davis 00:15
Re: MaxOffsetNumber for Table AMs Peter Geoghegan 01:12
Re: MaxOffsetNumber for Table AMs Jeff Davis 03:01
Re: AlterSubscription_refresh "wrconn" wrong variable? Bharath Rupireddy 03:56
Re: Replication slot stats misgivings 📎 Masahiko Sawada 04:18
Re: .ready and .done files considered harmful Andres Freund 04:27
Re: AlterSubscription_refresh "wrconn" wrong variable? Andres Freund 04:31
Re: MaxOffsetNumber for Table AMs Andres Freund 05:01
Re: AlterSubscription_refresh "wrconn" wrong variable? Peter Smith 05:08
Re: AlterSubscription_refresh "wrconn" wrong variable? Peter Smith 05:13
Re: Replication slot stats misgivings vignesh C 05:34
Re: Incorrect snapshots while promoting hot standby node when 2PC is used Andrey Borodin 06:58
Re: Simplify backend terminate and wait logic in postgres_fdw test 📎 Bharath Rupireddy 07:13
Re: Enhanced error message to include hint messages for redundant options error Bharath Rupireddy 07:19
Re: .ready and .done files considered harmful Andrey Borodin 08:07
Re: pg_upgrade can result in early wraparound on databases with high transaction load 📎 Drouvot, Bertrand 08:17
Re: Simplify backend terminate and wait logic in postgres_fdw test Michael Paquier 08:22
few ideas for pgbench Pavel Stehule 08:23
Re: Identify missing publications from publisher while create/alter subscription. Bharath Rupireddy 09:07
Patch to avoid orphaned dependencies 📎 Drouvot, Bertrand 09:55
Re: Dumping/restoring fails on inherited generated column Peter Eisentraut 10:27
Re: A test for replay of regression tests 📎 Thomas Munro 11:12
Re: Race condition in recovery? 📎 Dilip Kumar 12:11
Re: WIP: WAL prefetch (another approach) Tomas Vondra 12:37
Re: Identify missing publications from publisher while create/alter subscription. 📎 vignesh C 13:20
Re: Unresolved repliaction hang and stop problem. Lukasz Biegaj 13:21
Re: Simplify backend terminate and wait logic in postgres_fdw test Tom Lane 13:35
Re: WIP: WAL prefetch (another approach) Tom Lane 13:46
Re: Simplify backend terminate and wait logic in postgres_fdw test Bharath Rupireddy 13:50
Re: .ready and .done files considered harmful Robert Haas 14:07
Re: Identify missing publications from publisher while create/alter subscription. Bharath Rupireddy 14:23
Re: Unresolved repliaction hang and stop problem. Alvaro Herrera 14:35
Re: Simplify backend terminate and wait logic in postgres_fdw test 📎 Tom Lane 15:38
Re: .ready and .done files considered harmful Dilip Kumar 15:54
Extending amcheck to check toast size and compression 📎 Mark Dilger 16:20
Re: Incorrect snapshots while promoting hot standby node when 2PC is used Tom Lane 16:32
Re: .ready and .done files considered harmful Robert Haas 16:42
Re: Extending amcheck to check toast size and compression Justin Pryzby 16:43
Re: MaxOffsetNumber for Table AMs Robert Haas 16:56
Re: Incorrect snapshots while promoting hot standby node when 2PC is used Andres Freund 17:13
Re: PG in container w/ pid namespace is init, process exits cause restart Greg Stark 17:35
Re: PG in container w/ pid namespace is init, process exits cause restart Tom Lane 17:43
Re: PG in container w/ pid namespace is init, process exits cause restart Robert Haas 18:05
Re: PG in container w/ pid namespace is init, process exits cause restart Joe Conway 18:07
Re: Extending amcheck to check toast size and compression 📎 Mark Dilger 18:24
Re: PG in container w/ pid namespace is init, process exits cause restart Tom Lane 18:26
Re: Small issues with CREATE TABLE COMPRESSION 📎 Robert Haas 18:36
Re: MaxOffsetNumber for Table AMs 📎 Jeff Davis 18:52
Re: PG in container w/ pid namespace is init, process exits cause restart Robert Haas 18:55
Re: few ideas for pgbench Fabien COELHO 18:59

Browse Archives

Prev | Next