pgsql-hackers - June 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)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

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
Re: Alias collision in `refresh materialized view concurrently` Michael Paquier 01:03
ALTER SUBSCRIPTION REFRESH PUBLICATION has default copy_data = true? Peter Smith 01:10
Re: return correct error code from pgtls_init Michael Paquier 01:14
Fixup some appendStringInfo and appendPQExpBuffer calls 📎 [email protected] 01:37
TAP tests still sensitive to various PG* environment variables 📎 Michael Paquier 01:49
Re: return correct error code from pgtls_init Zhihong Yu 01:56
Re: Move pg_attribute.attcompression to earlier in struct for reduced size? Michael Paquier 02:32
pgsql: Add regression test for recovery pause. Fujii Masao 03:20
Re: pg_get_wal_replay_pause_state() should not return 'paused' while a promotion is ongoing. Fujii Masao 03:22
Re: Move pg_attribute.attcompression to earlier in struct for reduced size? Michael Paquier 03:25
Re: be-secure-gssapi.c and auth.c with setenv() not compatible on Windows Michael Paquier 03:26
Re: Refactor "mutually exclusive options" error reporting code in parse_subscription_options Peter Smith 03:37
Re: Decoding speculative insert with toast leaks memory Amit Kapila 04:12
Re: Fixup some appendStringInfo and appendPQExpBuffer calls Michael Paquier 04:29
Re: Speed up pg_checksums in cases where checksum already set Michael Paquier 05:05
Re: Two patches to speed up pg_rewind. Michael Paquier 05:20
Re: Alias collision in `refresh materialized view concurrently` 📎 Bharath Rupireddy 05:23
Re: Refactor "mutually exclusive options" error reporting code in parse_subscription_options Bharath Rupireddy 05:33
Re: Decoding speculative insert with toast leaks memory Amit Kapila 05:54
Re: Skipping logical replication transactions on subscriber side Amit Kapila 06:07
Re: Decoding speculative insert with toast leaks memory 📎 Dilip Kumar 06:07
Re: Refactor "mutually exclusive options" error reporting code in parse_subscription_options Peter Smith 06:13
Re: Two patches to speed up pg_rewind. Thomas Munro 06:20
Re: Decoding speculative insert with toast leaks memory Amit Kapila 06:22
Re: [BUG]Update Toast data failure in logical replication 📎 Dilip Kumar 06:44
Re: security_definer_search_path GUC Joel Jacobson 06:44
Re: security_definer_search_path GUC Pavel Stehule 07:07
RE: Parallel INSERT SELECT take 2 📎 [email protected] 07:30
Re: join pushdown and issue with foreign update Andrey Lepikhov 07:39
Re: join pushdown and issue with foreign update Amit Langote 07:43
Re: Alias collision in `refresh materialized view concurrently` Michael Paquier 07:57
Re: Two patches to speed up pg_rewind. Michael Paquier 08:02
Re: join pushdown and issue with foreign update Alexander Pyhalov 08:35
Re: TAP tests still sensitive to various PG* environment variables Daniel Gustafsson 08:39
Re: join pushdown and issue with foreign update Amit Langote 08:40
RE: [BUG]Update Toast data failure in logical replication [email protected] 09:07
Re: Update maintenance_work_mem/autovacuum_work_mem to reflect the 1GB limitation with VACUUM Masahiko Sawada 09:16
RE: Parallel INSERT SELECT take 2 📎 [email protected] 09:33
Re: [BUG]Update Toast data failure in logical replication Dilip Kumar 09:39
tab-complete for CREATE TYPE ... SUBSCRIPT 📎 [email protected] 09:50
Re: Alias collision in `refresh materialized view concurrently` 📎 Bharath Rupireddy 10:14
Re: Fixup some appendStringInfo and appendPQExpBuffer calls Alvaro Herrera 10:57
RE: tab-complete for CREATE TYPE ... SUBSCRIPT 📎 [email protected] 11:06
pg_stat_progress_create_index vs. parallel index builds Tomas Vondra 11:56
Re: [PATCH] Allow queries in WHEN expression of FOR EACH STATEMENT triggers 📎 Joe Wildish 12:19
Re: Refactor "mutually exclusive options" error reporting code in parse_subscription_options 📎 Bharath Rupireddy 12:41
Re: security_definer_search_path GUC Joel Jacobson 12:46
Re: Race condition in recovery? Noah Misch 13:01
Re: pg_stat_progress_create_index vs. parallel index builds Matthias van de Meent 13:03
Re: pg_stat_progress_create_index vs. parallel index builds Tomas Vondra 13:23
Support for CREATE MODULE? 📎 Jim Mlodgenski 13:38
Re: [BUG]Update Toast data failure in logical replication Kuntal Ghosh 13:50
Re: [BUG]Update Toast data failure in logical replication Dilip Kumar 13:53
Re: Support for CREATE MODULE? Tom Lane 13:58
Re: tab-complete for CREATE TYPE ... SUBSCRIPT Bharath Rupireddy 14:21
Re: Speed up pg_checksums in cases where checksum already set 📎 Greg Sabino Mullane 14:21
Re: Support for CREATE MODULE? Jim Mlodgenski 14:43
Re: tab-complete for CREATE TYPE ... SUBSCRIPT Tom Lane 14:45
Re: ALTER SUBSCRIPTION REFRESH PUBLICATION has default copy_data = true? Peter Eisentraut 14:52
Re: ALTER SUBSCRIPTION REFRESH PUBLICATION has default copy_data = true? Bharath Rupireddy 14:53
Re: pg_stat_progress_create_index vs. parallel index builds 📎 Matthias van de Meent 14:54
Re: Fixup some appendStringInfo and appendPQExpBuffer calls Peter Eisentraut 14:55
Re: Support for CREATE MODULE? Bruce Momjian 15:07
Re: Support for CREATE MODULE? Joe Conway 15:11
Re: Support for CREATE MODULE? Tom Lane 15:14
Re: Support for CREATE MODULE? Joel Jacobson 15:22
Re: pg_stat_progress_create_index vs. parallel index builds Tomas Vondra 15:42
Re: pg_stat_progress_create_index vs. parallel index builds Matthias van de Meent 15:48
speed up verifying UTF-8 📎 John Naylor 16:26
Re: security_definer_search_path GUC Marko Tiikkaja 16:36
Re: pg_stat_progress_create_index vs. parallel index builds Alvaro Herrera 16:38
Re: security_definer_search_path GUC Pavel Stehule 16:52
Re: security_definer_search_path GUC Julien Rouhaud 16:58
Re: parent foreign tables and row marks Tom Lane 18:39
Re: Support for CREATE MODULE? Alvaro Herrera 19:08
Re: security_definer_search_path GUC Alvaro Herrera 19:20
Re: TAP tests still sensitive to various PG* environment variables Andrew Dunstan 19:43
Re: make world and install-world without docs Andrew Dunstan 19:47
Re: pg_stat_progress_create_index vs. parallel index builds Tomas Vondra 20:20
Re: make world and install-world without docs Tom Lane 20:21
Re: security_definer_search_path GUC Joel Jacobson 20:32
Re: pg_stat_progress_create_index vs. parallel index builds Alvaro Herrera 20:33
improve installation short version 📎 Andrew Dunstan 20:43
Re: improve installation short version Mark Dilger 20:58
Re: Speed up pg_checksums in cases where checksum already set 📎 Greg Sabino Mullane 21:09
Re: pgsql: Add regression test for recovery pause. Tom Lane 21:26
Re: improve installation short version Andrew Dunstan 21:27
Re: improve installation short version Tom Lane 21:36
Re: pgsql: Add regression test for recovery pause. Andrew Dunstan 22:25
Re: security_definer_search_path GUC Marko Tiikkaja 22:50
Re: security_definer_search_path GUC Marko Tiikkaja 22:55
Re: Performance degradation of REFRESH MATERIALIZED VIEW Tomas Vondra 23:02
Decoding of two-phase xacts missing from CREATE_REPLICATION_SLOT command Jeff Davis 23:17

June 3, 2021

Thread Author Time
Re: parent foreign tables and row marks Amit Langote 01:07
Re: Fixup some appendStringInfo and appendPQExpBuffer calls David Rowley 01:53
Re: Outdated comments about proc->sem in lwlock.c 📎 Thomas Munro 02:07
Re: What to call an executor node which lazily caches tuples in a hash table? (GUC) Justin Pryzby 02:36
Re: A micro-optimisation for ProcSendSignal() 📎 Thomas Munro 02:38
Re: PoC/WIP: Extended statistics on expressions (\d in old client) Justin Pryzby 02:39
Re: Performance degradation of REFRESH MATERIALIZED VIEW Masahiko Sawada 02:56
Re: Fixup some appendStringInfo and appendPQExpBuffer calls Tom Lane 02:56
Re: Fixup some appendStringInfo and appendPQExpBuffer calls Michael Paquier 03:00
Re: TAP tests still sensitive to various PG* environment variables Michael Paquier 03:03
Re: What to call an executor node which lazily caches tuples in a hash table? (GUC) David Rowley 03:04
Re: Re[3]: On login trigger: take three 📎 Greg Nancarrow 03:05
Re: Fixup some appendStringInfo and appendPQExpBuffer calls David Rowley 03:06
Re: TAP tests still sensitive to various PG* environment variables Michael Paquier 03:10
Documentation missing for PGSSLCRLDIR 📎 Michael Paquier 03:13
RE: locking [user] catalog tables vs 2pc vs logical rep 📎 [email protected] 03:48
Re: Fixup some appendStringInfo and appendPQExpBuffer calls 📎 David Rowley 03:51
Re: Decoding of two-phase xacts missing from CREATE_REPLICATION_SLOT command Amit Kapila 03:59
Re: locking [user] catalog tables vs 2pc vs logical rep vignesh C 04:08
Re: Fixup some appendStringInfo and appendPQExpBuffer calls Tom Lane 04:17
Re: Fixup some appendStringInfo and appendPQExpBuffer calls David Rowley 04:39
Re: Documentation missing for PGSSLCRLDIR Kyotaro Horiguchi 04:42
Re: Race condition in recovery? Kyotaro Horiguchi 04:54
Re: Transactions involving multiple postgres foreign servers, take 2 Masahiro Ikeda 04:56
Re: security_definer_search_path GUC Joel Jacobson 06:13
Re: Fixup some appendStringInfo and appendPQExpBuffer calls 📎 David Rowley 06:51
Re: Alias collision in `refresh materialized view concurrently` Michael Paquier 06:56
Failures with gcd functions with GCC snapshots GCC and -O3 (?) Michael Paquier 07:26
Re: Failures with gcd functions with GCC snapshots GCC and -O3 (?) Dean Rasheed 08:28
Re: Failures with gcd functions with GCC snapshots GCC and -O3 (?) Sergei Kornilov 09:34
Re: Asynchronous Append on postgres_fdw nodes. Etsuro Fujita 09:49
pg_upgrade is failed for 'plpgsql_call_handler' handler tushar 09:53
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila 09:56

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30