pgsql-hackers since 2020-11-30 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

Nov. 30, 2020

Thread Author Time
Re: should INSERT SELECT use a BulkInsertState? 📎 Justin Pryzby 01:11
Re: vac_update_datfrozenxid will raise "wrong tuple length" if pg_database tuple contains toast attribute. 📎 Michael Paquier 01:27
Re: autovac issue with large number of tables Masahiko Sawada 01:43
Re: Add docs stub for recovery.conf Craig Ringer 02:11
Re: Use standard SIGHUP and SIGTERM handlers in autoprewarm module Fujii Masao 02:12
Re: Printing LSN made easy Craig Ringer 02:12
Re: [sqlsmith] Planner error on lateral joins 📎 Tom Lane 02:18
Re: list of extended statistics on psql 📎 Tatsuro Yamada 02:19
Re: Add docs stub for recovery.conf Stephen Frost 02:25
Re: POC: postgres_fdw insert batching Craig Ringer 02:34
Re: Asynchronous Append on postgres_fdw nodes. Craig Ringer 02:45
Re: Implementing Incremental View Maintenance Yugo NAGATA 02:52
Re: Feature improvement for pg_stat_statements 📎 Seino Yuki 03:08
Fix typo in cost.h 📎 Tang, Haiying 03:15
Re: A few new options for CHECKPOINT Stephen Frost 03:21
RFC: extension_search_path to supplement dynamic_library_path Craig Ringer 03:23
Re: [patch] [doc] Minor variable related cleanup and rewording of plpgsql docs 📎 David G. Johnston 03:24
Re: Add Information during standby recovery conflicts Masahiko Sawada 03:41
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Amit Kapila 03:52
Re: Fix typo in cost.h Fujii Masao 03:56
Re: Improving spin-lock implementation on ARM. Krunal Bauskar 03:59
Notes on physical replica failover with logical publisher or subscriber Craig Ringer 03:59
[PATCH] fix compilation with gnu89 Rosen Penev 04:33
Re: Improving spin-lock implementation on ARM. Tom Lane 04:44
Re: [PATCH] fix compilation with gnu89 Andres Freund 04:49
Re: [PATCH] fix compilation with gnu89 Tom Lane 04:50
Re: Printing backtrace of postgres processes vignesh C 04:58
Re: Improving spin-lock implementation on ARM. Krunal Bauskar 05:02
Re: [PATCH] fix compilation with gnu89 Tom Lane 05:06
Re: Disable WAL logging to speed up data loading Kyotaro Horiguchi 05:07
Re: Parallel Inserts in CREATE TABLE AS 📎 Bharath Rupireddy 05:13
Re: Multi Inserts in CREATE TABLE AS - revived patch Bharath Rupireddy 05:18
Re: Printing backtrace of postgres processes Craig Ringer 05:35
Re: Removing unneeded self joins 📎 Andrey V. Lepikhov 05:50
Re: proposal: function pg_setting_value_split() to parse shared_preload_libraries etc. Craig Ringer 05:53
Re: BUG #16663: DROP INDEX did not free up disk space: idle connection hold file marked as deleted 📎 Thomas Munro 05:59
Re: Feature improvement for pg_stat_statements Fujii Masao 06:02
Re: Improving spin-lock implementation on ARM. Tom Lane 06:08
Re: Improving spin-lock implementation on ARM. Krunal Bauskar 06:19
Re: Is it useful to record whether plans are generic or custom? Tatsuro Yamada 06:24
Re: Disable WAL logging to speed up data loading Masahiko Sawada 06:45
Re: Is Recovery actually paused? Yugo NAGATA 06:45
Re: Add Information during standby recovery conflicts 📎 Drouvot, Bertrand 06:45
Re: [doc] remove reference to pg_dump pre-8.1 switch behaviour 📎 Michael Paquier 06:58
Re: Add Information during standby recovery conflicts Masahiko Sawada 07:26
[PATCH] BUG FIX: Core dump could happen when VACUUM FULL in standalone mode 📎 Yulin PEI 07:27
Re: Improving spin-lock implementation on ARM. Alexander Korotkov 07:46
Re: [patch] [doc] Minor variable related cleanup and rewording of plpgsql docs Pavel Stehule 07:51
obsolete comment from WITH OIDS days 📎 Amit Langote 08:21
Re: POC: postgres_fdw insert batching David Fetter 08:29
Re: obsolete comment from WITH OIDS days Heikki Linnakangas 08:32
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian 09:05
Re: Is Recovery actually paused? Dilip Kumar 09:10
RE: POC: postgres_fdw insert batching [email protected] 09:13
Re: [PATCH] BUG FIX: Core dump could happen when VACUUM FULL in standalone mode Masahiko Sawada 09:27
support IncrementalSortPath type in outNode() 📎 Hou, Zhijie 09:30
RE: POC: postgres_fdw insert batching [email protected] 09:34
Re: [PATCH] Keeps tracking the uniqueness with UniqueKey Heikki Linnakangas 10:04
回复: [PATCH] BUG FIX: Core dump could happen when VACUUM FULL in standalone mode 📎 Yulin PEI 11:07
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly Michael Paquier 11:33
Re: [HACKERS] [PATCH] Generic type subscripting Dmitry Dolgov 11:34
Re: pgbench - test whether a variable exists Fabien COELHO 11:53
Re: autovac issue with large number of tables Fujii Masao 11:59
Re: pgbench - test whether a variable exists Michael Paquier 12:24
Re: pgbench - test whether a variable exists Anastasia Lubennikova 12:28
Re: [PATCH] Runtime control of CLOBBER_CACHE_ALWAYS Anastasia Lubennikova 12:38
Re: pgbench - test whether a variable exists Fabien COELHO 12:40
Re: scram-sha-256 broken with FIPS and OpenSSL 1.0.2 Daniel Gustafsson 12:43
Re: pgbench - test whether a variable exists Fabien COELHO 12:45
Re: Printing LSN made easy Ashutosh Bapat 13:02
Re: OpenSSL 3.0.0 compatibility Daniel Gustafsson 13:05
Re: Printing LSN made easy Ashutosh Bapat 13:06
Re: [HACKERS] [PATCH] Generic type subscripting Alexander Korotkov 13:12
Re: scram-sha-256 broken with FIPS and OpenSSL 1.0.2 Michael Paquier 13:13
Re: proposal: unescape_text function Peter Eisentraut 13:14
Re: Improving spin-lock implementation on ARM. Alexander Korotkov 13:16
Re: Printing LSN made easy Ashutosh Bapat 13:18
Re: Printing LSN made easy Ashutosh Bapat 13:19
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Amit Kapila 13:20
Re: [HACKERS] [PATCH] Generic type subscripting Dmitry Dolgov 13:26
Re: scram-sha-256 broken with FIPS and OpenSSL 1.0.2 Daniel Gustafsson 13:29
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila 13:47
Re: Feature improvement for pg_stat_statements Seino Yuki 14:05
Re: [POC] Fast COPY FROM command for the table with foreign partitions Amit Langote 14:06
Re: Printing LSN made easy Li Japin 14:08
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly 📎 Alexey Kondratov 14:12
Re: Online verification of checksums Stephen Frost 14:27
Re: [PATCH] Keeps tracking the uniqueness with UniqueKey Jesper Pedersen 14:30
Re: Printing LSN made easy Alvaro Herrera 14:37
Re: A new function to wait for the backend exit after termination Muhammad Usama 14:39
Re: Index Skip Scan (new UniqueKeys) 📎 Heikki Linnakangas 14:42
Re: Asymmetric partition-wise JOIN Anastasia Lubennikova 14:43
Re: pgbench - test whether a variable exists Alvaro Herrera 14:48
Re: Improper use about DatumGetInt32 📎 Peter Eisentraut 14:50
Re: [patch] [doc] Minor variable related cleanup and rewording of plpgsql docs David G. Johnston 15:06
Re: [PATCH] Keeps tracking the uniqueness with UniqueKey Heikki Linnakangas 15:20
Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY Anastasia Lubennikova 15:22
Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY Alvaro Herrera 15:29
Re: Improper use about DatumGetInt32 Alvaro Herrera 15:32
Re: [patch] [doc] Minor variable related cleanup and rewording of plpgsql docs Pavel Stehule 15:37
Re: Dumping/restoring fails on inherited generated column Anastasia Lubennikova 15:37
Re: Feature improvement for pg_stat_statements Fujii Masao 16:04
Re: Autovacuum on partitioned table (autoanalyze) Alvaro Herrera 16:07
Cost overestimation of foreign JOIN 📎 Andrey Lepikhov 16:19
allow to \dtS+ pg_toast.* 📎 Justin Pryzby 16:54
Re: libpq compression 📎 Konstantin Knizhnik 16:58
Re: jit and explain nontext 📎 Justin Pryzby 16:59
Re: A few new options for CHECKPOINT Bossart, Nathan 17:17
Re: Re: parallel distinct union and aggregate support patch [email protected] 17:27
Re: Notes on physical replica failover with logical publisher or subscriber Alexey Kondratov 17:34
Re: Cost overestimation of foreign JOIN Tom Lane 17:38
Re: Autovacuum on partitioned table (autoanalyze) Alvaro Herrera 17:57
Re: Add Information during standby recovery conflicts Fujii Masao 17:59
Re: Add Information during standby recovery conflicts Fujii Masao 18:04
Re: Improving spin-lock implementation on ARM. Tom Lane 18:21
Re: Add Information during standby recovery conflicts Alvaro Herrera 18:25
Re: Add docs stub for recovery.conf Bruce Momjian 18:25
Re: Cost overestimation of foreign JOIN Andrey Lepikhov 18:26
Re: Add docs stub for recovery.conf David G. Johnston 18:31
Re: Improve handling of parameter differences in physical replication 📎 Peter Eisentraut 18:37
Re: Add docs stub for recovery.conf Bruce Momjian 18:42
Re: [PATCH] remove deprecated v8.2 containment operators Anastasia Lubennikova 18:51
Re: 回复: [PATCH] BUG FIX: Core dump could happen when VACUUM FULL in standalone mode 📎 Tom Lane 18:54
Re: [PATCH] remove deprecated v8.2 containment operators Tom Lane 19:03
Re: [PATCH] remove deprecated v8.2 containment operators Justin Pryzby 19:06
Re: [PATCH] remove deprecated v8.2 containment operators Tom Lane 19:09
Re: Add docs stub for recovery.conf David G. Johnston 19:13
Re: remove spurious CREATE INDEX CONCURRENTLY wait Alvaro Herrera 19:15
Re: range_agg Alexander Korotkov 19:35
Re: Change JOIN tutorial to focus more on explicit joins Anastasia Lubennikova 19:45
Re: Deleting older versions in unique indexes to avoid page splits 📎 Peter Geoghegan 19:50
{CREATE INDEX, REINDEX} CONCURRENTLY improvements 📎 Alvaro Herrera 19:54
Re: [DOC] Document concurrent index builds waiting on each other Anastasia Lubennikova 20:03
Re: [DOC] Document concurrent index builds waiting on each other Alvaro Herrera 20:05
Re: Change JOIN tutorial to focus more on explicit joins Jürgen Purtz 20:15
Re: [patch] [doc] Introduce view updating options more succinctly Anastasia Lubennikova 20:21
Re: Change JOIN tutorial to focus more on explicit joins David G. Johnston 20:25
Re: range_agg Alexander Korotkov 20:39
Re: [doc] remove reference to pg_dump pre-8.1 switch behaviour Tom Lane 20:46
Re: Improving spin-lock implementation on ARM. Alexander Korotkov 20:46
Re: Improving spin-lock implementation on ARM. Alexander Korotkov 21:01
Re: Printing LSN made easy Andres Freund 21:03
[BUG] orphaned function 📎 Drouvot, Bertrand 21:07
Re: proposal: unescape_text function Pavel Stehule 21:15
Re: support IncrementalSortPath type in outNode() Tom Lane 21:34
Re: [DOC] Document concurrent index builds waiting on each other 📎 Alvaro Herrera 21:52
Re: proposal: unescape_text function Pavel Stehule 21:56
runtime error copying oids field Zhihong Yu 22:29
Re: [BUG] orphaned function Tom Lane 22:29
Re: runtime error copying oids field Alvaro Herrera 23:01
Re: Printing backtrace of postgres processes Tom Lane 23:04
Re: 回复: [PATCH] BUG FIX: Core dump could happen when VACUUM FULL in standalone mode Masahiko Sawada 23:08
Re: runtime error copying oids field 📎 Zhihong Yu 23:24
Re: Add Information during standby recovery conflicts Masahiko Sawada 23:35
Re: Online verification of checksums David Steele 23:38
Re: error_severity of brin work item Alvaro Herrera 23:47

Dec. 1, 2020

Thread Author Time
Consider parallel for lateral subqueries with limit 📎 James Coleman 00:00
Re: Huge memory consumption on partitioned table with FKs Alvaro Herrera 00:03
Re: enable_incremental_sort changes query behavior James Coleman 00:08
Re: error_severity of brin work item Justin Pryzby 00:20
Re: [DOC] Document concurrent index builds waiting on each other James Coleman 00:29
Re: vac_update_datfrozenxid will raise "wrong tuple length" if pg_database tuple contains toast attribute. Ashwin Agrawal 00:37
Re: Huge memory consumption on partitioned table with FKs Kyotaro Horiguchi 00:40
Re: remove spurious CREATE INDEX CONCURRENTLY wait Michael Paquier 01:00
Re: Why does create_gather_merge_plan need make_sort? 📎 James Coleman 01:13
Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY Justin Pryzby 01:30
RE: Disable WAL logging to speed up data loading [email protected] 01:42
Re: VACUUM (DISABLE_PAGE_SKIPPING on) Masahiko Sawada 01:45
回复: 回复: [PATCH] BUG FIX: Core dump could happen when VACUUM FULL in standalone mode Yulin PEI 01:54
Re: Fix generate_useful_gather_paths for parallel unsafe pathkeys 📎 James Coleman 01:59
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian 02:25
Re: Huge memory consumption on partitioned table with FKs Corey Huinker 02:38
RE: [Patch] Optimize dropping of relation buffers using dlist [email protected] 02:46
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly 📎 Michael Paquier 02:46
Re: BUG #16663: DROP INDEX did not free up disk space: idle connection hold file marked as deleted Thomas Munro 02:48
Re: Huge memory consumption on partitioned table with FKs Tom Lane 02:48
Re: BUG #16663: DROP INDEX did not free up disk space: idle connection hold file marked as deleted Michael Paquier 02:55
Re: BUG #16663: DROP INDEX did not free up disk space: idle connection hold file marked as deleted Thomas Munro 03:06
Re: Printing backtrace of postgres processes Craig Ringer 03:11
Re: Improving spin-lock implementation on ARM. Krunal Bauskar 03:25
Re: Huge memory consumption on partitioned table with FKs Corey Huinker 03:25
Re: Printing backtrace of postgres processes Andres Freund 03:26
Re: Printing backtrace of postgres processes Andres Freund 03:31
Re: Printing backtrace of postgres processes Craig Ringer 03:33
Confusing behavior of psql's \e 📎 Laurenz Albe 03:38
Re: runtime error copying oids field Zhihong Yu 03:49
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila 03:54
Re: Printing backtrace of postgres processes Tom Lane 04:01
TAP test utility module 'PG_LSN.pm' 📎 Craig Ringer 04:03
PG vs LLVM 12 on seawasp, next round Thomas Munro 04:35
Re: autovac issue with large number of tables 📎 Kasahara Tatsuhito 04:48
Re: Add statistics to pg_stat_wal view for wal related parameter tuning 📎 Fujii Masao 05:01
Re: scram-sha-256 broken with FIPS and OpenSSL 1.0.2 📎 Michael Paquier 05:38
RE: [POC] Fast COPY FROM command for the table with foreign partitions [email protected] 05:39
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly Justin Pryzby 05:43
Re: proposal: unescape_text function Pavel Stehule 05:43
RE: [PATCH] Keeps tracking the uniqueness with UniqueKey Hou, Zhijie 05:45
Re: TAP test utility module 'PG_LSN.pm' Michael Paquier 05:58
Re: Improving spin-lock implementation on ARM. 📎 Tom Lane 06:01
Re: BUG #16663: DROP INDEX did not free up disk space: idle connection hold file marked as deleted Michael Paquier 06:01

Browse Archives

Prev | Next