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

Oct. 3, 2020

Thread	Author	Time
Re: Parallel copy	Tomas Vondra	00:49
Re: Improve choose_custom_plan for initial partition prune case	Andy Fan	02:05
Re: a misbehavior of partition row movement (?)	Amit Langote	02:42
Re: "cert" + clientcert=verify-ca in pg_hba.conf?	Bruce Momjian	02:55
Re: Logical replication CPU-bound with TRUNCATE/DROP/CREATE many tables	Dilip Kumar	02:59
Re: enable_incremental_sort changes query behavior 📎	James Coleman	03:16
Re: Resetting spilled txn statistics in pg_stat_replication	Masahiko Sawada	03:56
Re: [PATCH] Add section headings to index types doc	Jürgen Purtz	04:59
Add primary keys to system catalogs 📎	Peter Eisentraut	06:40
Re: Incorrect assumption in heap_prepare_freeze_tuple	Kuntal Ghosh	07:28
Re: Incorrect assumption in heap_prepare_freeze_tuple	Andres Freund	07:36
Re: Resetting spilled txn statistics in pg_stat_replication 📎	Amit Kapila	07:55
Re: Parallel copy	Amit Kapila	10:15
POC: contrib/unaccent as IMMUTABLE	Petru Ghita	10:53
Re: VACUUM PARALLEL option vs. max_parallel_maintenance_workers	Amit Kapila	11:03
Re: a misbehavior of partition row movement (?)	Tomas Vondra	11:15
Re: a misbehavior of partition row movement (?)	Amit Langote	11:26
Re: Retry Cached Remote Connections for postgres_fdw in case remote backend gets killed/goes away 📎	Bharath Rupireddy	11:40
RE: POC: contrib/unaccent as IMMUTABLE	Petru Ghita	12:13
Re: POC: contrib/unaccent as IMMUTABLE	Tomas Vondra	13:01
Re: enable_incremental_sort changes query behavior	James Coleman	13:15
Re: VACUUM PARALLEL option vs. max_parallel_maintenance_workers	Masahiko Sawada	13:25
Re: Add primary keys to system catalogs	Craig Ringer	13:27
Re: Incorrect assumption in heap_prepare_freeze_tuple	Kuntal Ghosh	14:27
Re: enable_incremental_sort changes query behavior 📎	James Coleman	14:50
Re: enable_incremental_sort changes query behavior 📎	Jaime Casanova	14:54
Re: <xref> vs <command> formatting in the docs	Peter Eisentraut	14:57
Re: POC: contrib/unaccent as IMMUTABLE	Alexander Korotkov	15:14
Re: POC: contrib/unaccent as IMMUTABLE	Tom Lane	15:19
Re: POC: contrib/unaccent as IMMUTABLE	Tom Lane	15:37
Re: buildfarm animal shoveler failing with "Illegal instruction"	Tom Lane	15:55
Re: <xref> vs <command> formatting in the docs	Bruce Momjian	16:33
Re: Add primary keys to system catalogs	Bruce Momjian	17:23
Re: Add primary keys to system catalogs	John Naylor	17:31
Re: Incorrect assumption in heap_prepare_freeze_tuple	Andres Freund	19:03
Re: POC: contrib/unaccent as IMMUTABLE	Alexander Korotkov	20:13
Re: Optimize memory allocation code	Tomas Vondra	20:57
Re: Add header support to text format and matching feature 📎	Rémi Lapeyre	21:42
Re: enable_incremental_sort changes query behavior	Tomas Vondra	21:44
Re: terminate called after throwing an instance of 'std::bad_alloc'	Justin Pryzby	22:02
Re: terminate called after throwing an instance of 'std::bad_alloc'	Andres Freund	23:01
Re: terminate called after throwing an instance of 'std::bad_alloc'	Justin Pryzby	23:30

Oct. 4, 2020

Thread	Author	Time
Re: terminate called after throwing an instance of 'std::bad_alloc'	Andres Freund	02:01
Re: enable_incremental_sort changes query behavior 📎	James Coleman	02:10
Re: making update/delete of inheritance trees scale better 📎	Amit Langote	02:44
Re: [HACKERS] Runtime Partition Pruning	Andy Fan	07:10
Re: Incorrect assumption in heap_prepare_freeze_tuple	Kuntal Ghosh	08:37
Re: Asynchronous Append on postgres_fdw nodes.	Etsuro Fujita	09:36
Re: Re: [HACKERS] Custom compression methods 📎	Dilip Kumar	10:31
Re: Add Information during standby recovery conflicts 📎	Drouvot, Bertrand	11:48
Re: Add Information during standby recovery conflicts	Alvaro Herrera	14:10
Buglets in equivclass.c 📎	Tom Lane	17:29
Re: small cleanup: unify scanstr() functions	Tom Lane	20:20
A modest proposal: let's add PID to assertion failure messages	Tom Lane	21:08
Re: Buglets in equivclass.c	David Rowley	21:11
Re: A modest proposal: let's add PID to assertion failure messages	Thomas Munro	21:20
Re: [HACKERS] Custom compression methods	Tomas Vondra	22:07

Oct. 5, 2020

Thread	Author	Time
Re: Buggy handling of redundant options in COPY	Michael Paquier	00:48
Re: A modest proposal: let's add PID to assertion failure messages	Michael Paquier	00:58
Re: Add header support to text format and matching feature	Michael Paquier	01:05
Partitionwise join fails under GEQO 📎	Tom Lane	01:17
Re: A modest proposal: let's add PID to assertion failure messages	Tom Lane	01:18
Re: "cert" + clientcert=verify-ca in pg_hba.conf? 📎	Kyotaro Horiguchi	01:25
RE: [Patch] Optimize dropping of relation buffers using dlist 📎	[email protected]	01:29
Re: Two fsync related performance issues? 📎	Thomas Munro	01:38
Re: enable_incremental_sort changes query behavior	James Coleman	01:40
Re: VACUUM PARALLEL option vs. max_parallel_maintenance_workers	Robert Haas	02:19
Re: VACUUM PARALLEL option vs. max_parallel_maintenance_workers	Robert Haas	02:21
Re: VACUUM PARALLEL option vs. max_parallel_maintenance_workers	Amit Kapila	02:41
Re: VACUUM PARALLEL option vs. max_parallel_maintenance_workers	Kyotaro Horiguchi	03:00
Re: Logical Replication - detail message with names of missing columns	Amit Kapila	04:09
Re: Retry Cached Remote Connections for postgres_fdw in case remote backend gets killed/goes away	Fujii Masao	04:15
Re: Asynchronous Append on postgres_fdw nodes.	Kyotaro Horiguchi	04:29
Re: VACUUM PARALLEL option vs. max_parallel_maintenance_workers	Masahiko Sawada	05:36
Re: [HACKERS] Custom compression methods	Dilip Kumar	05:47
Re: [Patch] Optimize dropping of relation buffers using dlist	Amit Kapila	05:52
Re: [Patch] Optimize dropping of relation buffers using dlist	Amit Kapila	06:29
Re: Prepared Statements	Heikki Linnakangas	06:32
Re: Asynchronous Append on postgres_fdw nodes.	Etsuro Fujita	06:35
Re: [PATCH] Automatic HASH and LIST partition creation	Rahila Syed	06:36
Re: [HACKERS] Custom compression methods 📎	Dilip Kumar	07:48
Re: [PATCH] Automatic HASH and LIST partition creation	Pavel Borisov	07:53
Re: Resetting spilled txn statistics in pg_stat_replication	Masahiko Sawada	07:55
Re: Wrong example in the bloom documentation	Daniel Westermann (DWE)	08:16
Re: 回复：how to create index concurrently on partitioned table	Michael Paquier	08:46
Re: Resetting spilled txn statistics in pg_stat_replication	Amit Kapila	08:50
Re: Implementing Incremental View Maintenance 📎	Yugo NAGATA	09:16
RE: [Patch] Optimize dropping of relation buffers using dlist	[email protected]	09:34
Re: small cleanup: unify scanstr() functions	John Naylor	09:37
Re: Support for OUT parameters in procedures	Peter Eisentraut	09:46
Use standard SIGHUP and SIGTERM handlers in autoprewarm module 📎	Bharath Rupireddy	10:45
Fwd: Support for OUT parameters in procedures	Dave Cramer	10:54
Re: Parallel INSERT (INTO ... SELECT ...)	Bharath Rupireddy	10:56
Re: Parallel INSERT (INTO ... SELECT ...)	Dilip Kumar	11:15
dup(0) fails on Ubuntu 20.04 and macOS 10.15 with 13.0	Mario Emmenlauer	11:22
Re: Parallel INSERT (INTO ... SELECT ...)	Amit Kapila	11:23
Re: Retry Cached Remote Connections for postgres_fdw in case remote backend gets killed/goes away	Bharath Rupireddy	11:32
Re: deferred primary key and logical replication	Amit Kapila	11:35
Re: Parallel INSERT (INTO ... SELECT ...)	Dilip Kumar	11:36
Re: Online checksums patch - once again	Heikki Linnakangas	11:36
Re: Support for OUT parameters in procedures	Pavel Stehule	11:39
Re: [Patch] Optimize dropping of relation buffers using dlist	Amit Kapila	11:50
Re: Online checksums patch - once again	Heikki Linnakangas	12:14
Re: [HACKERS] Custom compression methods	Tomas Vondra	12:23
Re: Partitionwise join fails under GEQO	Ashutosh Bapat	12:52
Re: Improve choose_custom_plan for initial partition prune case	Ashutosh Bapat	13:27
Re: Online checksums patch - once again	Álvaro Herrera	14:25
Re: [HACKERS] Custom compression methods	Dilip Kumar	14:27
Re: Logical Replication - detail message with names of missing columns	Bharath Rupireddy	14:29
Re: Use standard SIGHUP and SIGTERM handlers in autoprewarm module 📎	Fujii Masao	14:34
Re: dup(0) fails on Ubuntu 20.04 and macOS 10.15 with 13.0	Tom Lane	14:35
Re: Online checksums patch - once again	Heikki Linnakangas	14:46
Re: dup(0) fails on Ubuntu 20.04 and macOS 10.15 with 13.0	Mario Emmenlauer	14:49
Re: dup(0) fails on Ubuntu 20.04 and macOS 10.15 with 13.0	Matthias Apitz	14:57
Re: enable_incremental_sort changes query behavior	James Coleman	15:33
Re: partition routing layering in nodeModifyTable.c	Heikki Linnakangas	15:45
Re: [HACKERS] Custom compression methods	Tomas Vondra	16:03
Re: Support for OUT parameters in procedures	Steven Schlansker	16:16
Re: Use standard SIGHUP and SIGTERM handlers in autoprewarm module	Bharath Rupireddy	16:18
Re: Support for OUT parameters in procedures	Dave Cramer	16:24
Re: Buglets in equivclass.c	Tom Lane	17:17
Re: "cert" + clientcert=verify-ca in pg_hba.conf?	Bruce Momjian	18:02
Re: Partitionwise join fails under GEQO	Tom Lane	18:29
Re: Support for OUT parameters in procedures	Andrew Dunstan	18:59
Re: Probable documentation errors or improvements 📎	Justin Pryzby	19:19
Re: "cert" + clientcert=verify-ca in pg_hba.conf?	Bruce Momjian	20:07
Re: 回复：how to create index concurrently on partitioned table	Justin Pryzby	20:08
Re: [PATCH] Automatic HASH and LIST partition creation 📎	Pavel Borisov	21:21
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Bruce Momjian	21:24
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Tom Lane	21:42
Re: Support for OUT parameters in procedures	Dave Cramer	22:21
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Alvaro Herrera	22:58

Oct. 6, 2020

Thread	Author	Time
Re: new heapcheck contrib module 📎	Mark Dilger	00:24
Recent failures on buildfarm member hornet	Tom Lane	00:42
Re: shared-memory based stats collector 📎	Kyotaro Horiguchi	01:06
Re: Retry Cached Remote Connections for postgres_fdw in case remote backend gets killed/goes away	Fujii Masao	01:54
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Bruce Momjian	02:18
Re: "cert" + clientcert=verify-ca in pg_hba.conf?	Kyotaro Horiguchi	02:31
Re: Improving connection scalability: GetSnapshotData()	Andres Freund	02:33
Re: enable_incremental_sort changes query behavior 📎	James Coleman	02:38
Re: 回复：how to create index concurrently on partitioned table	Michael Paquier	02:42
Re: 回复：how to create index concurrently on partitioned table	Justin Pryzby	03:07
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Julien Rouhaud	03:11
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Bruce Momjian	03:23
Re: Logical Replication - detail message with names of missing columns	Amit Kapila	03:45
Re: Resetting spilled txn statistics in pg_stat_replication	Masahiko Sawada	04:03
Re: 回复：how to create index concurrently on partitioned table	Michael Paquier	04:38
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Michael Paquier	05:02
Re: WIP: WAL prefetch (another approach) 📎	Thomas Munro	05:04
Re: [HACKERS] logical decoding of two-phase transactions 📎	Peter Smith	05:16
Re: Parallel Inserts in CREATE TABLE AS	Amit Kapila	05:29
Re: [HACKERS] Custom compression methods	Dilip Kumar	05:30
Re: fixing old_snapshot_threshold's time->xid mapping 📎	Thomas Munro	05:32
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Michael Paquier	05:34
Re: Use standard SIGHUP and SIGTERM handlers in autoprewarm module	Fujii Masao	05:50
Re: Use standard SIGHUP and SIGTERM handlers in autoprewarm module	Michael Paquier	05:53
Re: Use standard SIGHUP and SIGTERM handlers in autoprewarm module	Bharath Rupireddy	06:11
Re: libpq compression 📎	Andrey M. Borodin	06:34
Re: Logical Replication - detail message with names of missing columns 📎	Bharath Rupireddy	06:44
Re: New statistics for tuning WAL buffer size	Masahiro Ikeda	06:57
Is the doc for SHOW somewhat stale? 📎	Kyotaro Horiguchi	07:53
Re: Add primary keys to system catalogs	Craig Ringer	07:57
RE: extension patch of CREATE OR REPLACE TRIGGER 📎	[email protected]	08:01
RE: [PoC] Non-volatile WAL buffer 📎	Takashi Menjo	08:49
Re: Resetting spilled txn statistics in pg_stat_replication 📎	Amit Kapila	08:56
pg_upgrade dead code for pre-8.4 versions	Magnus Hagander	09:27
Re: Add session statistics to pg_stat_database	Masahiro Ikeda	09:29
Re: Parallel INSERT (INTO ... SELECT ...) 📎	Greg Nancarrow	09:37
Re: pg_upgrade dead code for pre-8.4 versions	Daniel Gustafsson	09:40
pg_upgrade analyze script 📎	Magnus Hagander	09:43
Re: Parallel INSERT (INTO ... SELECT ...)	Bharath Rupireddy	10:10
Prevent printing "next step instructions" in initdb and pg_upgrade 📎	Magnus Hagander	10:26
Re: Parallel INSERT (INTO ... SELECT ...)	Greg Nancarrow	10:42
Re: Yet another fast GiST build	Pavel Borisov	11:05
Re: Partitionwise join fails under GEQO	Ashutosh Bapat	11:42
Re: enable_incremental_sort changes query behavior 📎	James Coleman	11:45
Re: Prevent printing "next step instructions" in initdb and pg_upgrade	Ian Lawrence Barwick	11:49
Re: Logical Replication - detail message with names of missing columns 📎	Amit Kapila	11:54
[doc] remove reference to pg_dump pre-8.1 switch behaviour	Ian Lawrence Barwick	12:13
Re: [doc] remove reference to pg_dump pre-8.1 switch behaviour 📎	Ian Lawrence Barwick	12:15
Re: Prevent printing "next step instructions" in initdb and pg_upgrade	Magnus Hagander	12:56
[doc] clarify behaviour of pg_dump's -t/--table option with non-tables 📎	Ian Lawrence Barwick	12:58
Re: Logical Replication - detail message with names of missing columns	Bharath Rupireddy	13:06
Re: Yet another fast GiST build	Heikki Linnakangas	13:19
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view?	Bruce Momjian	13:22
Re: enable_incremental_sort changes query behavior	Jaime Casanova	13:28
Re: enable_incremental_sort changes query behavior	James Coleman	13:37
Re: Parallel INSERT (INTO ... SELECT ...)	Bharath Rupireddy	13:40
Re: [doc] clarify behaviour of pg_dump's -t/--table option with non-tables 📎	Ian Lawrence Barwick	13:44
Re: [doc] clarify behaviour of pg_dump's -t/--table option with non-tables	Magnus Hagander	13:48
Re: [doc] clarify behaviour of pg_dump's -t/--table option with non-tables	Magnus Hagander	13:48
Re: Transactions involving multiple postgres foreign servers, take 2	Masahiko Sawada	13:52
Re: Yet another fast GiST build	Tom Lane	14:29
Re: Prevent printing "next step instructions" in initdb and pg_upgrade	Tom Lane	14:31
Re: Prevent printing "next step instructions" in initdb and pg_upgrade	Magnus Hagander	15:04
Re: Prevent printing "next step instructions" in initdb and pg_upgrade	Tom Lane	15:06
Re: Index Skip Scan (new UniqueKeys)	Dmitry Dolgov	15:20
Re: Prevent printing "next step instructions" in initdb and pg_upgrade	Bruce Momjian	15:22
Re: Yet another fast GiST build	Pavel Borisov	15:29
Re: Partitionwise join fails under GEQO	Tom Lane	15:50

Browse Archives

Prev | Next