pgsql-hackers since 2020-11-20 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. 20, 2020

Thread	Author	Time
Re: Disable WAL logging to speed up data loading	Kyotaro Horiguchi	00:22
RE: Disable WAL logging to speed up data loading	[email protected]	00:32
[PATCH 1/1] Fix compilation on mac with Xcode >= 11.4.	James Hilliard	00:33
Re: scram-sha-256 broken with FIPS and OpenSSL 1.0.2	Michael Paquier	00:33
Re: Refactor pg_rewind code and make it work against a standby	Andres Freund	00:38
Re: [PATCH 1/1] Fix compilation on mac with Xcode >= 11.4.	Tom Lane	00:40
Re: [PATCH 1/1] Fix compilation on mac with Xcode >= 11.4.	James Hilliard	00:45
Re: Should we document IS [NOT] OF?	Joshua Drake	00:49
Re: error_severity of brin work item 📎	Justin Pryzby	00:51
Re: [PATCH 1/1] Fix compilation on mac with Xcode >= 11.4.	James Hilliard	01:02
Re: [PATCH 1/1] Fix compilation on mac with Xcode >= 11.4.	Tom Lane	01:04
RE: Disable WAL logging to speed up data loading	[email protected]	01:19
Re: VACUUM (DISABLE_PAGE_SKIPPING on)	Masahiko Sawada	01:39
Re: BUG #16663: DROP INDEX did not free up disk space: idle connection hold file marked as deleted	Nail Carpenter	01:50
Re: [PATCH 1/1] Fix compilation on mac with Xcode >= 11.4.	James Hilliard	01:55
Re: xid wraparound danger due to INDEX_CLEANUP false	Masahiko Sawada	01:57
RE: Terminate the idle sessions	[email protected]	02:05
Re: [PATCH 1/1] Fix compilation on mac with Xcode >= 11.4.	Tom Lane	02:20
Re: [HACKERS] logical decoding of two-phase transactions	Masahiko Sawada	02:24
Re: [PATCH 1/1] Fix compilation on mac with Xcode >= 11.4.	James Hilliard	02:30
Re: Move OpenSSL random under USE_OPENSSL_RANDOM	Michael Paquier	02:31
Re: [PATCH 1/1] Fix compilation on mac with Xcode >= 11.4.	Tom Lane	02:48
CreateProcess call failed: A blocking operation was interrupted by a call to WSACancelBlockingCall	江川潔	02:55
Re: [PATCH 1/1] Fix compilation on mac with Xcode >= 11.4.	James Hilliard	03:22
Re: [HACKERS] logical decoding of two-phase transactions	Ajin Cherian	03:42
Re: [HACKERS] logical decoding of two-phase transactions	Amit Kapila	03:45
Re: [HACKERS] logical decoding of two-phase transactions	Amit Kapila	03:49
Re: VACUUM (DISABLE_PAGE_SKIPPING on)	Masahiko Sawada	03:53
Re: xid wraparound danger due to INDEX_CLEANUP false	Peter Geoghegan	03:56
Re: [PATCH 1/1] Fix compilation on mac with Xcode >= 11.4.	Tom Lane	04:02
Re: [PATCH 1/1] Fix compilation on mac with Xcode >= 11.4.	James Hilliard	04:13
Re: Skip ExecCheckRTPerms in CTAS with no data	Michael Paquier	05:37
RE: CreateProcess call failed: A blocking operation was interrupted by a call to WSACancelBlockingCall	[email protected]	05:42
Re: [PATCH 1/1] Fix compilation on mac with Xcode >= 11.4.	Tom Lane	05:59
Re: Use macros for calculating LWLock offset	Michael Paquier	06:25
Re: don't allocate HashAgg hash tables when running explain only	Michael Paquier	06:31
Re: bad logging around broken restore_command	Fujii Masao	06:45
Re: Asynchronous Append on postgres_fdw nodes.	Kyotaro Horiguchi	06:51
Re: Protect syscache from bloating with negative cache entries	Kyotaro Horiguchi	07:08
Re: parsing pg_ident.conf	Fabien COELHO	07:19
Re: SQL-standard function body 📎	Peter Eisentraut	07:25
Re: Skip ExecCheckRTPerms in CTAS with no data	Peter Eisentraut	07:27
Re: Online verification of checksums	Michael Paquier	07:28
Re: Skip ExecCheckRTPerms in CTAS with no data	Peter Eisentraut	07:29
Re: Protect syscache from bloating with negative cache entries	Kyotaro Horiguchi	07:29
Re: Unnecessary delay in streaming replication due to replay lag	Michael Paquier	08:21
Re: Parallel INSERT (INTO ... SELECT ...) 📎	Greg Nancarrow	08:44
Re: Different results between PostgreSQL and Oracle for "for update" statement	Andy Fan	08:57
Re: Add Information during standby recovery conflicts 📎	Drouvot, Bertrand	09:17
Re: Skip ExecCheckRTPerms in CTAS with no data	Bharath Rupireddy	09:21
Re: Move OpenSSL random under USE_OPENSSL_RANDOM	Daniel Gustafsson	09:26
Re: Skip ExecCheckRTPerms in CTAS with no data 📎	Bharath Rupireddy	09:34
Re: VACUUM (DISABLE_PAGE_SKIPPING on)	Simon Riggs	10:15
Re: Use standard SIGHUP and SIGTERM handlers in autoprewarm module	Bharath Rupireddy	10:33
Re: VACUUM (DISABLE_PAGE_SKIPPING on) 📎	Simon Riggs	11:15
Re: Asynchronous Append on postgres_fdw nodes.	Kyotaro Horiguchi	11:16
Re: xid wraparound danger due to INDEX_CLEANUP false	Masahiko Sawada	11:16
Re: [HACKERS] logical decoding of two-phase transactions 📎	Ajin Cherian	11:23
Re: Asynchronous Append on postgres_fdw nodes.	Kyotaro Horiguchi	11:26
Re: VACUUM (DISABLE_PAGE_SKIPPING on) 📎	Simon Riggs	11:47
Re: a misbehavior of partition row movement (?) 📎	Amit Langote	11:55
RE: Disable WAL logging to speed up data loading 📎	[email protected]	12:47
Re: Move OpenSSL random under USE_OPENSSL_RANDOM	Magnus Hagander	12:59
Re: Improve handling of parameter differences in physical replication 📎	Peter Eisentraut	13:14
Re: don't allocate HashAgg hash tables when running explain only	Heikki Linnakangas	13:30
Re: parsing pg_ident.conf	Andrew Dunstan	13:31
Re: Different results between PostgreSQL and Oracle for "for update" statement	Andreas Karlsson	13:37
Re: VACUUM (DISABLE_PAGE_SKIPPING on)	Alvaro Herrera	14:07
Re: Refactor pg_rewind code and make it work against a standby	Heikki Linnakangas	14:19
Re: Different results between PostgreSQL and Oracle for "for update" statement	Andy Fan	14:25
Re: Keep elog(ERROR) and ereport(ERROR) calls in the cold path	Peter Eisentraut	14:26
Re: [bug+patch] Inserting DEFAULT into generated columns from VALUES RTE 📎	Dean Rasheed	14:30
Re: Add session statistics to pg_stat_database 📎	Laurenz Albe	14:41
Re: VACUUM (DISABLE_PAGE_SKIPPING on)	Simon Riggs	14:47
Re: Online verification of checksums	David Steele	14:50
Re: parsing pg_ident.conf	Fabien COELHO	14:54
Re: abstract Unix-domain sockets 📎	Peter Eisentraut	15:06
Re: Removal of currtid()/currtid2() and some table AM cleanup	Peter Eisentraut	15:14
Re: Issue with server side statement-level rollback 📎	Gilles Darold	15:18
Re: pg_dump, ATTACH, and independently restorable child partitions 📎	Justin Pryzby	15:20
Re: VACUUM (DISABLE_PAGE_SKIPPING on)	Alvaro Herrera	15:29
Re: VACUUM (DISABLE_PAGE_SKIPPING on)	Alvaro Herrera	15:33
Re: VACUUM (DISABLE_PAGE_SKIPPING on)	Robert Haas	15:38
Re: Prevent printing "next step instructions" in initdb and pg_upgrade	Peter Eisentraut	15:45
Re: Improve handling of parameter differences in physical replication	Sergei Kornilov	15:47
Re: Should we document IS [NOT] OF?	John Naylor	15:56
Re: jit and explain nontext	Peter Eisentraut	15:56
Re: xid wraparound danger due to INDEX_CLEANUP false	Robert Haas	15:59
Re: VACUUM (DISABLE_PAGE_SKIPPING on)	Alvaro Herrera	16:02
Re: Disable WAL logging to speed up data loading	Stephen Frost	16:03
Re: Online verification of checksums	Stephen Frost	16:08
Re: VACUUM (DISABLE_PAGE_SKIPPING on)	Robert Haas	16:09
Re: jit and explain nontext	Justin Pryzby	16:16
Re: [Patch] ALTER SYSTEM READ ONLY	Robert Haas	16:23
Re: [PATCH] remove pg_archivecleanup and pg_standby	Peter Eisentraut	16:26
Re: enable_incremental_sort changes query behavior	James Coleman	16:27
Re: Removal of currtid()/currtid2() and some table AM cleanup	Tom Lane	16:53
Re: enable_incremental_sort changes query behavior	Robert Haas	17:06
Re: Refactor pg_rewind code and make it work against a standby	Andres Freund	17:14
Re: abstract Unix-domain sockets	David G. Johnston	17:23
[patch] CLUSTER blocks scanned progress reporting 📎	Matthias van de Meent	17:32
Re: [Patch] ALTER SYSTEM READ ONLY	Amul Sul	17:43
Re: Probable documentation errors or improvements 📎	Щекин Ярослав	17:51
Re: [Proposal] Global temporary tables	Pavel Stehule	18:28
Re: enable_incremental_sort changes query behavior 📎	James Coleman	18:51
Re: xid wraparound danger due to INDEX_CLEANUP false	Peter Geoghegan	19:37
Re: enable_incremental_sort changes query behavior	Robert Haas	19:56
Re: xid wraparound danger due to INDEX_CLEANUP false	Robert Haas	20:04
Re: Strange behavior with polygon and NaN 📎	Tom Lane	20:57
Re: Refactor pg_rewind code and make it work against a standby	Heikki Linnakangas	21:09
Default role -> Predefined role 📎	Stephen Frost	21:13
Re: xid wraparound danger due to INDEX_CLEANUP false	Peter Geoghegan	21:21
Re: enable_incremental_sort changes query behavior	James Coleman	21:30
Re: Additional Chapter for Tutorial - arch-dev.sgml 📎	Erik Rijkers	21:52
Connection using ODBC and SSL	Corbit, Dann	21:54
Re: xid wraparound danger due to INDEX_CLEANUP false	Robert Haas	22:16
Re: scram-sha-256 broken with FIPS and OpenSSL 1.0.2	Daniel Gustafsson	22:17
Re: [HACKERS] Custom compression methods	Robert Haas	22:20
Why does create_gather_merge_plan need make_sort?	James Coleman	22:24
Re: Strange behavior with polygon and NaN 📎	Tom Lane	22:26
Re: xid wraparound danger due to INDEX_CLEANUP false	Peter Geoghegan	23:03
Re: Different results between PostgreSQL and Oracle for "for update" statement	Andreas Karlsson	23:03

Nov. 21, 2020

Thread	Author	Time
Re: Different results between PostgreSQL and Oracle for "for update" statement	Peter Geoghegan	01:04
Re: Removal of currtid()/currtid2() and some table AM cleanup	Michael Paquier	01:12
Re: scram-sha-256 broken with FIPS and OpenSSL 1.0.2	Michael Paquier	01:19
Re: Online verification of checksums	Michael Paquier	01:30
Fix generate_useful_gather_paths for parallel unsafe pathkeys 📎	James Coleman	01:55
Re: Removal of currtid()/currtid2() and some table AM cleanup	Tom Lane	02:50
Re: Removal of currtid()/currtid2() and some table AM cleanup 📎	Michael Paquier	05:45
Re: [doc] improve tableoid description	Peter Eisentraut	07:29
Re: jit and explain nontext	Peter Eisentraut	07:39
Re: Different results between PostgreSQL and Oracle for "for update" statement	Andy Fan	08:58
Re: Implement <null treatment> for window functions 📎	Krasiyan Andreev	09:07
Re: Skip ExecCheckRTPerms in CTAS with no data	Michael Paquier	10:50
Re: [HACKERS] logical decoding of two-phase transactions 📎	Amit Kapila	13:32
Re: Different results between PostgreSQL and Oracle for "for update" statement	Pavel Stehule	15:27
Re: jit and explain nontext	Justin Pryzby	16:26
Re: Connection using ODBC and SSL	Tom Lane	18:07
Re: Removal of currtid()/currtid2() and some table AM cleanup	Tom Lane	18:13
Re: Removal of currtid()/currtid2() and some table AM cleanup	Andres Freund	18:33
Re: Connection using ODBC and SSL	Andrew Dunstan	19:14
bug in pageinspect's "tuple data" feature 📎	Alvaro Herrera	19:32
Re: [PATCH] remove pg_standby 📎	Justin Pryzby	19:41
Re: Different results between PostgreSQL and Oracle for "for update" statement	Peter Geoghegan	21:55
Re: Strange behavior with polygon and NaN 📎	Tom Lane	22:33
Re: [PATCH] Covering SPGiST index	Tom Lane	23:27

Nov. 22, 2020

Thread	Author	Time
Re: Removal of currtid()/currtid2() and some table AM cleanup	Michael Paquier	02:09
Re: Different results between PostgreSQL and Oracle for "for update" statement	Andy Fan	02:29
Re: Different results between PostgreSQL and Oracle for "for update" statement	Andy Fan	02:35
Re: Removal of currtid()/currtid2() and some table AM cleanup	Tom Lane	02:39
Printing backtrace of postgres processes 📎	vignesh C	03:06
Re: Printing backtrace of postgres processes	Tom Lane	06:25
[PATCH 1/1] Initial mach based shared memory support.	James Hilliard	08:19
Re: Issue with server side statement-level rollback 📎	Gilles Darold	10:05
Re: Removal of currtid()/currtid2() and some table AM cleanup 📎	Michael Paquier	11:11
Parallel plans and "union all" subquery	Phil Florent	12:50
Re: Hybrid Hash/Nested Loop joins and caching results from subplans	Andy Fan	13:21
Re: Hybrid Hash/Nested Loop joins and caching results from subplans	Andy Fan	15:23
Re: More time spending with "delete pending"	Alexander Lakhin	15:59
Re: PoC/WIP: Extended statistics on expressions 📎	Tomas Vondra	19:03
Re: [bug+patch] Inserting DEFAULT into generated columns from VALUES RTE 📎	Tom Lane	20:58
Re: Why does create_gather_merge_plan need make_sort?	Tomas Vondra	21:22
Re: Why does create_gather_merge_plan need make_sort?	Tom Lane	21:31
Re: Fix generate_useful_gather_paths for parallel unsafe pathkeys	Tomas Vondra	21:59
Re: Why does create_gather_merge_plan need make_sort?	Tomas Vondra	22:07
Re: Bogus documentation for bogus geometric operators 📎	Tom Lane	23:52

Nov. 23, 2020

Thread	Author	Time
Re: [doc] improve tableoid description	Ian Lawrence Barwick	00:35
Re: [PoC] Non-volatile WAL buffer 📎	Tomas Vondra	01:22
Re: [PoC] Non-volatile WAL buffer	Tomas Vondra	02:01
RE: POC: postgres_fdw insert batching 📎	[email protected]	02:17
Re: PoC/WIP: Extended statistics on expressions 📎	Justin Pryzby	02:26
RE: [POC] Fast COPY FROM command for the table with foreign partitions	[email protected]	02:49
RE: Disable WAL logging to speed up data loading	[email protected]	03:17
RE: Disable WAL logging to speed up data loading	[email protected]	03:18
Re: PoC/WIP: Extended statistics on expressions	Tomas Vondra	03:30
Re: Parallel plans and "union all" subquery	Greg Nancarrow	05:04
Re: [Patch] ALTER SYSTEM READ ONLY 📎	Amul Sul	06:36
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit 📎	Bharath Rupireddy	06:48
Re: bug in pageinspect's "tuple data" feature	Heikki Linnakangas	07:11
Re: [POC] Fast COPY FROM command for the table with foreign partitions	Andrey Lepikhov	08:39
Re: Bogus documentation for bogus geometric operators	Pavel Borisov	09:09
Re: Multi Inserts in CREATE TABLE AS - revived patch 📎	Bharath Rupireddy	09:15
Re: Split copy.c	Heikki Linnakangas	09:17
Re: Bogus documentation for bogus geometric operators	Pavel Borisov	09:17
Re: [Proposal] Global temporary tables	曾文旌	09:27
Re: Multi Inserts in CREATE TABLE AS - revived patch 📎	Heikki Linnakangas	09:56
prion failed with ERROR: missing chunk number 0 for toast value 14334 in pg_toast_2619	Heikki Linnakangas	10:10
Re: [HACKERS] logical decoding of two-phase transactions	Ajin Cherian	10:11
Re: Multi Inserts in CREATE TABLE AS - revived patch 📎	Bharath Rupireddy	10:23
Re: Use of "long" in incremental sort code	Anastasia Lubennikova	11:11
Re: Parallel Inserts in CREATE TABLE AS 📎	Bharath Rupireddy	11:14
Re: [HACKERS] logical decoding of two-phase transactions	Amit Kapila	11:36
Re: Bogus documentation for bogus geometric operators	Pavel Borisov	11:44
Re: [HACKERS] Custom compression methods	Dilip Kumar	12:00
RE: Parallel plans and "union all" subquery	Phil Florent	12:17
Re: Online verification of checksums	Anastasia Lubennikova	12:53
Re: Why does create_gather_merge_plan need make_sort?	James Coleman	13:19
Re: Fix generate_useful_gather_paths for parallel unsafe pathkeys	James Coleman	13:35
Re: libpq compression	Daniil Zakhlystov	13:44
Re: abstract Unix-domain sockets	Peter Eisentraut	13:50

Browse Archives

Prev | Next