pgsql-hackers since 2020-07-12 00:11

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

July 12, 2020

Thread Author Time
Re: POC: postgres_fdw insert batching Tomas Vondra 00:11
StartupMessage parameters - free-form or not? Jaka Jančar 00:14
Re: Default setting for enable_hashagg_disk Tomas Vondra 00:30
Re: StartupMessage parameters - free-form or not? Tom Lane 00:43
Re: Default setting for enable_hashagg_disk Tom Lane 00:47
Re: StartupMessage parameters - free-form or not? Jaka Jančar 00:48
Re: proposal: possibility to read dumped table's name from file vignesh C 01:43
Re: Default setting for enable_hashagg_disk Peter Geoghegan 02:34
Re: Default setting for enable_hashagg_disk Thomas Munro 02:46
Re: Default setting for enable_hashagg_disk David G. Johnston 04:28
Re: Default setting for enable_hashagg_disk Tom Lane 04:37
Re: ALTER TABLE validate foreign key dependency problem 📎 David Rowley 04:50
Re: Default setting for enable_hashagg_disk David G. Johnston 05:26
Avoid useless retrieval of defaults and check constraints in pg_dump -a 📎 Julien Rouhaud 05:48
Re: Parallel copy Rafia Sabih 09:57
Re: Towards easier AMs: Cleaning up inappropriate use of name "relkind" Michael Paquier 11:59
Re: Parallel copy 📎 Bharath Rupireddy 12:18
Re: Default setting for enable_hashagg_disk Tomas Vondra 12:30
Re: Default setting for enable_hashagg_disk Tomas Vondra 12:36
Re: A patch for get origin from commit_ts. Michael Paquier 12:42
RE: Index Skip Scan (new UniqueKeys) 📎 Floris Van Nee 12:48
Re: [PATCH] Performance Improvement For Copy From Binary Files vignesh C 13:13
Re: calling procedures is slow and consumes extra much memory against calling function Pavel Stehule 13:18
Re: Avoid useless retrieval of defaults and check constraints in pg_dump -a Justin Pryzby 14:29
Re: Improving psql slash usage help message Tom Lane 15:15
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Dilip Kumar 16:26
Re: Online checksums verification in the backend 📎 Justin Pryzby 17:34
Re: [POC] Fast COPY FROM command for the table with foreign partitions 📎 Andrey Lepikhov 17:46
Re: explain HashAggregate to report bucket and memory stats Daniel Gustafsson 19:52
Re: Warn when parallel restoring a custom dump without data offsets 📎 Tom Lane 19:57
Re: should INSERT SELECT use a BulkInsertState? Daniel Gustafsson 20:04
Re: ALTER TABLE validate foreign key dependency problem Simon Riggs 20:12
Re: Parallel grouping sets Daniel Gustafsson 20:30
Re: Additional Chapter for Tutorial Daniel Gustafsson 20:45
Re: Libpq support to connect to standby server as priority Daniel Gustafsson 20:50
RE: Index Skip Scan (new UniqueKeys) 📎 Floris Van Nee 22:18
Re: [PATCH] Performance Improvement For Copy From Binary Files Thomas Munro 22:36
Re: WIP: BRIN multi-range indexes Alvaro Herrera 23:58

July 13, 2020

Thread Author Time
Re: WIP: BRIN multi-range indexes Tomas Vondra 00:14
Re: WIP: BRIN multi-range indexes Alvaro Herrera 00:33
Re: [PATCH] Performance Improvement For Copy From Binary Files 📎 Bharath Rupireddy 01:19
Re: Physical slot restart_lsn advances incorrectly requiring restore from archive Kyotaro Horiguchi 01:48
Re: should INSERT SELECT use a BulkInsertState? 📎 Justin Pryzby 01:57
Re: archive status ".ready" files may be created too early Kyotaro Horiguchi 01:57
Re: [PATCH] Performance Improvement For Copy From Binary Files 📎 Amit Langote 02:32
Re: [PATCH] Performance Improvement For Copy From Binary Files Bharath Rupireddy 03:16
Re: Creating a function for exposing memory usage of backend process Fujii Masao 04:00
Re: POC and rebased patch for CSN based snapshots Andrey V. Lepikhov 04:41
Re: Bug with indexes on whole-row expressions Ashutosh Bapat 04:42
Re: Retry Cached Remote Connections for postgres_fdw in case remote backend gets killed/goes away Ashutosh Bapat 04:43
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Amit Kapila 04:43
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Dilip Kumar 05:09
Re: max_slot_wal_keep_size and wal_keep_segments 📎 Fujii Masao 05:11
Re: max_slot_wal_keep_size and wal_keep_segments Fujii Masao 05:14
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Dilip Kumar 05:17
Re: GSSENC'ed connection stalls while reconnection attempts. Kyotaro Horiguchi 05:35
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Amit Kapila 05:39
Re: partition routing layering in nodeModifyTable.c 📎 Amit Langote 05:47
Re: WIP: BRIN multi-range indexes Masahiko Sawada 05:54
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Amit Kapila 06:00
Re: Don't choke on files that are removed while pg_rewind runs. Justin Pryzby 06:10
Re: Additional Chapter for Tutorial Jürgen Purtz 06:15
Re: proposal: possibility to read dumped table's name from file 📎 Pavel Stehule 06:15
Re: Don't choke on files that are removed while pg_rewind runs. Daniel Gustafsson 06:34
Re: POC and rebased patch for CSN based snapshots [email protected] 06:46
Re: Don't choke on files that are removed while pg_rewind runs. Masahiko Sawada 06:59
Re: max_slot_wal_keep_size and wal_keep_segments Kyotaro Horiguchi 07:01
Re: [PATCH] Performance Improvement For Copy From Binary Files Amit Langote 07:34
Re: OpenSSL 3.0.0 compatibility Peter Eisentraut 07:40
Re: Don't choke on files that are removed while pg_rewind runs. 📎 Michael Paquier 07:56
Re: Don't choke on files that are removed while pg_rewind runs. Daniel Gustafsson 08:12
Re: proposal: possibility to read dumped table's name from file 📎 Pavel Stehule 08:20
Re: Auto-vectorization speeds up multiplication of large-precision numerics Amit Khandekar 08:57
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Dilip Kumar 09:02
Re: Default setting for enable_hashagg_disk Amit Kapila 09:09
Re: DROP relation IF EXISTS Docs and Tests - Bug Fix Pavel Stehule 09:11
Re: DROP relation IF EXISTS Docs and Tests - Bug Fix Pavel Stehule 09:26
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Amit Kapila 09:26
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Dilip Kumar 09:34
Re: Stale external URL in doc? Daniel Gustafsson 09:36
Re: proposal: possibility to read dumped table's name from file Daniel Gustafsson 10:04
Re: [HACKERS] [COMMITTERS] pgsql: Remove pgbench "progress" test pending solution of its timing is (fwd) Daniel Gustafsson 10:21
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Amit Kapila 10:30
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Dilip Kumar 10:38
Re: INSERT INTO SELECT, Why Parallelism is not selected? Amit Kapila 10:53
Re: proposal: possibility to read dumped table's name from file Pavel Stehule 11:02
Re: Global snapshots Amit Kapila 11:18
Re: POC and rebased patch for CSN based snapshots Fujii Masao 11:18
Re: [HACKERS] make async slave to wait for lsn to be replayed Daniel Gustafsson 11:21
Re: Resetting spilled txn statistics in pg_stat_replication Amit Kapila 11:23
Re: [PATCH] Performance Improvement For Copy From Binary Files Bharath Rupireddy 11:34
Re: Default setting for enable_hashagg_disk Peter Eisentraut 11:51
Re: [Proposal] Global temporary tables wenjing zeng 11:59
Re: Default setting for enable_hashagg_disk David Rowley 12:16
Re: Don't choke on files that are removed while pg_rewind runs. Michael Paquier 12:18
Re: Additional Chapter for Tutorial Naresh gandi 12:20
Re: Policy on cross-posting to multiple lists Stephen Frost 12:21
Re: Additional Chapter for Tutorial Daniel Gustafsson 12:24
Editing errors in the comments of tableam.h and heapam.c 📎 Hironobu SUZUKI 12:25
Re: output columns of \dAo and \dAp 📎 Alexander Korotkov 12:44
Re: Editing errors in the comments of tableam.h and heapam.c Michael Paquier 12:52
Re: Binary support for pgoutput plugin 📎 Dave Cramer 13:11
Re: Default setting for enable_hashagg_disk Stephen Frost 13:13
Re: Default setting for enable_hashagg_disk Peter Eisentraut 13:13
Re: [PATCH] Performance Improvement For Copy From Binary Files vignesh C 13:20
Re: proposal: possibility to read dumped table's name from file vignesh C 13:32
Re: OpenSSL 3.0.0 compatibility Tom Lane 13:38
Commitfest 2020-07 almost halfway Daniel Gustafsson 14:07
Re: Default setting for enable_hashagg_disk Tomas Vondra 14:11
Re: Default setting for enable_hashagg_disk David Rowley 14:25
Re: proposal: possibility to read dumped table's name from file Justin Pryzby 14:32
Re: output columns of \dAo and \dAp Tom Lane 14:37
Re: Default setting for enable_hashagg_disk Jeff Davis 14:51
Re: pg_dump bug for extension owned tables 📎 Fabrízio de Royes Mello 14:52
Re: proposal: possibility to read dumped table's name from file Daniel Gustafsson 14:57
Re: [PATCH] Performance Improvement For Copy From Binary Files 📎 Bharath Rupireddy 14:58
Re: WIP: BRIN multi-range indexes Tomas Vondra 14:58
Re: [patch] demote 📎 Jehan-Guillaume de Rorthais 15:04
Re: GSSENC'ed connection stalls while reconnection attempts. Tom Lane 15:08
Re: Default setting for enable_hashagg_disk Peter Eisentraut 15:12
Re: [PATCH] fix GIN index search sometimes losing results Pavel Borisov 15:32
Re: proposal: possibility to read dumped table's name from file Pavel Stehule 15:33
Re: Default setting for enable_hashagg_disk Peter Geoghegan 16:20
Fix header identification 📎 Jesse Zhang 16:31
Re: Default setting for enable_hashagg_disk Alvaro Herrera 16:47
PostgreSQL 13 Beta 3 Release Date Jonathan S. Katz 16:53
Re: output columns of \dAo and \dAp Jonathan S. Katz 16:54
Re: output columns of \dAo and \dAp Alexander Korotkov 16:57
Re: min_safe_lsn column in pg_replication_slots view 📎 Alvaro Herrera 17:23
Re: Compatible defaults for LEAD/LAG Pavel Stehule 17:23
Re: pg_dump bug for extension owned tables 📎 Fabrízio de Royes Mello 17:37
Re: min_safe_lsn column in pg_replication_slots view Alvaro Herrera 17:52
Re: Report error position in partition bound check 📎 Alexandra Wang 17:53
Re: proposal: possibility to read dumped table's name from file 📎 Justin Pryzby 17:59
Re: Proposal: Automatic partition creation Anastasia Lubennikova 18:01
Re: Add MAIN_RELATION_CLEANUP and SECONDARY_RELATION_CLEANUP options to VACUUM 📎 Justin Pryzby 18:01
Re: pg_dump bug for extension owned tables Andrew Dunstan 18:29
Re: Default setting for enable_hashagg_disk Tom Lane 18:38
Re: Default setting for enable_hashagg_disk Justin Pryzby 18:43
Re: pg_dump bug for extension owned tables 📎 Fabrízio de Royes Mello 18:46
Re: Default setting for enable_hashagg_disk Peter Geoghegan 18:50
Re: Proposal: Automatic partition creation Tom Lane 19:01
Partitioning and postgres_fdw optimisations for multi-tenancy 📎 Alexey Kondratov 19:18
Re: Default setting for enable_hashagg_disk David G. Johnston 19:57
Re: pg_dump bug for extension owned tables Andrew Dunstan 20:05
Re: Default setting for enable_hashagg_disk Peter Geoghegan 20:12
Re: Default setting for enable_hashagg_disk Tom Lane 20:20
Re: Proposal: Automatic partition creation Anastasia Lubennikova 21:11
recovering from "found xmin ... from before relfrozenxid ..." Robert Haas 21:12
Re: Proposal: Automatic partition creation Anastasia Lubennikova 21:14
Re: pg_dump bug for extension owned tables Fabrízio de Royes Mello 21:18
Re: recovering from "found xmin ... from before relfrozenxid ..." Stephen Frost 21:28
Re: recovering from "found xmin ... from before relfrozenxid ..." Tom Lane 22:15
Re: recovering from "found xmin ... from before relfrozenxid ..." Peter Geoghegan 22:28
Re: DROP relation IF EXISTS Docs and Tests - Bug Fix 📎 David G. Johnston 22:37
Re: recovering from "found xmin ... from before relfrozenxid ..." Andres Freund 22:38
ALTER SYSTEM between upgrades Bruce Momjian 23:58

July 14, 2020

Thread Author Time
Re: Stale external URL in doc? Kyotaro Horiguchi 00:00
Re: Transactions involving multiple postgres foreign servers, take 2 Masahiro Ikeda 00:08
Re: Add MAIN_RELATION_CLEANUP and SECONDARY_RELATION_CLEANUP options to VACUUM 📎 Bossart, Nathan 00:25
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas 00:41
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas 00:47
Re: recovering from "found xmin ... from before relfrozenxid ..." Tom Lane 00:58
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas 01:03
Re: recovering from "found xmin ... from before relfrozenxid ..." Andres Freund 01:10
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas 01:13
Re: recovering from "found xmin ... from before relfrozenxid ..." Robert Haas 01:18
Re: recovering from "found xmin ... from before relfrozenxid ..." Tom Lane 01:26
Re: recovering from "found xmin ... from before relfrozenxid ..." Fujii Masao 01:29
Re: Ideas about a better API for postgres_fdw remote estimates Bruce Momjian 01:32
Re: [PATCH] Performance Improvement For Copy From Binary Files 📎 Amit Langote 01:56
Re: Retry Cached Remote Connections for postgres_fdw in case remote backend gets killed/goes away 📎 Bharath Rupireddy 01:57
Re: POC and rebased patch for CSN based snapshots [email protected] 02:02
Re: Transactions involving multiple postgres foreign servers, take 2 Fujii Masao 02:19
Re: Default setting for enable_hashagg_disk Amit Kapila 02:38
Re: POC and rebased patch for CSN based snapshots Fujii Masao 02:42
Re: Stale external URL in doc? 📎 Kyotaro Horiguchi 03:26
Re: Stale external URL in doc? Thomas Munro 03:40
Re: max_slot_wal_keep_size and wal_keep_segments 📎 Fujii Masao 04:00
Re: Editing errors in the comments of tableam.h and heapam.c Michael Paquier 04:21
Re: GSSENC'ed connection stalls while reconnection attempts. Kyotaro Horiguchi 04:31
Re: min_safe_lsn column in pg_replication_slots view Kyotaro Horiguchi 04:38
Re: Fix header identification Michael Paquier 04:41
Re: [PATCH] Performance Improvement For Copy From Binary Files vignesh C 05:01
Re: Stale external URL in doc? Kyotaro Horiguchi 05:03
Re: Improvements in Copy From vignesh C 05:06
Re: ALTER TABLE validate foreign key dependency problem David Rowley 05:10
Re: Improvements in Copy From David Rowley 05:22
Re: DROP relation IF EXISTS Docs and Tests - Bug Fix Pavel Stehule 05:25
Re: replication_origin and replication_origin_lsn usage on subscriber Dilip Kumar 05:30
Re: TAP tests and symlinks on Windows Michael Paquier 05:31
RE: Add MAIN_RELATION_CLEANUP and SECONDARY_RELATION_CLEANUP options to VACUUM [email protected] 05:34
Re: Improvements in Copy From David Rowley 05:43
Re: replication_origin and replication_origin_lsn usage on subscriber Amit Kapila 05:44
Re: [PATCH] Performance Improvement For Copy From Binary Files Amit Langote 05:49
Re: [PATCH] Incremental sort (was: PoC: Partial sort) Peter Geoghegan 05:59
Re: recovering from "found xmin ... from before relfrozenxid ..." Andrey M. Borodin 06:25
Re: proposal: possibility to read dumped table's name from file 📎 Pavel Stehule 06:31
Re: proposal: possibility to read dumped table's name from file Pavel Stehule 06:32
Re: replication_origin and replication_origin_lsn usage on subscriber Dilip Kumar 06:34

Browse Archives

Prev | Next