pgsql-hackers - July 2020

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

July 1, 2020

Thread	Author	Time
Deleting older versions in unique indexes to avoid page splits 📎	Peter Geoghegan	00:03
Re: max_slot_wal_keep_size and wal_keep_segments	Kyotaro Horiguchi	00:19
Re: Open Item: Should non-text EXPLAIN always show properties?	David Rowley	00:22
Re: Remove Deprecated Exclusive Backup Mode	Bruce Momjian	00:34
Re: min_safe_lsn column in pg_replication_slots view 📎	Kyotaro Horiguchi	01:32
Re: [PATCH] Better cleanup in TLS tests for -13beta2	michael	01:52
HashAgg's batching counter starts at 0, but Hash's starts at 1.	David Rowley	02:03
Re: max_slot_wal_keep_size and wal_keep_segments	Alvaro Herrera	03:26
Re: Intermittent BRIN failures on hyrax and lousyjack	Alvaro Herrera	03:28
v12 and TimeLine switches and backups/restores 📎	Stephen Frost	04:12
Re: Transactions involving multiple postgres foreign servers, take 2	Tatsuo Ishii	04:43
Re: POC: postgres_fdw insert batching	Ashutosh Bapat	04:47
Re: Creating a function for exposing memory usage of backend process 📎	torikoshia	05:48
Re: ModifyTable overheads in generic plans 📎	Amit Langote	06:30
Re: HashAgg's batching counter starts at 0, but Hash's starts at 1.	Jeff Davis	06:46
Cleanup - adjust the code crossing 80-column window limit 📎	Amul Sul	07:00
Re: Creating a function for exposing memory usage of backend process	Fujii Masao	07:43
Re: Remove Deprecated Exclusive Backup Mode	Laurenz Albe	08:00
Re: tar-related code in PostgreSQL	Daniel Gustafsson	08:15
Re: Control your disk usage in PG: Introduction to Disk Quota Extension	Daniel Gustafsson	08:36
Re: [Proposal] Add accumulated statistics for wait event	Daniel Gustafsson	08:41
Re: PATCH: add support for IN and @> in functional-dependency statistics use	Daniel Gustafsson	08:47
Re: Collation versioning 📎	Julien Rouhaud	08:52
Re: min_safe_lsn column in pg_replication_slots view	Amit Kapila	08:53
Re: Binary support for pgoutput plugin	Daniel Gustafsson	08:53
Re: PATCH: Add uri percent-encoding for binary data	Daniel Gustafsson	08:57
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit	Rushabh Lathia	09:03
Re: [PATCH v1] Allow COPY "text" to output a header and add header matching mode to COPY FROM	Daniel Gustafsson	09:04
Re: Asymmetric partition-wise JOIN	Daniel Gustafsson	09:10
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit	Bharath Rupireddy	09:14
Re: Parallel copy 📎	vignesh C	09:16
Re: [HACKERS] Cached plans and statement generalization	Daniel Gustafsson	09:18
Re: Ought to use heap_multi_insert() for pg_attribute/depend insertions? 📎	michael	09:24
Re: Autovacuum on partitioned table (autoanalyze)	Daniel Gustafsson	09:26
Re: Built-in connection pooler	Daniel Gustafsson	09:30
Re: [PATCH] Performance Improvement For Copy From Binary Files	Bharath Rupireddy	09:33
Re: COPY FREEZE and setting PD_ALL_VISIBLE/visibility map bits	Daniel Gustafsson	09:38
Re: Towards easier AMs: Cleaning up inappropriate use of name "relkind"	Daniel Gustafsson	09:45
Re: ModifyTable overheads in generic plans	Daniel Gustafsson	09:50
Re: partition routing layering in nodeModifyTable.c	Daniel Gustafsson	09:56
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit	Rushabh Lathia	10:02
Re: [patch] demote	Jehan-Guillaume de Rorthais	10:15
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit	Bharath Rupireddy	10:23
Re: Binary support for pgoutput plugin	Dave Cramer	10:43
Re: Cleanup - adjust the code crossing 80-column window limit	Bharath Rupireddy	10:59
Re: estimation problems for DISTINCT ON with FDW	Etsuro Fujita	11:06
Re: Additional improvements to extended statistics	Daniel Gustafsson	11:19
Re: [PATCH] Support built control file in PGXS VPATH builds	Daniel Gustafsson	11:34
Re: Creating a function for exposing memory usage of backend process	Daniel Gustafsson	11:47
Re: Yet another fast GiST build (typo)	Daniel Gustafsson	12:05
Re: Identifying user-created objects	Daniel Gustafsson	12:15
Re: Implement <null treatment> for window functions	Daniel Gustafsson	12:27
Re: Make MemoryContextMemAllocated() more precise	Daniel Gustafsson	12:34
Re: Improving connection scalability: GetSnapshotData()	Daniel Gustafsson	12:42
Improvements in Copy From 📎	vignesh C	12:46
Re: Remove Deprecated Exclusive Backup Mode	Stephen Frost	12:47
Re: WIP: expression evaluation improvements	Daniel Gustafsson	12:50
Re: max_slot_wal_keep_size and wal_keep_segments	Fujii Masao	12:50
Re: Cleanup - adjust the code crossing 80-column window limit	Amul Sul	12:52
Re: Add Information during standby recovery conflicts 📎	Drouvot, Bertrand	12:52
Re: Creating a function for exposing memory usage of backend process	torikoshia	13:15
Re: Creating a function for exposing memory usage of backend process	torikoshia	13:18
Re: track_planning causing performance regression	Fujii Masao	13:20
Re: Ltree syntax improvement	Daniel Gustafsson	13:23
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit	Ashutosh Bapat	13:24
Re: SQL-standard function body	Robert Haas	13:36
Re: ModifyTable overheads in generic plans 📎	Amit Langote	13:38
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit	Masahiko Sawada	13:42
Re: Creating a function for exposing memory usage of backend process	Fujii Masao	13:58
Re: SQL-standard function body	Pavel Stehule	14:07
Re: SQL-standard function body	Tom Lane	14:14
Re: SQL-standard function body	Pavel Stehule	14:19
Re: estimation problems for DISTINCT ON with FDW	Tom Lane	14:40
Re: Remove Deprecated Exclusive Backup Mode	Laurenz Albe	14:46
Re: Remove Deprecated Exclusive Backup Mode	Stephen Frost	14:50
Re: max_slot_wal_keep_size and wal_keep_segments	Alvaro Herrera	14:54
Re: PATCH: Add uri percent-encoding for binary data	Alvaro Herrera	14:58
Re: Collation versioning 📎	Julien Rouhaud	15:03
Re: min_safe_lsn column in pg_replication_slots view	Alvaro Herrera	15:14
Re: Remove Deprecated Exclusive Backup Mode	Bruce Momjian	15:30
Re: Remove Deprecated Exclusive Backup Mode	Stephen Frost	15:33
[PATCH] audo-detect and use -moutline-atomics compilation flag for aarch64 📎	Zidenberg, Tsahi	15:40
Re: SQL-standard function body	Bruce Momjian	15:42
Re: Remove Deprecated Exclusive Backup Mode	Magnus Hagander	15:48
Re: Remove Deprecated Exclusive Backup Mode	Stephen Frost	16:29
Re: Towards easier AMs: Cleaning up inappropriate use of name "relkind" 📎	Mark Dilger	16:46
Re: [bug] Table not have typarray when created by single user mode 📎	Tom Lane	16:47
Re: SQL-standard function body	Tom Lane	16:50
Re: Remove Deprecated Exclusive Backup Mode	Magnus Hagander	16:54
Re: track_planning causing performance regression	Andres Freund	16:54
Re: max_slot_wal_keep_size and wal_keep_segments	David Steele	17:18
Re: Remove Deprecated Exclusive Backup Mode	Stephen Frost	17:23
Re: proposal - plpgsql - FOR over unbound cursor	Tom Lane	18:06
Re: SQL-standard function body	Vik Fearing	18:19
Re: POC: postgres_fdw insert batching	Andres Freund	18:34
Re: [PATCH] fix GIN index search sometimes losing results	Tom Lane	19:16
Re: SQL-standard function body	Pavel Stehule	19:32
Re: Remove Deprecated Exclusive Backup Mode	Robert Haas	19:43
Re: max_slot_wal_keep_size and wal_keep_segments	Bruce Momjian	19:45
Re: Remove Deprecated Exclusive Backup Mode	Bruce Momjian	19:47
Re: Remove Deprecated Exclusive Backup Mode	Magnus Hagander	19:49
Re: Remove Deprecated Exclusive Backup Mode	Stephen Frost	19:50
Re: v12 and TimeLine switches and backups/restores	Robert Haas	19:51
Re: Remove Deprecated Exclusive Backup Mode	Robert Haas	19:58
Re: v12 and TimeLine switches and backups/restores	Stephen Frost	20:02
Re: v12 and TimeLine switches and backups/restores	Robert Haas	20:08
Re: POC: rational number type (fractions)	Andrew Dunstan	20:09
Re: pg_read_file() with virtual files returns empty string 📎	Tom Lane	20:12
Re: v12 and TimeLine switches and backups/restores	Stephen Frost	20:19
Re: Remove Deprecated Exclusive Backup Mode	Magnus Hagander	20:24
Re: max_slot_wal_keep_size and wal_keep_segments	Alvaro Herrera	20:25
Re: proposal - plpgsql - FOR over unbound cursor	Pavel Stehule	20:26
Re: Remove Deprecated Exclusive Backup Mode	David Steele	20:27
Re: Remove Deprecated Exclusive Backup Mode	Bruce Momjian	20:29
Re: SQL-standard function body	Vik Fearing	20:31
Re: POC: rational number type (fractions)	Stephen Frost	20:32
Re: Remove Deprecated Exclusive Backup Mode	Bruce Momjian	20:32
Re: max_slot_wal_keep_size and wal_keep_segments	Bruce Momjian	20:33
Re: Remove Deprecated Exclusive Backup Mode	Robert Haas	20:34
Re: SQL-standard function body	Pavel Stehule	20:34
Re: Remove Deprecated Exclusive Backup Mode	David Steele	20:34
Re: Remove Deprecated Exclusive Backup Mode	Robert Haas	20:36
Re: Remove Deprecated Exclusive Backup Mode	Magnus Hagander	20:39
Re: proposal - psql - use pager for \watch command	Tom Lane	20:41
Re: Remove Deprecated Exclusive Backup Mode	Stephen Frost	20:46
Re: Remove Deprecated Exclusive Backup Mode	Bruce Momjian	20:46
Re: v12 and TimeLine switches and backups/restores	Michael Banck	20:48
Re: SQL-standard function body	Vik Fearing	20:54
Re: [Patch] Add missing libraries to Libs.private of libpq.pc	Tom Lane	20:54
Re: v12 and TimeLine switches and backups/restores	Stephen Frost	20:57
Re: proposal - psql - use pager for \watch command	Pavel Stehule	21:03
Re: SQL-standard function body	Pavel Stehule	21:04
Re: Remove Deprecated Exclusive Backup Mode	David Steele	21:08
Re: pg_read_file() with virtual files returns empty string	Joe Conway	21:17
Re: Remove Deprecated Exclusive Backup Mode	David Steele	21:20
Re: proposal: possibility to read dumped table's name from file	Justin Pryzby	21:24
Re: Remove Deprecated Exclusive Backup Mode	Bruce Momjian	21:25
Adding Support for Copy callback functionality on COPY TO api 📎	Sanaba, Bilva	21:41
Re: pg_read_file() with virtual files returns empty string	Joe Conway	21:43
Re: Remove Deprecated Exclusive Backup Mode	Magnus Hagander	21:44
Re: Inlining of couple of functions in pl_exec.c improves performance 📎	Tom Lane	22:17
Re: pg_read_file() with virtual files returns empty string	Tom Lane	22:22
Re: POC: rational number type (fractions)	Tom Lane	22:40
Re: SQL-standard function body	Thomas Munro	22:56
Re: POC: rational number type (fractions)	Stephen Frost	23:00
Re: Remove Deprecated Exclusive Backup Mode	Jehan-Guillaume de Rorthais	23:06
Re: SQL-standard function body	Tom Lane	23:54

July 2, 2020

Thread	Author	Time
Re: Towards easier AMs: Cleaning up inappropriate use of name "relkind" 📎	Mark Dilger	00:04
Re: min_safe_lsn column in pg_replication_slots view	michael	01:38
Re: min_safe_lsn column in pg_replication_slots view	Alvaro Herrera	01:46
Re: A patch for get origin from commit_ts.	michael	01:50
Re: A patch for get origin from commit_ts.	michael	01:58
Re: Asynchronous Append on postgres_fdw nodes. 📎	Kyotaro Horiguchi	02:14
Re: estimation problems for DISTINCT ON with FDW	Etsuro Fujita	02:46
Re: WIP: WAL prefetch (another approach)	Thomas Munro	03:09
Re: Asynchronous Append on postgres_fdw nodes.	Etsuro Fujita	03:20
Re: Resetting spilled txn statistics in pg_stat_replication 📎	Masahiko Sawada	03:30
Re: Backpatch b61d161c14 (Introduce vacuum errcontext ...)	Amit Kapila	03:37
Re: Speedup usages of pg_*toa() functions	John Naylor	03:57
Re: Remove page-read callback from XLogReaderState. 📎	Kyotaro Horiguchi	04:53
Re: Rotten parts of src/backend/replication/README	Michael Paquier	05:03
Re: Cache lookup errors with functions manipulation object addresses 📎	Michael Paquier	05:35
Re: Cleanup - adjust the code crossing 80-column window limit	Bharath Rupireddy	05:38
Re: SQL-standard function body	Pavel Stehule	05:47
Re: Threading in BGWorkers (!) 📎	James Sewell	06:39
Re: A patch for get origin from commit_ts.	Simon Riggs	07:52
Re: A patch for get origin from commit_ts.	Petr Jelinek	08:12
Re: Remove Deprecated Exclusive Backup Mode	Laurenz Albe	08:35
Re: Remove Deprecated Exclusive Backup Mode	Magnus Hagander	10:32
Re: Remove Deprecated Exclusive Backup Mode	Magnus Hagander	10:41
Re: Hybrid Hash/Nested Loop joins and caching results from subplans 📎	David Rowley	10:57
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit 📎	Bharath Rupireddy	10:59
Re: Remove Deprecated Exclusive Backup Mode	David Steele	11:12
Re: [PATCH] fix GIN index search sometimes losing results 📎	Pavel Borisov	11:23
Re: Built-in connection pooler 📎	Konstantin Knizhnik	11:33
Re: MultiXact\SLRU buffers configuration	Daniel Gustafsson	12:02
Re: Remove Deprecated Exclusive Backup Mode	Jehan-Guillaume de Rorthais	12:06
Re: Libpq support to connect to standby server as priority	Daniel Gustafsson	12:12
Re: [PATCH] Initial progress reporting for COPY command 📎	Daniel Gustafsson	12:25
Re: WIP: Aggregation push-down	Daniel Gustafsson	12:39
Re: [PATCH] Initial progress reporting for COPY command	Josef Šimánek	12:42
Re: [PATCH] Initial progress reporting for COPY command	Daniel Gustafsson	12:51
Re: POC: rational number type (fractions)	Andrew Dunstan	12:59
Re: Read access for pg_monitor to pg_replication_origin_status view	Daniel Gustafsson	13:03
Re: Recognizing superuser in pg_hba.conf	Daniel Gustafsson	13:14
Re: Recognizing superuser in pg_hba.conf	Vik Fearing	13:21
Re: Reducing WaitEventSet syscall churn	Daniel Gustafsson	13:29
Re: Report error position in partition bound check	Daniel Gustafsson	13:39
Re: Remove Deprecated Exclusive Backup Mode	Stephen Frost	13:46
Re: Remove Deprecated Exclusive Backup Mode	Stephen Frost	13:52
Re: POC: rational number type (fractions)	Tom Lane	14:01
Re: Let people set host(no)ssl settings from initdb	Daniel Gustafsson	14:02
Re: [PATCH] Finally split StdRdOptions into HeapOptions and ToastOptions	Daniel Gustafsson	14:15
Re: POC: rational number type (fractions)	Stephen Frost	14:21
Re: Auxiliary Processes and MyAuxProc	Daniel Gustafsson	14:26
Re: POC and rebased patch for CSN based snapshots	Movead Li	14:31
Re: [Patch] Use internal pthreads reimplementation only when building with MSVC 📎	Daniel Gustafsson	14:35
Re: TRUNCATE on foreign tables	Daniel Gustafsson	14:40
Re: Built-in connection pooler	Daniel Gustafsson	14:44
Re: estimation problems for DISTINCT ON with FDW	Tom Lane	14:46

Browse Archives

Prev | Next