pgsql-hackers since 2020-07-03 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

July 3, 2020

Thread	Author	Time
Re: WIP: BRIN multi-range indexes 📎	Tomas Vondra	00:57
Re: Persist MVCC forever - retain history	Mitar	00:58
Re: Additional improvements to extended statistics 📎	Tomas Vondra	01:10
Re: track_planning causing performance regression	Fujii Masao	01:56
Re: Default setting for enable_hashagg_disk 📎	Peter Geoghegan	02:05
Re: Add Information during standby recovery conflicts	Masahiko Sawada	02:20
Re: track_planning causing performance regression	Fujii Masao	02:39
Re: Persist MVCC forever - retain history	Jonah H. Harris	02:43
Re: track_planning causing performance regression	Peter Geoghegan	02:43
Re: Creating a function for exposing memory usage of backend process 📎	torikoshia	02:45
Re: Default setting for enable_hashagg_disk (hash_mem)	Justin Pryzby	02:46
Re: track_planning causing performance regression	Fujii Masao	02:48
Re: Persist MVCC forever - retain history	Mark Dilger	02:51
Re: estimation problems for DISTINCT ON with FDW	Etsuro Fujita	02:56
Re: Default setting for enable_hashagg_disk (hash_mem)	Bruce Momjian	02:58
Re: Default setting for enable_hashagg_disk (hash_mem)	Bruce Momjian	03:00
Re: POC and rebased patch for CSN based snapshots	Andrey V. Lepikhov	03:24
Re: Persist MVCC forever - retain history	Mitar	03:32
Re: Default setting for enable_hashagg_disk (hash_mem)	Peter Geoghegan	03:35
Re: Persist MVCC forever - retain history	Mitar	03:42
Re: Default setting for enable_hashagg_disk (hash_mem)	Peter Geoghegan	03:56
Re: track_planning causing performance regression	Pavel Stehule	04:05
Re: Read access for pg_monitor to pg_replication_origin_status view	Michael Paquier	05:03
Re: A patch for get origin from commit_ts.	Michael Paquier	05:10
Re: [POC] Fast COPY FROM command for the table with foreign partitions	Andrey V. Lepikhov	05:15
Re: POC: rational number type (fractions)	Peter Eisentraut	06:17
Re: POC: rational number type (fractions)	Joe Nelson	06:33
Re: Inlining of couple of functions in pl_exec.c improves performance	Amit Khandekar	06:41
Re: Global snapshots	Masahiko Sawada	06:48
Re: track_planning causing performance regression	Fujii Masao	06:57
Re: track_planning causing performance regression	Pavel Stehule	07:02
Re: SEARCH and CYCLE clauses 📎	Peter Eisentraut	07:08
Re: Persist MVCC forever - retain history	Konstantin Knizhnik	07:29
Re: max_slot_wal_keep_size and wal_keep_segments	Masahiko Sawada	07:54
Re: Cleanup - adjust the code crossing 80-column window limit	Peter Eisentraut	08:01
Re: Curious - "logical replication launcher" (PID) existed with exit code 1	Peter Eisentraut	08:06
Cleanup - Removed unused function parameter in reorder buffer & parallel vacuum 📎	vignesh C	08:07
Re: [PATCH] Finally split StdRdOptions into HeapOptions and ToastOptions 📎	Nikolay Shaplov	08:31
Re: Cleanup - Removed unused function parameter in reorder buffer & parallel vacuum	Simon Riggs	08:36
Re: Missing "Up" navigation link between parts and doc root? 📎	Peter Eisentraut	08:59
Parallel worker hangs while handling errors. 📎	vignesh C	09:10
Re: pgbench: option delaying queries till connections establishment?	Daniel Gustafsson	09:21
Re: WIP: Aggregation push-down 📎	Laurenz Albe	10:07
Re: proposal - psql - possibility to redirect only tabular output	Artur Zakirov	10:16
Re: Creating a function for exposing memory usage of backend process	Fujii Masao	10:33
Re: Cache lookup errors with functions manipulation object addresses	Daniel Gustafsson	10:34
Re: track_planning causing performance regression 📎	Fujii Masao	11:02
Re: Cleanup - Removed unused function parameter in reorder buffer & parallel vacuum	Masahiko Sawada	11:48
Re: Support for NSS as a libpq TLS backend 📎	Daniel Gustafsson	11:51
Re: estimation problems for DISTINCT ON with FDW	Etsuro Fujita	11:55
Re: Cleanup - Removed unused function parameter in reorder buffer & parallel vacuum	Amit Kapila	12:34
Re: Parallell hashjoin sometimes ignores temp_tablespaces	Magnus Hagander	13:13
Re: Missing "Up" navigation link between parts and doc root?	Tom Lane	13:45
Re: Cleanup - Removed unused function parameter in reorder buffer & parallel vacuum	Tom Lane	13:52
Re: Persist MVCC forever - retain history	Adam Brusselback	13:57
Re: warnings for invalid function casts	Peter Eisentraut	14:04
Re: Default setting for enable_hashagg_disk (hash_mem)	Bruce Momjian	14:08
Re: TAP tests and symlinks on Windows	Peter Eisentraut	14:11
Re: Parallell hashjoin sometimes ignores temp_tablespaces	Tom Lane	14:16
Re: warnings for invalid function casts	Tom Lane	14:40
Re: Default setting for enable_hashagg_disk (hash_mem)	Justin Pryzby	14:56
Re: Parallell hashjoin sometimes ignores temp_tablespaces 📎	Magnus Hagander	15:03
Re: Cache lookup errors with functions manipulation object addresses	Alvaro Herrera	15:04
Re: POC: rational number type (fractions)	Andrew Dunstan	15:43
Re: Parallell hashjoin sometimes ignores temp_tablespaces	Tom Lane	16:12
Re: Parallell hashjoin sometimes ignores temp_tablespaces	Magnus Hagander	16:17
Re: POC: rational number type (fractions)	Tom Lane	16:18
Re: Parallell hashjoin sometimes ignores temp_tablespaces 📎	Tom Lane	17:06
Re: Parallell hashjoin sometimes ignores temp_tablespaces	Magnus Hagander	18:54
pro pametniky -historie vzniku PL/SQL	Pavel Stehule	19:16
Re: pro pametniky -historie vzniku PL/SQL	Pavel Stehule	19:19
Re: Inlining of couple of functions in pl_exec.c improves performance 📎	Tom Lane	19:49
Re: Default setting for enable_hashagg_disk (hash_mem)	Alvaro Herrera	19:50
Re: Missing "Up" navigation link between parts and doc root?	Alvaro Herrera	19:57
Re: pro pametniky -historie vzniku PL/SQL	Jonah H. Harris	20:27
Re: Parallell hashjoin sometimes ignores temp_tablespaces	Tom Lane	21:02
Re: estimation problems for DISTINCT ON with FDW	Tom Lane	21:50

July 4, 2020

Thread	Author	Time
avoid bitmapOR-ing indexes with scan condition inconsistent with partition constraint 📎	Justin Pryzby	00:45
Ideas about a better API for postgres_fdw remote estimates	Tom Lane	03:08
Re: track_planning causing performance regression	Pavel Stehule	03:22
Re: proposal - psql - possibility to redirect only tabular output	Pavel Stehule	03:27
Re: A patch for get origin from commit_ts.	Movead Li	05:44
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎	Amit Kapila	06:04
Re: min_safe_lsn column in pg_replication_slots view	Amit Kapila	06:18
Re: pgbench: option delaying queries till connections establishment? 📎	Fabien COELHO	06:34
Re: Missing "Up" navigation link between parts and doc root?	Fabien COELHO	06:44
Re: Missing "Up" navigation link between parts and doc root?	Fabien COELHO	06:47
Re: Cleanup - Removed unused function parameter in reorder buffer & parallel vacuum	Amit Kapila	07:02
Re: Default setting for enable_hashagg_disk (hash_mem)	Amit Kapila	09:19
Re: A patch for get origin from commit_ts. 📎	movead.li@highgo.ca	10:01
Re: warnings for invalid function casts 📎	Peter Eisentraut	11:36
Re: new heapcheck contrib module	Dilip Kumar	13:04
Re: Resetting spilled txn statistics in pg_stat_replication	Ajin Cherian	13:13
Re: POC: rational number type (fractions)	Peter Eisentraut	13:29
Re: pg_read_file() with virtual files returns empty string	Joe Conway	13:53
Re: warnings for invalid function casts	Tom Lane	14:16
Re: POC and rebased patch for CSN based snapshots	movead.li@highgo.ca	14:56
Re: pg_read_file() with virtual files returns empty string	Justin Pryzby	16:39
Re: pg_read_file() with virtual files returns empty string	Tom Lane	16:52
Re: pg_read_file() with virtual files returns empty string	Joe Conway	17:10
Re: pg_read_file() with virtual files returns empty string	Joe Conway	17:50
Re: Postgres Windows build system doesn't work with python installed in Program Files	Juan José Santamaría Flecha	19:17
Re: Default setting for enable_hashagg_disk (hash_mem)	Jeff Davis	20:53

July 5, 2020

Thread	Author	Time
Re: Cleanup - Removed unused function parameter in reorder buffer & parallel vacuum 📎	vignesh C	00:59
Re: Include access method in listTables output	vignesh C	01:43
Re: Built-in connection pooler	Jaime Casanova	04:17
Re: Persist MVCC forever - retain history	Mitar	05:48
Re: suggest to rename enable_incrementalsort	Peter Eisentraut	10:20
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Dilip Kumar	11:05
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Dilip Kumar	11:17
Re: Parallell hashjoin sometimes ignores temp_tablespaces	Magnus Hagander	11:28
Re: proposal - function string_to_table 📎	Pavel Stehule	11:30
Re: doc: vacuum full, fillfactor, and "extra space"	Daniel Gustafsson	11:35
Re: psql - improve test coverage from 41% to 88%	Daniel Gustafsson	11:38
Re: [Patch] Invalid permission check in pg_stats for functional indexes	Daniel Gustafsson	11:44
Re: Online verification of checksums	Daniel Gustafsson	11:52
Re: TAP tests and symlinks on Windows	Andrew Dunstan	12:18
Re: proposal: schema variables 📎	Pavel Stehule	13:33
Re: Built-in connection pooler	Konstantin Knizhnik	13:46
Change a constraint's index - ALTER TABLE ... ALTER CONSTRAINT ... USING INDEX ... 📎	Anna Akenteva	14:02
Change a constraint's index - ALTER TABLE ... ALTER CONSTRAINT ... USING INDEX ... 📎	Anna Akenteva	14:12
Re: [Patch] Invalid permission check in pg_stats for functional indexes	Tom Lane	14:16
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎	Dilip Kumar	15:07
Re: Ideas about a better API for postgres_fdw remote estimates	Stephen Frost	17:06
Re: SQL/JSON: JSON_TABLE	Justin Pryzby	17:15
Re: range_agg	Justin Pryzby	17:20
Re: Inlining of couple of functions in pl_exec.c improves performance	Tom Lane	17:21
Re: SQL/JSON: functions	Justin Pryzby	17:29
Re: Persist MVCC forever - retain history	Konstantin Knizhnik	17:31
Re: Default gucs for EXPLAIN	Justin Pryzby	17:36
Re: Ideas about a better API for postgres_fdw remote estimates	Tom Lane	17:36
Re: Ideas about a better API for postgres_fdw remote estimates	Stephen Frost	17:48
Re: Persist MVCC forever - retain history	Thomas Kellerer	19:08
Re: range_agg 📎	Paul A Jungwirth	19:11
Re: range_agg	Paul A Jungwirth	19:25
Re: proposal: possibility to read dumped table's name from file 📎	Pavel Stehule	19:50
Re: proposal: possibility to read dumped table's name from file	Pavel Stehule	20:08
Re: Ideas about a better API for postgres_fdw remote estimates	Tom Lane	20:25
Re: proposal: possibility to read dumped table's name from file	Justin Pryzby	20:31
Re: [Patch] Invalid permission check in pg_stats for functional indexes	Daniel Gustafsson	20:32
Re: proposal: possibility to read dumped table's name from file	Pavel Stehule	20:37
Re: Binary support for pgoutput plugin	Daniel Gustafsson	20:40
Re: vacuum verbose detail logs are unclear; log at *start* of each stage	Daniel Gustafsson	20:48
Can I use extern "C" in an extension so I can use C++?	Isaac Morland	20:53
Re: Online checksums verification in the backend	Daniel Gustafsson	21:00
Re: Binary support for pgoutput plugin	Alvaro Herrera	21:11
Re: Binary support for pgoutput plugin	Daniel Gustafsson	21:28
Re: Can I use extern "C" in an extension so I can use C++? 📎	Tom Lane	22:07
Re: Can I use extern "C" in an extension so I can use C++? 📎	Isaac Morland	22:41
Re: Can I use extern "C" in an extension so I can use C++?	Tom Lane	22:49
Re: Default setting for enable_hashagg_disk (hash_mem)	Peter Geoghegan	23:47

July 6, 2020

Thread	Author	Time
Re: Postgres Windows build system doesn't work with python installed in Program Files	Michael Paquier	00:20
Re: A patch for get origin from commit_ts.	Michael Paquier	00:36
Re: Can I use extern "C" in an extension so I can use C++?	Isaac Morland	00:47
Re: TAP tests and symlinks on Windows	Michael Paquier	00:53
Re: Include access method in listTables output	Michael Paquier	01:12
Re: Creating a function for exposing memory usage of backend process 📎	torikoshia	03:12
Re: A patch for get origin from commit_ts. 📎	movead.li@highgo.ca	03:12
Re: Cleanup - adjust the code crossing 80-column window limit	Amul Sul	03:40
RE: archive status ".ready" files may be created too early	matsumura.ryo@fujitsu.com	04:02
Re: Cache lookup errors with functions manipulation object addresses	Michael Paquier	04:11
Re: Cleanup - adjust the code crossing 80-column window limit	Bharath Rupireddy	04:27
Re: proposal: possibility to read dumped table's name from file 📎	Pavel Stehule	04:34
"tuple concurrently updated" in pg_restore --jobs	Justin Pryzby	05:01
Re: proposal - function string_to_table 📎	Pavel Stehule	05:05
Re: archive status ".ready" files may be created too early	Kyotaro Horiguchi	05:13
Re: track_planning causing performance regression	Fujii Masao	05:29
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Amit Kapila	06:01
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Dilip Kumar	06:13
Re: Creating a function for exposing memory usage of backend process	Fujii Masao	06:16
Re: Add Information during standby recovery conflicts 📎	Drouvot, Bertrand	06:41
Re: Resetting spilled txn statistics in pg_stat_replication	Masahiko Sawada	07:36
Re: Cache lookup errors with functions manipulation object addresses 📎	Michael Paquier	07:45
Re: Include access method in listTables output 📎	Georgios	07:54
Re: A patch for get origin from commit_ts.	Michael Paquier	08:01
Re: proposal: schema variables 📎	Pavel Stehule	08:17
Performing partition pruning using row value	kato-sho@fujitsu.com	08:25
Re: Using Valgrind to detect faulty buffer accesses (no pin or buffer content lock held)	Georgios Kokolatos	08:34
Re: Asymmetric partition-wise JOIN 📎	Andrey V. Lepikhov	08:46
Re: Parallel copy 📎	vignesh C	09:27
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Amit Kapila	09:39
Re: Default setting for enable_hashagg_disk (hash_mem)	Amit Kapila	10:29
Re: Autovacuum on partitioned table (autoanalyze) 📎	yuzuko	10:35
Proposal: Automatic partition creation 📎	Anastasia Lubennikova	10:45
Re: Resetting spilled txn statistics in pg_stat_replication	Amit Kapila	11:45
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit	Bharath Rupireddy	11:49
Re: jsonpath versus NaN 📎	Alexander Korotkov	12:19
Re: Libpq support to connect to standby server as priority 📎	Greg Nancarrow	12:19
Re: WIP/PoC for parallel backup	Daniel Gustafsson	12:24
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit	Bharath Rupireddy	12:29
Re: Inlining of couple of functions in pl_exec.c improves performance	Amit Khandekar	12:29
Re: WIP/PoC for parallel backup	Hamid Akhtar	12:39
Re: Yet another fast GiST build (typo) 📎	Andrey M. Borodin	12:55
Re: Binary support for pgoutput plugin	Dave Cramer	12:58
Re: Binary support for pgoutput plugin	Daniel Gustafsson	13:03
Re: Is it useful to record whether plans are generic or custom?	Fujii Masao	13:16
Re: Binary support for pgoutput plugin	Dave Cramer	13:35
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit	Ashutosh Bapat	13:37
Re: Ideas about a better API for postgres_fdw remote estimates	Stephen Frost	14:11
Re: Cache lookup errors with functions manipulation object addresses	Alvaro Herrera	14:56

Browse Archives

Prev | Next