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

Thread Author Time
Re: logical decoding bug: segfault in ReorderBufferToastReplace() Alvaro Herrera 00:07
installcheck failure in indirect_toast with default_toast_compression = lz4 📎 Michael Paquier 00:20
Re: installcheck failure in indirect_toast with default_toast_compression = lz4 Tom Lane 00:28
Re: alter table set TABLE ACCESS METHOD Jeff Davis 00:34
Re: Make unlogged table resets detectable Jeff Davis 00:41
Re: A new function to wait for the backend exit after termination Noah Misch 01:32
Re: installcheck failure in indirect_toast with default_toast_compression = lz4 Michael Paquier 01:41
Re: alter table set TABLE ACCESS METHOD Michael Paquier 04:21
Fix a few typos in brin_minmax_multi.c 📎 David Rowley 04:33
Re: logical decoding bug: segfault in ReorderBufferToastReplace() Dilip Kumar 04:44
Re: Python 3.10 breaks regression tests with traceback changes Peter Eisentraut 05:29
Re: Are we missing (void) when return value of fsm_set_and_search is ignored? Bharath Rupireddy 05:37
Re: libpq debug log Noah Misch 06:05
Re: A new function to wait for the backend exit after termination Bharath Rupireddy 06:36
Re: logical decoding bug: segfault in ReorderBufferToastReplace() Amit Kapila 06:42
Re: DELETE CASCADE Peter Eisentraut 07:29
Re: DELETE CASCADE Peter Eisentraut 07:30
Re: Are we missing (void) when return value of fsm_set_and_search is ignored? Julien Rouhaud 07:36
Logical replication keepalive flood Abbas Butt 11:08
Re: DELETE CASCADE David Christensen 12:21
Re: DELETE CASCADE Isaac Morland 12:24
Re: DELETE CASCADE David Christensen 12:25
Re: Added schema level support for publication. 📎 vignesh C 13:32
Re: Move pg_attribute.attcompression to earlier in struct for reduced size? 📎 Ranier Vilela 14:16
Re: Failures with gcd functions with GCC snapshots GCC and -O3 (?) Fabien COELHO 14:31
Re: libpq debug log Alvaro Herrera 15:02
Re: Table AM modifications to accept column projection lists Zhihong Yu 16:47
Re: A new function to wait for the backend exit after termination Noah Misch 19:08

June 6, 2021

Thread Author Time
Re: Move pg_attribute.attcompression to earlier in struct for reduced size? Michael Paquier 03:07
Re: SQL-standard function body Noah Misch 04:44
Re: PoC/WIP: Extended statistics on expressions Noah Misch 05:37
Re: Identify missing publications from publisher while create/alter subscription. 📎 vignesh C 06:25
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch Noah Misch 06:33
Re: Hook for extensible parsing. 📎 Julien Rouhaud 06:50
Misplaced superuser check in pg_log_backend_memory_contexts() 📎 Michael Paquier 06:53
Re: Misplaced superuser check in pg_log_backend_memory_contexts() Julien Rouhaud 07:13
Re: SQL-standard function body 📎 Julien Rouhaud 07:32
Strangeness with UNIQUE indexes and UTF-8 Omar Kilani 10:54
Re: Strangeness with UNIQUE indexes and UTF-8 Laurenz Albe 11:46
Re: Strangeness with UNIQUE indexes and UTF-8 David Rowley 11:59
Re: Misplaced superuser check in pg_log_backend_memory_contexts() Bharath Rupireddy 13:33
Re: Strangeness with UNIQUE indexes and UTF-8 Omar Kilani 13:41
Re: Strangeness with UNIQUE indexes and UTF-8 Omar Kilani 13:53
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch Tom Lane 14:37
Re: Strangeness with UNIQUE indexes and UTF-8 Tom Lane 15:08
Re: Strangeness with UNIQUE indexes and UTF-8 Omar Kilani 15:08
Re: Misplaced superuser check in pg_log_backend_memory_contexts() Tom Lane 15:13
Re: Strangeness with UNIQUE indexes and UTF-8 Omar Kilani 15:18
Re: Strangeness with UNIQUE indexes and UTF-8 Omar Kilani 15:38
Re: Strangeness with UNIQUE indexes and UTF-8 Magnus Hagander 16:14
Re: Strangeness with UNIQUE indexes and UTF-8 Omar Kilani 16:24
pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic Justin Pryzby 16:35
Re: Strangeness with UNIQUE indexes and UTF-8 Chapman Flack 16:36
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch Tom Lane 16:38
Re: Strangeness with UNIQUE indexes and UTF-8 Omar Kilani 16:38
Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic Matthias van de Meent 17:26
Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic Tom Lane 17:59
Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic Peter Geoghegan 18:00
Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic Andres Freund 18:01
Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic Justin Pryzby 18:43
Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic Peter Geoghegan 19:03
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch Tom Lane 19:10
Re: PoC/WIP: Extended statistics on expressions Tomas Vondra 19:13
Re: PoC/WIP: Extended statistics on expressions Tom Lane 19:17
Re: speed up verifying UTF-8 📎 John Naylor 19:21
Re: list of extended statistics on psql (\dX) 📎 Tomas Vondra 19:47
Re: PoC/WIP: Extended statistics on expressions Tomas Vondra 20:01
Re: pg14b1 stuck in lazy_scan_prune/heap_page_prune of pg_statistic Justin Pryzby 20:06
Re: PoC/WIP: Extended statistics on expressions Tom Lane 20:08
Re: installcheck failure in indirect_toast with default_toast_compression = lz4 Justin Pryzby 20:52
Re: Strangeness with UNIQUE indexes and UTF-8 Justin Pryzby 21:03
Re: Strangeness with UNIQUE indexes and UTF-8 Omar Kilani 21:06
Re: Strangeness with UNIQUE indexes and UTF-8 Omar Kilani 21:20
Re: Multiple hosts in connection string failed to failover in non-hot standby mode 📎 Tom Lane 21:27
Re: Strangeness with UNIQUE indexes and UTF-8 Tom Lane 21:29
Re: Move pg_attribute.attcompression to earlier in struct for reduced size? 📎 Ranier Vilela 21:34
Re: when the startup process doesn't Justin Pryzby 22:23
RE: locking [user] catalog tables vs 2pc vs logical rep 📎 [email protected] 22:48
RE: locking [user] catalog tables vs 2pc vs logical rep [email protected] 22:55

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

Browse Archives

Prev | Next