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

Thread	Author	Time
Re: sys_siglist[] is causing us trouble again 📎	Tom Lane	00:14
"cert" + clientcert=verify-ca in pg_hba.conf? 📎	Kyotaro Horiguchi	00:30
Re: Improving connection scalability: GetSnapshotData() 📎	Andres Freund	01:25
Re: Improving connection scalability: GetSnapshotData()	Alvaro Herrera	01:33
Re: Is it useful to record whether plans are generic or custom? 📎	torikoshia	02:50
Re: INSERT INTO SELECT, Why Parallelism is not selected? 📎	Amit Kapila	03:14
Re: Volatile Functions in Parallel Plans	Amit Kapila	04:07
Re: Transactions involving multiple postgres foreign servers, take 2	Masahiko Sawada	04:16
Re: Volatile Functions in Parallel Plans	Zhenghua Lyu	04:22
RE: Transactions involving multiple postgres foreign servers, take 2	[email protected]	04:53
Re: Partitioning and postgres_fdw optimisations for multi-tenancy	Etsuro Fujita	04:55
Re: renaming configure.in to configure.ac	Noah Misch	04:56
Re: Transactions involving multiple postgres foreign servers, take 2	Masahiko Sawada	05:47
Re: [Patch] ALTER SYSTEM READ ONLY	Prabhat Sahu	06:11
Re: Volatile Functions in Parallel Plans	Jesse Zhang	06:16
Re: gs_group_1 crashing on 13beta2/s390x	Andrew Gierth	06:42
How to identify trigger is called from the node where row is created	Satish S	06:45
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions	Dilip Kumar	06:52
Re: Resetting spilled txn statistics in pg_stat_replication 📎	Amit Kapila	06:53
Re: Resetting spilled txn statistics in pg_stat_replication	Masahiko Sawada	08:15
Re: OpenSSL 3.0.0 compatibility 📎	Peter Eisentraut	08:58
Re: [POC] Fast COPY FROM command for the table with foreign partitions 📎	Amit Langote	09:14
Re: Resetting spilled txn statistics in pg_stat_replication	Amit Kapila	09:16
Re: Which SET TYPE don't actually require a rewrite	Amit Kapila	09:32
Re: gs_group_1 crashing on 13beta2/s390x	Christoph Berg	09:33
Re: problem with RETURNING and update row movement	Amit Langote	09:38
Re: INSERT INTO SELECT, Why Parallelism is not selected?	Dilip Kumar	09:53
Encoding of src/timezone/tznames/Europe.txt	Christoph Berg	10:07
Re: TAP tests and symlinks on Windows	Michael Paquier	10:21
Re: Resetting spilled txn statistics in pg_stat_replication	Masahiko Sawada	10:33
Re: renaming configure.in to configure.ac	Dagfinn Ilmari Mannsåker	10:41
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎	Amit Kapila	10:55
Re: Resetting spilled txn statistics in pg_stat_replication	Amit Kapila	11:01
Re: OpenSSL 3.0.0 compatibility	Michael Paquier	11:45
Re: Partitioning and postgres_fdw optimisations for multi-tenancy	Andrey Lepikhov	11:56
Re: Volatile Functions in Parallel Plans	Zhenghua Lyu	11:57
Re: Stale external URL in doc? 📎	Daniel Gustafsson	12:09
Re: [Patch] ALTER SYSTEM READ ONLY	Robert Haas	13:10
Re: INSERT INTO SELECT, Why Parallelism is not selected?	Robert Haas	13:13
Re: sys_siglist[] is causing us trouble again	Andrew Dunstan	13:34
Re: Binary support for pgoutput plugin	Dave Cramer	13:58
Re: recovering from "found xmin ... from before relfrozenxid ..."	Robert Haas	14:00
Re: Include access method in listTables output 📎	Georgios	14:05
Re: [PATCH] Performance Improvement For Copy From Binary Files 📎	Amit Langote	14:14
Re: Encoding of src/timezone/tznames/Europe.txt	Tom Lane	14:24
Re: How to identify trigger is called from the node where row is created	David G. Johnston	14:45
Re: gs_group_1 crashing on 13beta2/s390x	Tom Lane	15:08
Re: Have SIGHUP instead of SIGTERM for config reload in logical replication launcher	Robert Haas	15:14
Re: Volatile Functions in Parallel Plans	Tom Lane	15:18
Re: [PATCH] Performance Improvement For Copy From Binary Files	Bharath Rupireddy	15:22
Re: renaming configure.in to configure.ac	Tom Lane	15:24
Re: renaming configure.in to configure.ac	Andrew Dunstan	15:36
Re: Volatile Functions in Parallel Plans	Jesse Zhang	15:40
Re: renaming configure.in to configure.ac	Tom Lane	15:43
Re: renaming configure.in to configure.ac	Andres Freund	15:48
Re: Volatile Functions in Parallel Plans	Tom Lane	15:57
Re: recovering from "found xmin ... from before relfrozenxid ..."	Robert Haas	16:14
Re: renaming configure.in to configure.ac	Tom Lane	16:17
Re: Partitioning and postgres_fdw optimisations for multi-tenancy	Etsuro Fujita	16:35
Re: Partitioning and postgres_fdw optimisations for multi-tenancy	Alexey Kondratov	16:40
Re: Infinities in type numeric	Tom Lane	16:43
Difference for Binary format vs Text format for client-server communication	Andy Fan	16:52
Re: Partitioning and postgres_fdw optimisations for multi-tenancy	Alexey Kondratov	16:56
Re: [PATCH] Performance Improvement For Copy From Binary Files	vignesh C	17:13
Re: Parallel copy 📎	vignesh C	17:13
Re: Using Valgrind to detect faulty buffer accesses (no pin or buffer content lock held)	Anastasia Lubennikova	17:24
Wrong results from in_range() tests with infinite offset 📎	Tom Lane	18:58
Re: calling procedures is slow and consumes extra much memory against calling function 📎	Pavel Stehule	19:08
NaN divided by zero should yield NaN 📎	Tom Lane	19:29
Re: new heapcheck contrib module	Robert Haas	19:38
Re: Encoding of src/timezone/tznames/Europe.txt	Christoph Berg	19:46
Re: Wrong results from in_range() tests with infinite offset 📎	Tom Lane	21:50
Improve Managing Databases Overview Doc Page 📎	David G. Johnston	21:55
[PATCH] Allow queries in WHEN expression of FOR EACH STATEMENT triggers 📎	Joe Wildish	22:22
Re: Physical slot restart_lsn advances incorrectly requiring restore from archive	Hsu, John	22:54
Re: psql FETCH_COUNT feature does not work with combined queries	David Johnston	23:08
Re: psql FETCH_COUNT feature does not work with combined queries	Alvaro Herrera	23:24
Re: [PATCH] Allow queries in WHEN expression of FOR EACH STATEMENT triggers	Daniel Gustafsson	23:32
Re: [DOC] Document concurrent index builds waiting on each other	David Johnston	23:33
Re: psql FETCH_COUNT feature does not work with combined queries	David G. Johnston	23:44
Re: Wrong results from in_range() tests with infinite offset	Dean Rasheed	23:47

July 17, 2020

Thread	Author	Time
Re: TAP tests and symlinks on Windows	Michael Paquier	00:15
Re: Wrong results from in_range() tests with infinite offset	Tom Lane	00:59
Re: Encoding of src/timezone/tznames/Europe.txt	Michael Paquier	01:16
Re: new heapcheck contrib module	Michael Paquier	01:25
Re: Transactions involving multiple postgres foreign servers, take 2	Masahiro Ikeda	02:06
Re: expose parallel leader in CSV and log_line_prefix	Michael Paquier	02:41
Re: [PATCH] Add support for choosing huge page size	Thomas Munro	02:42
Re: expose parallel leader in CSV and log_line_prefix	Alvaro Herrera	02:55
RE: Implement UNLOGGED clause for COPY FROM	[email protected]	03:04
Re: Transactions involving multiple postgres foreign servers, take 2	Masahiko Sawada	03:08
Re: Stale external URL in doc? 📎	Kyotaro Horiguchi	03:13
Re: Does TupleQueueReaderNext() really need to copy its result?	Thomas Munro	03:34
Re: Which SET TYPE don't actually require a rewrite	Noah Misch	03:40
Re: Partitioning and postgres_fdw optimisations for multi-tenancy	Andrey V. Lepikhov	04:23
Re: expose parallel leader in CSV and log_line_prefix	Michael Paquier	05:01
Re: Stale external URL in doc?	Michael Paquier	05:03
Re: Added tab completion for the missing options in copy statement	Michael Paquier	05:13
Re: Remove page-read callback from XLogReaderState.	Takashi Menjo	05:14
RE: Transactions involving multiple postgres foreign servers, take 2	[email protected]	05:21
Re: expose parallel leader in CSV and log_line_prefix	Julien Rouhaud	05:34
Re: Added tab completion for the missing options in copy statement 📎	Michael Paquier	05:45
Re: INSERT INTO SELECT, Why Parallelism is not selected?	Amit Kapila	05:54
Re: Have SIGHUP instead of SIGTERM for config reload in logical replication launcher	Amit Kapila	05:57
RE: Parallel Seq Scan vs kernel read ahead	[email protected]	06:05
Re: renaming configure.in to configure.ac	Noah Misch	06:29
Re: Transactions involving multiple postgres foreign servers, take 2	Laurenz Albe	06:49
Re: Transactions involving multiple postgres foreign servers, take 2	Masahiko Sawada	06:55
Re: Is it useful to record whether plans are generic or custom? 📎	Fujii Masao	07:25
Re: Parallel worker hangs while handling errors.	Bharath Rupireddy	07:51
RE: Transactions involving multiple postgres foreign servers, take 2	[email protected]	08:29
Re: Parallel copy 📎	vignesh C	08:39
Re: renaming configure.in to configure.ac 📎	Peter Eisentraut	08:46
Re: max_slot_wal_keep_size and wal_keep_segments	Fujii Masao	09:11
Re: Parallel Seq Scan vs kernel read ahead	Amit Kapila	09:18
Re: Additional Chapter for Tutorial 📎	Jürgen Purtz	09:32
Re: Implement UNLOGGED clause for COPY FROM	Amit Kapila	10:03
Allow ERROR from heap_prepare_freeze_tuple to be downgraded to WARNING 📎	Dilip Kumar	10:46
Re: renaming configure.in to configure.ac	Dagfinn Ilmari Mannsåker	10:58
Re: Transactions involving multiple postgres foreign servers, take 2	Masahiko Sawada	11:04
Re: max_slot_wal_keep_size and wal_keep_segments	David Steele	11:24
Re: [PATCH] Performance Improvement For Copy From Binary Files	Bharath Rupireddy	11:56
Re: Added tab completion for the missing options in copy statement 📎	vignesh C	11:58
Re: Retry Cached Remote Connections for postgres_fdw in case remote backend gets killed/goes away	Bharath Rupireddy	12:02
Re: Parallel copy	Ashutosh Sharma	13:48
Re: Which SET TYPE don't actually require a rewrite	Magnus Hagander	14:08
Re: renaming configure.in to configure.ac	Tom Lane	14:12
Re: WIP: System Versioned Temporal Table 📎	Surafel Temesgen	14:18
Re: renaming configure.in to configure.ac	Magnus Hagander	14:34
Add header support to text format and matching feature	Rémi Lapeyre	14:54
[PATCH v3 1/2] Add header support to "COPY TO" text format 📎	Rémi Lapeyre	14:54
[PATCH v3 2/2] Add header matching mode to "COPY FROM" 📎	Rémi Lapeyre	14:54
Re: Partitioning and postgres_fdw optimisations for multi-tenancy	Etsuro Fujita	14:55
Re: Encoding of src/timezone/tznames/Europe.txt	Tom Lane	15:06
Patch for reorderbuffer.c documentation. 📎	Dave Cramer	15:09
Re: Patch for reorderbuffer.c documentation.	David G. Johnston	15:16
Re: renaming configure.in to configure.ac	Tom Lane	15:18
Re: Which SET TYPE don't actually require a rewrite	Tom Lane	15:26
Re: Add header support to text format and matching feature	Magnus Hagander	15:27
Re: Patch for reorderbuffer.c documentation.	Dave Cramer	15:28
Re: expose parallel leader in CSV and log_line_prefix	Alvaro Herrera	15:35
Re: Partitioning and postgres_fdw optimisations for multi-tenancy	Ashutosh Bapat	15:44
Error during make, second install	David G. Johnston	15:58
Re: Error during make, second install	David G. Johnston	16:05
Re: Partitioning and postgres_fdw optimisations for multi-tenancy	Etsuro Fujita	16:30
Re: Transactions involving multiple postgres foreign servers, take 2	Fujii Masao	16:45
Re: Add header support to text format and matching feature 📎	Rémi Lapeyre	16:48
Re: Transactions involving multiple postgres foreign servers, take 2	Fujii Masao	16:55
Re: Warn when parallel restoring a custom dump without data offsets	Tom Lane	17:05
Re: Error during make, second install	Alvaro Herrera	17:16
Re: Encoding of src/timezone/tznames/Europe.txt	Christoph Berg	17:24
Re: Error during make, second install	Tom Lane	17:28
Re: NaN divided by zero should yield NaN	Dean Rasheed	18:08
Re: renaming configure.in to configure.ac	Andres Freund	18:53
Re: Binary support for pgoutput plugin	Tom Lane	18:55
Busted includes somewhere near worker_internal.h	Tom Lane	20:09
Re: Busted includes somewhere near worker_internal.h	Andres Freund	20:24
Re: SQL/JSON: functions 📎	Nikita Glukhov	20:26
Re: expose parallel leader in CSV and log_line_prefix	Justin Pryzby	20:54
Re: expose parallel leader in CSV and log_line_prefix	Alvaro Herrera	21:27
Re: renaming configure.in to configure.ac	Thomas Munro	22:00
Re: expose parallel leader in CSV and log_line_prefix	Justin Pryzby	22:32
Re: Change JOIN tutorial to focus more on explicit joins	Thomas Munro	23:48

July 18, 2020

Thread	Author	Time
pg_ctl behavior on Windows	Chapman Flack	00:03
Re: Default setting for enable_hashagg_disk	Jeff Davis	00:13
Re: Transactions involving multiple postgres foreign servers, take 2	Masahiro Ikeda	00:44
Re: Using Valgrind to detect faulty buffer accesses (no pin or buffer content lock held)	Peter Geoghegan	00:53
Re: Default setting for enable_hashagg_disk	Peter Geoghegan	01:38
Re: Encoding of src/timezone/tznames/Europe.txt	Michael Paquier	01:40
Re: Added tab completion for the missing options in copy statement 📎	Michael Paquier	02:38
Re: Which SET TYPE don't actually require a rewrite	Noah Misch	02:57
Re: [PATCH] Remove Extra palloc Of raw_buf For Binary Format In COPY FROM 📎	Bharath Rupireddy	04:38
Re: [PATCH] Remove Extra palloc Of raw_buf For Binary Format In COPY FROM	Tom Lane	05:03
Re: factorial function/phase out postfix operators?	John Naylor	08:00
Re: Wrong results from in_range() tests with infinite offset	Dean Rasheed	08:16
Re: Patch for reorderbuffer.c documentation.	Amit Kapila	09:15
Re: pg_ctl behavior on Windows	Amit Kapila	09:46
Re: Added tab completion for the missing options in copy statement	vignesh C	10:42
Re: Transactions involving multiple postgres foreign servers, take 2	Amit Kapila	11:03
Re: Added tab completion for the missing options in copy statement	Michael Paquier	11:06
Patch for nodeIncrementalSort comment correction. 📎	vignesh C	11:18
Re: Added tab completion for the missing options in copy statement	vignesh C	11:19
Re: Add header support to text format and matching feature	vignesh C	11:23
Re: pg_ctl behavior on Windows	Chapman Flack	13:00
Re: pg_ctl behavior on Windows	Andrew Dunstan	13:18
Re: SQL/JSON: functions	Andrew Dunstan	13:24
Re: Stale external URL in doc?	Michael Paquier	13:48
Re: Wrong results from in_range() tests with infinite offset	Tom Lane	14:06
CID 1428952 (#1 of 1): Out-of-bounds access (OVERRUN) (src/backend/commands/async.c)	Ranier Vilela	14:34
Re: Add header support to text format and matching feature 📎	Rémi Lapeyre	15:25
Re: WIP: System Versioned Temporal Table 📎	Rémi Lapeyre	16:05
Re: Binary support for pgoutput plugin 📎	Tom Lane	16:53
Re: Additional Chapter for Tutorial 📎	Erik Rijkers	17:17
Re: CID 1428952 (#1 of 1): Out-of-bounds access (OVERRUN) (src/backend/commands/async.c)	Tom Lane	17:21
Re: CID 1428952 (#1 of 1): Out-of-bounds access (OVERRUN) (src/backend/commands/async.c)	Ranier Vilela	17:53
pg_subscription.subslotname is wrongly marked NOT NULL	Tom Lane	18:15
Re: Default setting for enable_hashagg_disk	Jeff Davis	18:16
Re: CID 1428952 (#1 of 1): Out-of-bounds access (OVERRUN) (src/backend/commands/async.c)	Tom Lane	18:19
Re: Default setting for enable_hashagg_disk	Tom Lane	18:30
Re: Busted includes somewhere near worker_internal.h	Tom Lane	18:59

Browse Archives

Prev | Next