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

May 29, 2021

Thread Author Time
ANALYZE's dead tuple accounting can get confused Peter Geoghegan 00:27
Re: AWS forcing PG upgrade from v9.6 a disaster Jan Wieck 02:27
Re: Skipping logical replication transactions on subscriber side Masahiko Sawada 02:32
Re: AWS forcing PG upgrade from v9.6 a disaster Andrew Dunstan 02:41
Re: AWS forcing PG upgrade from v9.6 a disaster Christophe Pettus 02:43
Re: Skipping logical replication transactions on subscriber side Masahiko Sawada 02:56
Regarding the necessity of RelationGetNumberOfBlocks for every rescan / bitmap heap scan. Andy Fan 03:23
Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator) 04:08
Re: Parallel Inserts in CREATE TABLE AS Amit Kapila 04:16
Re: Decoding speculative insert with toast leaks memory Amit Kapila 04:29
Re: AWS forcing PG upgrade from v9.6 a disaster Alexey M Boltenkov 05:24
Re: Skipping logical replication transactions on subscriber side Amit Kapila 06:54
Re: be-secure-gssapi.c and auth.c with setenv() not compatible on Windows Michael Paquier 08:52
Re: AWS forcing PG upgrade from v9.6 a disaster Jan Wieck 11:39
Re: Decoding speculative insert with toast leaks memory Tomas Vondra 12:15
Re: be-secure-gssapi.c and auth.c with setenv() not compatible on Windows Tom Lane 14:44
Addition of alias types regpublication and regsubscription 📎 vignesh C 15:29
Re: CREATE COLLATION - check for duplicate options and error out if found one vignesh C 15:38
Re: Addition of alias types regpublication and regsubscription Tom Lane 15:40
Re: CREATE COLLATION - check for duplicate options and error out if found one 📎 Bharath Rupireddy 15:49
Re: CALL versus procedures with output-only arguments 📎 Tom Lane 17:32
Re: fdatasync performance problem with large number of DB files Justin Pryzby 19:23
Re: security_definer_search_path GUC Joel Jacobson 20:05
Re: security_definer_search_path GUC Marko Tiikkaja 20:10
Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator) 20:17

May 30, 2021

Thread Author Time
Clear empty space in a page. 📎 Yura Sokolov 00:10
O_DIRECT on macOS 📎 Thomas Munro 04:39
Re: Regarding the necessity of RelationGetNumberOfBlocks for every rescan / bitmap heap scan. Andy Fan 04:51
Re: Clear empty space in a page. Fabien COELHO 05:22
Re: security_definer_search_path GUC Joel Jacobson 06:51
Re: security_definer_search_path GUC Joel Jacobson 07:30
Re: security_definer_search_path GUC Pavel Stehule 07:54
Re: Add ZSON extension to /contrib/ Joel Jacobson 08:17
psql - factor out echo code 📎 Fabien COELHO 09:09
Re: [PATCH] More docs on what to do and not do in extension code 📎 Laurenz Albe 11:19
Re: [PATCH] expand the units that pg_size_pretty supports on output Asif Rehman 12:38
Re: GISTSTATE is too large 📎 Andreas Karlsson 13:14
Re: GISTSTATE is too large Zhihong Yu 14:21
Re: O_DIRECT on macOS Justin Pryzby 16:19
Re: Clear empty space in a page. Omar Kilani 16:23
Reducing memory consumption for pending inval messages 📎 Tom Lane 17:22
Re: list of extended statistics on psql (\dX) Justin Pryzby 17:24
Re: Fdw batch insert error out when set batch_size > 65535 📎 Tomas Vondra 19:51
Re: list of extended statistics on psql (\dX) Tomas Vondra 20:05
Re: O_DIRECT on macOS Andres Freund 20:12
postgres_fdw batching vs. (re)creating the tuple slots Tomas Vondra 20:22
Re: GISTSTATE is too large Andres Freund 20:34
Re: postgres_fdw batching vs. (re)creating the tuple slots Andres Freund 20:58
Re: Clear empty space in a page. Andres Freund 21:07
Re: postgres_fdw batching vs. (re)creating the tuple slots Tom Lane 21:10
Re: postgres_fdw batching vs. (re)creating the tuple slots Andres Freund 21:26
Re: storing an explicit nonce Andres Freund 21:34
Re: Performance degradation of REFRESH MATERIALIZED VIEW 📎 Tomas Vondra 22:15
Re: O_DIRECT on macOS 📎 Thomas Munro 22:29
Re: O_DIRECT on macOS Thomas Munro 22:31
Re: postgres_fdw batching vs. (re)creating the tuple slots Tom Lane 23:17

May 31, 2021

Thread Author Time
Re: be-secure-gssapi.c and auth.c with setenv() not compatible on Windows 📎 Michael Paquier 00:14
Re: Multiple hosts in connection string failed to failover in non-hot standby mode Justin Pryzby 01:25
Re: Teaching users how they can get the most out of HOT in Postgres 14 Masahiko Sawada 01:30
Re: Multiple hosts in connection string failed to failover in non-hot standby mode Michael Paquier 02:00
RE: [BUG]Update Toast data failure in logical replication [email protected] 02:34
Re: Bracket, brace, parenthesis Michael Paquier 02:36
Re: Decoding speculative insert with toast leaks memory Amit Kapila 02:51
Re: Race condition in recovery? Tatsuro Yamada 02:52
Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator) 03:07
Re: [HACKERS] logical decoding of two-phase transactions 📎 Ajin Cherian 03:09
Re: Decoding speculative insert with toast leaks memory Dilip Kumar 03:20
Re: Forget close an open relation in ReorderBufferProcessTXN() 📎 Amit Langote 03:21
Re: Multiple hosts in connection string failed to failover in non-hot standby mode Michael Paquier 03:33
Re: AWS forcing PG upgrade from v9.6 a disaster Christophe Pettus 03:41
Re: pg_get_wal_replay_pause_state() should not return 'paused' while a promotion is ongoing. Fujii Masao 03:52
Re: Fdw batch insert error out when set batch_size > 65535 Bharath Rupireddy 04:01
Re: Multiple hosts in connection string failed to failover in non-hot standby mode Tom Lane 04:05
Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator) 04:23
Re: AWS forcing PG upgrade from v9.6 a disaster Tom Lane 04:44
Re: Bracket, brace, parenthesis Kyotaro Horiguchi 05:09
Re: Parallel Full Hash Join Greg Nancarrow 05:17
Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator) 05:24
RE: Parallel INSERT SELECT take 2 📎 [email protected] 05:34
Re: Regarding the necessity of RelationGetNumberOfBlocks for every rescan / bitmap heap scan. Andy Fan 05:46
回复：Re: Regarding the necessity of RelationGetNumberOfBlocks for every rescan / bitmap heap scan. 陈佳昕 (步真) 05:59
Re: Multiple hosts in connection string failed to failover in non-hot standby mode Michael Paquier 06:31
Re: Parallel Inserts in CREATE TABLE AS 📎 Bharath Rupireddy 06:48
Re: [BUG]Update Toast data failure in logical replication Dilip Kumar 06:50
Re: Skipping logical replication transactions on subscriber side Masahiko Sawada 07:09
why is the permission granted in a non-recursive way and what are the benefits mzj1996 07:19
How to disable the autovacuum ? Esteban Zimanyi 07:29
Re: Different compression methods for FPI Andrey Borodin 07:33
Duplicate history file? Kyotaro Horiguchi 07:58
postgres_fdw: Handle boolean comparison predicates 📎 Emre Hasegeli 08:03
Re: Race condition in recovery? Kyotaro Horiguchi 08:03
Re: pg_get_wal_replay_pause_state() should not return 'paused' while a promotion is ongoing. Kyotaro Horiguchi 08:18
Re: why is the permission granted in a non-recursive way and what are the benefits Zhihong Yu 08:36
Re: How to disable the autovacuum ? Christoph Moench-Tegeder 08:47
Re: [BUG]Update Toast data failure in logical replication 📎 Dilip Kumar 09:11
Re: Fix RADIUS error reporting in hba file parsing Magnus Hagander 09:31
Re: How to disable the autovacuum ? Esteban Zimanyi 09:32
RE: [BUG]Update Toast data failure in logical replication [email protected] 10:03
Re: [BUG]Update Toast data failure in logical replication Dilip Kumar 10:09
Re: Decoding speculative insert with toast leaks memory 📎 Dilip Kumar 10:59
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila 11:16
Re: Skipping logical replication transactions on subscriber side Amit Kapila 11:40
Re: postgres_fdw: Handle boolean comparison predicates Ashutosh Bapat 12:08
Re: Incorrect snapshots while promoting hot standby node when 2PC is used 📎 Michael Paquier 12:37
join pushdown and issue with foreign update Alexander Pyhalov 12:39
Re: Decoding speculative insert with toast leaks memory Dilip Kumar 13:02
Re: Multiple hosts in connection string failed to failover in non-hot standby mode Tom Lane 13:36
Re: Addition of alias types regpublication and regsubscription vignesh C 13:37
Re: why is the permission granted in a non-recursive way and what are the benefits Tom Lane 13:44
Re: How to disable the autovacuum ? Tom Lane 13:49
Re: CREATE COLLATION - check for duplicate options and error out if found one vignesh C 14:10
Re: How to disable the autovacuum ? Esteban Zimanyi 14:10
make world and install-world without docs 📎 Andrew Dunstan 14:16
Re: How to disable the autovacuum ? Christoph Moench-Tegeder 14:21
Re: Decoding speculative insert with toast leaks memory Dilip Kumar 14:42
Re: join pushdown and issue with foreign update Alexander Pyhalov 16:04
Re: postgres_fdw: Handle boolean comparison predicates Emre Hasegeli 16:51
Re: proposal: enhancing plpgsql debug API - returns text value of variable content 📎 Pavel Stehule 18:50
Re: CALL versus procedures with output-only arguments Peter Eisentraut 18:59
Re: Skipping logical replication transactions on subscriber side Peter Eisentraut 19:25
Re: make world and install-world without docs Joel Jacobson 19:32
Re: CALL versus procedures with output-only arguments Tom Lane 19:55
Re: make world and install-world without docs Tom Lane 20:07
Re: storing an explicit nonce Stephen Frost 20:16
Re: CALL versus procedures with output-only arguments Tom Lane 20:25
Re: Allowing to create LEAKPROOF functions to non-superuser Noah Misch 21:39

June 1, 2021

Thread Author Time
Re: make world and install-world without docs Alvaro Herrera 00:06
Re: Multiple hosts in connection string failed to failover in non-hot standby mode Michael Paquier 00:56
Re: Multiple hosts in connection string failed to failover in non-hot standby mode Tom Lane 01:07
Re: be-secure-gssapi.c and auth.c with setenv() not compatible on Windows Michael Paquier 01:14
Re: CALL versus procedures with output-only arguments Laurenz Albe 01:28
Re: Alias collision in `refresh materialized view concurrently` Michael Paquier 01:41
Re: CALL versus procedures with output-only arguments David G. Johnston 01:48
Re: Different compression methods for FPI Michael Paquier 02:06
Re: Assertion failure while streaming toasted data Amit Kapila 03:04
Re: A new function to wait for the backend exit after termination Noah Misch 03:48
Re: Skipping logical replication transactions on subscriber side Amit Kapila 04:01
Re: Duplicate history file? 📎 Tatsuro Yamada 04:03
Re: AWS forcing PG upgrade from v9.6 a disaster Justin Pryzby 04:16
Re: Decoding speculative insert with toast leaks memory Amit Kapila 04:23
Re: Decoding speculative insert with toast leaks memory Dilip Kumar 04:29
Re: Skipping logical replication transactions on subscriber side Masahiko Sawada 04:37
Re: Decoding speculative insert with toast leaks memory Amit Kapila 04:51
Re: Skipping logical replication transactions on subscriber side Amit Kapila 05:28
Re: Decoding speculative insert with toast leaks memory Dilip Kumar 05:30
Re: Clear empty space in a page. Yura Sokolov 06:08
Re: Decoding speculative insert with toast leaks memory Dilip Kumar 06:13
Re: Decoding speculative insert with toast leaks memory Amit Kapila 06:55
RE: [BUG]Update Toast data failure in logical replication [email protected] 06:59
Re: security_definer_search_path GUC Joel Jacobson 06:59
Re: locking [user] catalog tables vs 2pc vs logical rep 📎 Peter Smith 07:32
Re: Multiple hosts in connection string failed to failover in non-hot standby mode 📎 Michael Paquier 07:34
Re: Alias collision in `refresh materialized view concurrently` 📎 Bharath Rupireddy 07:43
Re: Skipping logical replication transactions on subscriber side Masahiko Sawada 07:53
Re: A new function to wait for the backend exit after termination Bharath Rupireddy 07:55
RE: Skip partition tuple routing with constant partition key 📎 [email protected] 08:43
Re: security_definer_search_path GUC Pavel Stehule 08:44
Re: Asynchronous Append on postgres_fdw nodes. 📎 Etsuro Fujita 09:30
Re: Parallel INSERT SELECT take 2 Greg Nancarrow 09:32
Re: Skipping logical replication transactions on subscriber side Amit Kapila 09:47
Re: Forget close an open relation in ReorderBufferProcessTXN() Amit Kapila 09:56
Re: [BUG]Update Toast data failure in logical replication Dilip Kumar 10:09
Re: security_definer_search_path GUC Joel Jacobson 10:52
Re: security_definer_search_path GUC Pavel Stehule 10:55
Re: security_definer_search_path GUC Joel Jacobson 11:12
Re: Decoding speculative insert with toast leaks memory Dilip Kumar 11:52
Re: Alias collision in `refresh materialized view concurrently` Bernd Helmle 11:54
parent foreign tables and row marks 📎 Amit Langote 11:55
Re: Forget close an open relation in ReorderBufferProcessTXN() Amit Langote 12:04
Re: storing an explicit nonce Robert Haas 12:15
Re: Table AM modifications to accept column projection lists 📎 Aleksander Alekseev 12:38
Re: security_definer_search_path GUC Pavel Stehule 12:41
Re: join pushdown and issue with foreign update 📎 Amit Langote 12:47
Re: Alias collision in `refresh materialized view concurrently` 📎 Bharath Rupireddy 14:01
Re: storing an explicit nonce Bruce Momjian 14:09
Re: Decoding speculative insert with toast leaks memory 📎 Dilip Kumar 14:30
Re: Refactor "mutually exclusive options" error reporting code in parse_subscription_options 📎 Bharath Rupireddy 14:55
Re: Skipping logical replication transactions on subscriber side Peter Eisentraut 15:35
Re: security_definer_search_path GUC Joel Jacobson 15:56
Re: join pushdown and issue with foreign update 📎 Alexander Pyhalov 16:00
Re: security_definer_search_path GUC Pavel Stehule 16:05
return correct error code from pgtls_init 📎 Zhihong Yu 17:32
Re: AWS forcing PG upgrade from v9.6 a disaster Dean Gibson (DB Administrator) 17:44
Re: CALL versus procedures with output-only arguments Tom Lane 17:46
Re: join pushdown and issue with foreign update Tom Lane 18:19
Re: join pushdown and issue with foreign update 📎 Alexander Pyhalov 18:47
Re: create table like: ACCESS METHOD 📎 Justin Pryzby 19:10
Re: Update maintenance_work_mem/autovacuum_work_mem to reflect the 1GB limitation with VACUUM Greg Sabino Mullane 19:25
Re: CALL versus procedures with output-only arguments Andrew Dunstan 19:37
Re: join pushdown and issue with foreign update Tom Lane 20:01
Re: Race condition in recovery? Robert Haas 20:45
Re: join pushdown and issue with foreign update 📎 Tom Lane 21:32
Re: make world and install-world without docs Peter Eisentraut 22:20
Re: make world and install-world without docs Tom Lane 22:23
Re: CALL versus procedures with output-only arguments Peter Eisentraut 22:54
Re: [HACKERS] logical decoding of two-phase transactions 📎 Peter Smith 23:04
Re: CALL versus procedures with output-only arguments Tom Lane 23:24
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith 23:27

June 2, 2021

Thread Author Time
Re: CALL versus procedures with output-only arguments Tom Lane 00:04
Re: Alias collision in `refresh materialized view concurrently` Thomas Munro 00:30

Browse Archives

Prev | Next