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

June 7, 2021

Thread Author Time
Re: Transactions involving multiple postgres foreign servers, take 2 [email protected] 00:35
Re: Transactions involving multiple postgres foreign servers, take 2 [email protected] 00:57
Re: ALTER SUBSCRIPTION REFRESH PUBLICATION has default copy_data = true? Peter Smith 01:05
Re: please update ps display for recovery checkpoint 📎 Justin Pryzby 02:13
contrib/pg_visibility fails regression under CLOBBER_CACHE_ALWAYS Tom Lane 02:15
Re: Decoding speculative insert with toast leaks memory Amit Kapila 03:00
Re: Decoding speculative insert with toast leaks memory Dilip Kumar 03:16
Re: locking [user] catalog tables vs 2pc vs logical rep vignesh C 03:56
Re: Asynchronous Append on postgres_fdw nodes. Etsuro Fujita 03:57
Re: Race condition in recovery? Kyotaro Horiguchi 04:57
Re: Race condition in recovery? Kyotaro Horiguchi 05:01
Re: locking [user] catalog tables vs 2pc vs logical rep Amit Kapila 05:14
Re: Decoding of two-phase xacts missing from CREATE_REPLICATION_SLOT command Amit Kapila 05:16
Re: Fast COPY FROM based on batch insert Andrey Lepikhov 06:36
Re: Multiple hosts in connection string failed to failover in non-hot standby mode Michael Paquier 06:43
Re: Duplicate history file? Tatsuro Yamada 06:57
Re: Duplicate history file? Tatsuro Yamada 07:13
back-port one-line gcc-10+ warning fix to REL_10_STABLE 📎 Anton Voloshin 07:16
Re: Logical replication keepalive flood 📎 Kyotaro Horiguchi 07:23
Re: contrib/pg_visibility fails regression under CLOBBER_CACHE_ALWAYS Masahiko Sawada 07:30
Re: Duplicate history file? Kyotaro Horiguchi 07:31
Re: Duplicate history file? Kyotaro Horiguchi 07:38
Re: DELETE CASCADE Peter Eisentraut 07:54
Re: Duplicate history file? Tatsuro Yamada 07:54
Re: DELETE CASCADE Peter Eisentraut 07:56
Re: [HACKERS] logical decoding of two-phase transactions Greg Nancarrow 08:20
Duplicate history file? Kyotaro Horiguchi 08:31
Re: Duplicate history file? Kyotaro Horiguchi 08:32
Re: SQL-standard function body 📎 Peter Eisentraut 08:52
Re: installcheck failure in indirect_toast with default_toast_compression = lz4 Michael Paquier 09:03
Re: missing GRANT on pg_subscription columns Amit Kapila 09:08
Re: SQL-standard function body Julien Rouhaud 09:10
Re: locking [user] catalog tables vs 2pc vs logical rep Amit Kapila 09:22
Re: Asynchronous Append on postgres_fdw nodes. 📎 Etsuro Fujita 09:36
Re: Fix dropped object handling in pg_event_trigger_ddl_commands 📎 Aleksander Alekseev 09:44
Re: SSL SNI 📎 Peter Eisentraut 09:54
Re: Tid scan improvements 📎 Peter Eisentraut 10:11
Re: Logical replication keepalive flood Amit Kapila 10:13
Re: Logical replication keepalive flood Abbas Butt 10:26
Re: Fast COPY FROM based on batch insert 📎 Andrey Lepikhov 11:16
Confused about extension and shared_preload_libraries Japin Li 11:18
Re: Confused about extension and shared_preload_libraries Aleksander Alekseev 11:25
RE: Skip partition tuple routing with constant partition key 📎 [email protected] 11:38
Re: Tid scan improvements Edmund Horner 11:46
Re: Tid scan improvements David Rowley 11:50
Re: contrib/pg_visibility fails regression under CLOBBER_CACHE_ALWAYS 📎 Masahiko Sawada 12:11
Re: speed up verifying UTF-8 Heikki Linnakangas 12:24
Re: Decoding speculative insert with toast leaks memory 📎 Dilip Kumar 12:34
Re: speed up verifying UTF-8 📎 John Naylor 12:39
Re: contrib/pg_visibility fails regression under CLOBBER_CACHE_ALWAYS Tomas Vondra 13:01
Re: Decoding speculative insert with toast leaks memory Amit Kapila 13:04
Re: Strangeness with UNIQUE indexes and UTF-8 Magnus Hagander 13:13
Re: Decoding speculative insert with toast leaks memory Dilip Kumar 13:15
Re: when the startup process doesn't Robert Haas 13:21
Re: when the startup process doesn't Tom Lane 13:42
Re: [bug?] Missed parallel safety checks, and wrong parallel safety Robert Haas 13:58
Re: Multiple hosts in connection string failed to failover in non-hot standby mode Tom Lane 14:38
Re: Race condition in recovery? Robert Haas 14:40
Re: back-port one-line gcc-10+ warning fix to REL_10_STABLE Alvaro Herrera 15:14
Re: Pre-allocating WAL files 📎 Bossart, Nathan 15:18
Re: SQL-standard function body Tom Lane 15:27
Re: SSL SNI Tom Lane 15:34
Re: libpq debug log Robert Haas 15:37
Re: SQL-standard function body Julien Rouhaud 15:56
Re: please update ps display for recovery checkpoint Bossart, Nathan 16:02
Re: please update ps display for recovery checkpoint Robert Haas 17:28
Re: Duplicate history file? Stephen Frost 18:20
A modest proposal vis hierarchical queries: MINUS in the column list Mark Zellers 18:25
Re: Make unlogged table resets detectable Robert Haas 18:34
Re: Make unlogged table resets detectable Tom Lane 18:56
Re: Race condition in recovery? Robert Haas 19:02
Re: SQL-standard function body 📎 Tom Lane 19:24
Re: Tid scan improvements Peter Eisentraut 19:38
Re: SQL-standard function body Peter Eisentraut 19:49
Re: CALL versus procedures with output-only arguments Peter Eisentraut 19:54
automatically generating node support functions 📎 Peter Eisentraut 20:27
Re: CALL versus procedures with output-only arguments Tom Lane 20:34
Re: security_definer_search_path GUC Joel Jacobson 20:54
Re: Add PortalDrop in exec_execute_message Alvaro Herrera 21:07
Re: security_definer_search_path GUC David G. Johnston 21:09
Re: security_definer_search_path GUC David G. Johnston 21:22
Re: security_definer_search_path GUC David G. Johnston 21:26
Re: A modest proposal vis hierarchical queries: MINUS in the column list David G. Johnston 21:36
Re: Add PortalDrop in exec_execute_message Tom Lane 21:59
Re: Add PortalDrop in exec_execute_message 📎 Alvaro Herrera 22:08
Re: A modest proposal vis hierarchical queries: MINUS in the column list Tom Lane 22:10
Re: Add PortalDrop in exec_execute_message Tom Lane 22:15
logical decoding and replication of sequences 📎 Tomas Vondra 22:28
Re: CALL versus procedures with output-only arguments 📎 Tom Lane 23:10
Re: pgsql: Support parallel btree index builds. Alvaro Herrera 23:11
Re: A test for replay of regression tests 📎 Anastasia Lubennikova 23:44

June 8, 2021

Thread Author Time
Remove server and libpq support for the version 2 wire protocol Tatsuo Ishii 00:13
RE: Transactions involving multiple postgres foreign servers, take 2 [email protected] 00:47
Re: pgsql: Support parallel btree index builds. Peter Geoghegan 00:47
Re: Logical replication keepalive flood Kyotaro Horiguchi 01:05
Re: Race condition in recovery? Kyotaro Horiguchi 01:29
Re: SQL-standard function body Julien Rouhaud 01:51
Re: Confused about extension and shared_preload_libraries Japin Li 02:20
Re: Duplicate history file? Tatsuro Yamada 02:33
Re: security_definer_search_path GUC Joel Jacobson 02:48
Re: Misplaced superuser check in pg_log_backend_memory_contexts() Michael Paquier 02:49
Re: A modest proposal vis hierarchical queries: MINUS in the column list Julien Rouhaud 02:50
Re: Make unlogged table resets detectable Justin Pryzby 02:58
Re: Duplicate history file? Kyotaro Horiguchi 03:04
Error on pgbench logs 📎 YoungHwan Joo 03:09
Re: Multiple hosts in connection string failed to failover in non-hot standby mode 📎 Michael Paquier 03:24
Re: [bug?] Missed parallel safety checks, and wrong parallel safety Amit Kapila 03:33
Re: Make unlogged table resets detectable Michael Paquier 03:46
Re: Hook for extensible parsing. 📎 Julien Rouhaud 04:16
Re: Duplicate history file? Kyotaro Horiguchi 04:17
Re: Make unlogged table resets detectable Julien Rouhaud 04:52
Re: Asynchronous Append on postgres_fdw nodes. Etsuro Fujita 04:57
Re: Logical replication keepalive flood Kyotaro Horiguchi 05:09
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch Noah Misch 05:31
Re: Race condition in recovery? Dilip Kumar 05:43
Re: [HACKERS] logical decoding of two-phase transactions 📎 Peter Smith 06:12
Re: [HACKERS] logical decoding of two-phase transactions Peter Smith 06:19
Re: SSL SNI Michael Paquier 06:54
Re: Transactions involving multiple postgres foreign servers, take 2 Masahiko Sawada 07:32
Re: Decoding of two-phase xacts missing from CREATE_REPLICATION_SLOT command 📎 Ajin Cherian 07:41
RE: locking [user] catalog tables vs 2pc vs logical rep 📎 [email protected] 08:03
Re: Transactions involving multiple postgres foreign servers, take 2 Kyotaro Horiguchi 08:09
Re: Transactions involving multiple postgres foreign servers, take 2 Kyotaro Horiguchi 08:11
RE: Transactions involving multiple postgres foreign servers, take 2 [email protected] 08:28
RE: Transactions involving multiple postgres foreign servers, take 2 [email protected] 08:45
Re: Race condition in recovery? 📎 Dilip Kumar 08:47
RE: Parallel INSERT SELECT take 2 📎 [email protected] 09:12
Re: Duplicate history file? Tatsuro Yamada 09:19
Remove unused code from the KnownAssignedTransactionIdes submodule 📎 Quan Zongliang 09:32
Unused function parameter in get_qual_from_partbound() 📎 [email protected] 09:50
Re: Error on pgbench logs 📎 Kyotaro Horiguchi 09:59
GiST operator class for bool 📎 Emre Hasegeli 10:48
Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic 📎 Justin Pryzby 11:03
Re: GiST operator class for bool Andrey Borodin 11:07
Re: Unused function parameter in get_qual_from_partbound() David Rowley 11:30
Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic Justin Pryzby 11:33
Re: Decoding speculative insert with toast leaks memory 📎 Dilip Kumar 11:46
Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic 📎 Matthias van de Meent 11:54
Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic Justin Pryzby 12:11
Re: Logical replication keepalive flood Abbas Butt 12:21
Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic Matthias van de Meent 12:27
Re: locking [user] catalog tables vs 2pc vs logical rep vignesh C 12:53
Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic Justin Pryzby 13:15
Re: Make unlogged table resets detectable Robert Haas 13:18
Re: automatically generating node support functions David Rowley 13:40
Re: SSL SNI Peter Eisentraut 14:12
Re: Misplaced superuser check in pg_log_backend_memory_contexts() Fujii Masao 14:30
Re: Move pg_attribute.attcompression to earlier in struct for reduced size? Alvaro Herrera 14:39
Re: [bug?] Missed parallel safety checks, and wrong parallel safety Robert Haas 14:51
Re: GiST operator class for bool Emre Hasegeli 14:53
Re: A modest proposal vis hierarchical queries: MINUS in the column list Andrew Dunstan 15:00
Re: Multiple hosts in connection string failed to failover in non-hot standby mode Tom Lane 15:21
Re: Misplaced superuser check in pg_log_backend_memory_contexts() torikoshia 15:25
Re: A modest proposal vis hierarchical queries: MINUS in the column list Tom Lane 15:39
Re: SQL-standard function body Tom Lane 16:00
Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic Alvaro Herrera 16:06
Re: Race condition in recovery? Robert Haas 16:26
Re: A modest proposal vis hierarchical queries: MINUS in the column list Peter Eisentraut 16:28
[PoC] Federated Authn/z with OAUTHBEARER 📎 Jacob Champion 16:37
Re: Make unlogged table resets detectable Tom Lane 16:52
Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic Andres Freund 17:17
Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic Justin Pryzby 17:34
Re: automatically generating node support functions Peter Eisentraut 17:45
Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic Alvaro Herrera 18:01
Re: Fdw batch insert error out when set batch_size > 65535 Tomas Vondra 18:34
Re: logical decoding bug: segfault in ReorderBufferToastReplace() Jeremy Schneider 18:35
Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic Peter Geoghegan 18:40
Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic Justin Pryzby 18:45
Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic Justin Pryzby 19:04
Re: DELETE CASCADE David Christensen 19:25
Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic Justin Pryzby 19:27
Re: Make unlogged table resets detectable 📎 Jeff Davis 19:28
Re: DELETE CASCADE David Christensen 19:29
Re: Make unlogged table resets detectable Tom Lane 20:08
Re: Decoding of two-phase xacts missing from CREATE_REPLICATION_SLOT command Jeff Davis 20:23
Re: Race condition in recovery? 📎 Robert Haas 20:37
Re: Remove server and libpq support for the version 2 wire protocol Bruce Momjian 20:48
Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic Alvaro Herrera 20:51
Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic Peter Geoghegan 20:52
Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic Justin Pryzby 21:23
Re: Make unlogged table resets detectable Jeff Davis 21:29
Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic 📎 Peter Geoghegan 21:38
logical replication of truncate command with trigger causes Assert 📎 Mark Dilger 21:52
Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic Peter Geoghegan 22:52
Re: logical replication of truncate command with trigger causes Assert Tom Lane 22:55
Re: array_cat anycompatible change is breaking xversion upgrade tests (v14 release notes) Justin Pryzby 22:56
Re: logical replication of truncate command with trigger causes Assert Mark Dilger 23:23
Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic Peter Geoghegan 23:46
Re: logical replication of truncate command with trigger causes Assert Tom Lane 23:58

June 9, 2021

Thread Author Time
Re: array_cat anycompatible change is breaking xversion upgrade tests (v14 release notes) Bruce Momjian 00:02
Re: row filtering for logical replication Peter Smith 00:02
Re: array_cat anycompatible change is breaking xversion upgrade tests (v14 release notes) Justin Pryzby 00:10
Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic Tom Lane 00:11
Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic Justin Pryzby 00:18
RE: Unused function parameter in get_qual_from_partbound() [email protected] 00:28
Re: alter table set TABLE ACCESS METHOD 📎 Jeff Davis 00:33
Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic Peter Geoghegan 00:44
Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic Peter Geoghegan 00:47
Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic Justin Pryzby 00:50
Re: Misplaced superuser check in pg_log_backend_memory_contexts() Michael Paquier 01:37

Browse Archives

Prev | Next