pgsql-hackers since 2020-12-04 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)

Browse Archives

Prev | Next

Dec. 4, 2020

Thread Author Time
Re: Huge memory consumption on partitioned table with FKs Kyotaro Horiguchi 00:17
Re: Add Information during standby recovery conflicts Masahiko Sawada 00:28
Re: On login trigger: take three 📎 Greg Nancarrow 00:50
Re: [HACKERS] logical decoding of two-phase transactions 📎 Peter Smith 00:55
Re: Support for NSS as a libpq TLS backend Jacob Champion 00:57
Re: Add Information during standby recovery conflicts Fujii Masao 01:21
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly 📎 Justin Pryzby 01:25
Re: scram-sha-256 broken with FIPS and OpenSSL 1.0.2 Michael Paquier 02:09
Re: Single transaction in the tablesync worker? Craig Ringer 02:22
RE: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently 📎 [email protected] 02:52
Re: Single transaction in the tablesync worker? Amit Kapila 02:52
Re: Huge memory consumption on partitioned table with FKs Keisuke Kuroda 03:00
Re: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently Bharath Rupireddy 03:00
Re: Huge memory consumption on partitioned table with FKs 📎 Kyotaro Horiguchi 03:05
RE: A new function to wait for the backend exit after termination Hou, Zhijie 03:13
Re: autovac issue with large number of tables Kasahara Tatsuhito 03:21
RE: [Patch] Optimize dropping of relation buffers using dlist Tang, Haiying 03:42
RE: Wrong statistics for size of XLOG_SWITCH during pg_waldump. Shinya11.Kato 04:20
Re: Single transaction in the tablesync worker? Amit Kapila 04:59
Re: [Patch] Optimize dropping of relation buffers using dlist Kyotaro Horiguchi 05:04
Re: Single transaction in the tablesync worker? Amit Kapila 05:05
Re: [Patch] Optimize dropping of relation buffers using dlist Kyotaro Horiguchi 05:28
Re: Is it useful to record whether plans are generic or custom? Fujii Masao 05:29
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly Michael Paquier 05:37
Re: Renaming cryptohashes.c to cryptohashfuncs.c Michael Paquier 05:37
Re: Huge memory consumption on partitioned table with FKs Kyotaro Horiguchi 05:48
Re: Remove incorrect assertion in reorderbuffer.c. Dilip Kumar 05:48
Re: Is it useful to record whether plans are generic or custom? torikoshia 06:03
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit Fujii Masao 06:19
Re: Wrong statistics for size of XLOG_SWITCH during pg_waldump. Kyotaro Horiguchi 06:20
Re: A new function to wait for the backend exit after termination 📎 Bharath Rupireddy 06:29
Re: Huge memory consumption on partitioned table with FKs 📎 Amit Langote 06:32
Re: Is it useful to record whether plans are generic or custom? Kyotaro Horiguchi 06:37
Re: Refactor MD5 implementations and switch to EVP for OpenSSL 📎 Michael Paquier 07:05
RE: [Patch] Optimize dropping of relation buffers using dlist [email protected] 07:05
Logical archiving Andrey Borodin 07:33
RE: In-placre persistance change of a relation [email protected] 07:49
Re: pg_stat_statements oddity with track = all 📎 Julien Rouhaud 08:15
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit Bharath Rupireddy 08:16
RE: A new function to wait for the backend exit after termination Hou, Zhijie 08:31
Re: Single transaction in the tablesync worker? Amit Kapila 09:02
Re: Remove incorrect assertion in reorderbuffer.c. Amit Kapila 09:05
Re: pg_stat_statements oddity with track = all Sergei Kornilov 09:06
Re: A new function to wait for the backend exit after termination 📎 Bharath Rupireddy 09:13
Re: POC: Cleaning up orphaned files using undo logs 📎 Antonin Houska 09:22
Re: A new function to wait for the backend exit after termination hou zhijie 09:29
Re: On login trigger: take three Konstantin Knizhnik 10:05
Re: pg_stat_statements oddity with track = all 📎 Julien Rouhaud 10:09
Re: Get memory contexts of an arbitrary backend process torikoshia 10:16
Re: Add Information during standby recovery conflicts 📎 Drouvot, Bertrand 10:22
Re: [PATCH] postgres_fdw connection caching - cause remote sessions linger till the local session exit 📎 Bharath Rupireddy 11:15
Re: [Patch] Optimize dropping of relation buffers using dlist Amit Kapila 11:27
Re: {CREATE INDEX, REINDEX} CONCURRENTLY improvements Dmitry Dolgov 11:38
Re: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently Bharath Rupireddy 11:52
Re: [HACKERS] Custom compression methods Dilip Kumar 12:16
Re: convert elog(LOG) calls to ereport Peter Eisentraut 13:34
Re: convert elog(LOG) calls to ereport Peter Eisentraut 13:34
Re: convert elog(LOG) calls to ereport Peter Eisentraut 13:35
Re: Single transaction in the tablesync worker? Ashutosh Bapat 13:42
Re: {CREATE INDEX, REINDEX} CONCURRENTLY improvements Alvaro Herrera 14:37
Re: Hybrid Hash/Nested Loop joins and caching results from subplans 📎 David Rowley 14:41
Re: [HACKERS] [PATCH] Generic type subscripting 📎 Tom Lane 15:42
Re: Add session statistics to pg_stat_database Laurenz Albe 15:55
[PATCH] Add support for leading/trailing bytea trim()ing 📎 Joel Jacobson 16:30
Re: [PATCH] Add support for leading/trailing bytea trim()ing Tom Lane 16:37
Re: Corner-case bug in pg_rewind Heikki Linnakangas 16:43
Re: [PATCH] Covering SPGiST index Tom Lane 17:05
Re: pg_dump, ATTACH, and independently restorable child partitions Tom Lane 17:13
Re: Logical archiving Euler Taveira 17:14
Re: please update ps display for recovery checkpoint 📎 Bossart, Nathan 17:17
Re: pg_ls_tmpdir to show directories and shared filesets (and pg_ls_*) Tom Lane 17:23
Re: [PATCH] Covering SPGiST index 📎 Pavel Borisov 17:31
Re: Logical archiving Andrey Borodin 17:36
Re: pg_dump, ATTACH, and independently restorable child partitions 📎 Justin Pryzby 18:02
Re: [HACKERS] [PATCH] Generic type subscripting Tom Lane 18:25
Re: walsender bug: stuck during shutdown Alvaro Herrera 18:27
Re: WIP: WAL prefetch (another approach) Stephen Frost 18:27
Re: Logical archiving Euler Taveira 18:28
Re: POC: Better infrastructure for automated testing of concurrency issues Alvaro Herrera 18:29
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly 📎 Alexey Kondratov 18:40
Re: [PATCH] Add support for leading/trailing bytea trim()ing 📎 Joel Jacobson 18:44
Re: WIP: WAL prefetch (another approach) Andres Freund 18:51
Re: POC: Better infrastructure for automated testing of concurrency issues Peter Geoghegan 18:57
Re: Improper use about DatumGetInt32 Alvaro Herrera 18:58
Re: Add docs stub for recovery.conf Stephen Frost 19:00
Re: WIP: WAL prefetch (another approach) Stephen Frost 19:01
Re: Add docs stub for recovery.conf David G. Johnston 19:14
Re: Add docs stub for recovery.conf Stephen Frost 19:28
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly Alvaro Herrera 19:28
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly 📎 Justin Pryzby 19:54
[PATCH] pg_dumpall options proposal/patch code 20:57
Re: [PATCH] Add support for leading/trailing bytea trim()ing Tom Lane 21:02
Re: POC: Better infrastructure for automated testing of concurrency issues Alexander Korotkov 21:15
Re: POC: Better infrastructure for automated testing of concurrency issues Alexander Korotkov 21:20
Re: Improving spin-lock implementation on ARM. Alexander Korotkov 21:25
Removal of operator_precedence_warning 📎 Tom Lane 21:39
Re: [PATCH] pg_dumpall options proposal/patch Tom Lane 21:43
Re: A few new options for CHECKPOINT Alvaro Herrera 21:46
Re: POC: Better infrastructure for automated testing of concurrency issues Peter Geoghegan 22:00
Re: Removal of operator_precedence_warning Alvaro Herrera 22:01
Re: A few new options for CHECKPOINT Stephen Frost 22:17
Re: Removal of operator_precedence_warning Tom Lane 22:21
Re: A few new options for CHECKPOINT 📎 Bossart, Nathan 23:21
Re: A few new options for CHECKPOINT Alvaro Herrera 23:32

Dec. 5, 2020

Thread Author Time
Re: A few new options for CHECKPOINT 📎 Bossart, Nathan 00:11
Hybrid Hash/Nested Loop joins and caching results from subplans Zhihong Yu 01:09
Re: Allow CLUSTER, VACUUM FULL and REINDEX to change tablespace on the fly 📎 Michael Paquier 01:30
Re: A few new options for CHECKPOINT Michael Paquier 01:43
Re: Single transaction in the tablesync worker? Amit Kapila 02:04
Re: Proposed patch for key managment 📎 Bruce Momjian 02:08
Re: convert elog(LOG) calls to ereport Michael Paquier 02:22
Re: Proposed patch for key managment Michael Paquier 02:39
Re: Proposed patch for key managment Masahiko Sawada 03:15
Re: Proposed patch for key managment Bruce Momjian 03:32
Re: Add Information during standby recovery conflicts Masahiko Sawada 03:38
Re: Hybrid Hash/Nested Loop joins and caching results from subplans Zhihong Yu 03:51
Re: Proposed patch for key managment 📎 Bruce Momjian 03:52
Re: A few new options for CHECKPOINT 📎 Bossart, Nathan 05:18
Re: POC: Cleaning up orphaned files using undo logs Amit Kapila 06:00
Re: [PATCH] Add support for leading/trailing bytea trim()ing 📎 Joel Jacobson 07:22
Re: Parallel Inserts in CREATE TABLE AS Amit Kapila 10:59
Re: Add session statistics to pg_stat_database 📎 Laurenz Albe 12:04
Re: Proposed patch for key managment Michael Paquier 12:54
Re: A few new options for CHECKPOINT Stephen Frost 14:41
Re: Hybrid Hash/Nested Loop joins and caching results from subplans Andy Fan 14:52
Re: [PATCH] Keeps tracking the uniqueness with UniqueKey Andy Fan 15:10
Change definitions of bitmap flags to bit-shifting style 📎 Peter Eisentraut 15:30
Re: Proposed patch for key managment Bruce Momjian 15:42
Re: automatic analyze: readahead - add "IO read time" log message Stephen Frost 16:39
Re: A few new options for CHECKPOINT Bossart, Nathan 17:03
Re: A few new options for CHECKPOINT Stephen Frost 17:10
Re: Index Skip Scan (new UniqueKeys) Dmitry Dolgov 17:55
Re: Change definitions of bitmap flags to bit-shifting style Tom Lane 18:03
Re: [PATCH] Keeps tracking the uniqueness with UniqueKey Heikki Linnakangas 18:40
Re: should INSERT SELECT use a BulkInsertState? 📎 Justin Pryzby 19:59
Re: Index Skip Scan (new UniqueKeys) Thomas Munro 20:27
Re: [PATCH] Keeps tracking the uniqueness with UniqueKey Tom Lane 20:40

Dec. 6, 2020

Thread Author Time
Re: Change definitions of bitmap flags to bit-shifting style Alvaro Herrera 01:31
Re: A few new options for CHECKPOINT Alvaro Herrera 01:33
Re: [PATCH] Keeps tracking the uniqueness with UniqueKey Andy Fan 03:38
Re: Change definitions of bitmap flags to bit-shifting style Laurenz Albe 05:22
Re: Change definitions of bitmap flags to bit-shifting style Michael Paquier 06:25
Re: A few new options for CHECKPOINT Stephen Frost 15:03
Re: Change definitions of bitmap flags to bit-shifting style James Coleman 16:44
Re: Change definitions of bitmap flags to bit-shifting style Andrew Dunstan 17:16
pg_upgrade test for binary compatibility of core data types 📎 Justin Pryzby 18:02
Wrong check in pg_visibility? Konstantin Knizhnik 20:50
Re: Default role -> Predefined role Daniel Gustafsson 21:20
Re: Hybrid Hash/Nested Loop joins and caching results from subplans David Rowley 23:46
Re: Hybrid Hash/Nested Loop joins and caching results from subplans David Rowley 23:50

Dec. 7, 2020

Thread Author Time
Re: Proposed patch for key managment Masahiko Sawada 00:30
Re: Hybrid Hash/Nested Loop joins and caching results from subplans David Rowley 00:33
Re: Consider parallel for lateral subqueries with limit Brian Davis 00:33
Re: Parallel Inserts in CREATE TABLE AS 📎 Bharath Rupireddy 00:37
Re: Single transaction in the tablesync worker? Craig Ringer 00:50
Re: Hybrid Hash/Nested Loop joins and caching results from subplans David Rowley 01:15
Re: Hybrid Hash/Nested Loop joins and caching results from subplans Zhihong Yu 01:25
Re: Proposed patch for key managment Michael Paquier 02:03
Re: A few new options for CHECKPOINT Michael Paquier 02:22
Re: Logical archiving Craig Ringer 03:05
Re: Logical archiving Craig Ringer 03:05
Re: Parallel Inserts in CREATE TABLE AS Zhihong Yu 03:27
RFC: Giving bgworkers walsender-like grace during shutdown (for logical replication) Craig Ringer 03:33
Re: Single transaction in the tablesync worker? Peter Smith 03:44
Re: Single transaction in the tablesync worker? Amit Kapila 03:51
RFC: Deadlock detector hooks for victim selection and edge injection Craig Ringer 03:54
RFC: Deadlock detector hooks for edge injection Craig Ringer 04:13
Re: Single transaction in the tablesync worker? Craig Ringer 04:31
Re: Proposed patch for key managment Bruce Momjian 04:42
Re: Proposed patch for key managment Bruce Momjian 04:46
Re: Parallel Inserts in CREATE TABLE AS 📎 Bharath Rupireddy 04:51
Re: Improving spin-lock implementation on ARM. Amit Khandekar 04:56
RE: Parallel Inserts in CREATE TABLE AS Hou, Zhijie 06:02
RE: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently [email protected] 06:05
Re: POC: Better infrastructure for automated testing of concurrency issues Craig Ringer 06:09
Re: ModifyTable overheads in generic plans 📎 Amit Langote 06:53
RE: [Patch] Optimize dropping of relation buffers using dlist [email protected] 07:02
Re: Single transaction in the tablesync worker? Amit Kapila 07:57
Re: [PATCH] Keeps tracking the uniqueness with UniqueKey Jesper Pedersen 08:15
Added missing copy related data structures to typedefs.list 📎 vignesh C 08:26
Re: Parallel copy 📎 vignesh C 08:32
Re: Single transaction in the tablesync worker? Amit Kapila 08:51
Re: Logical archiving Amit Kapila 09:00
Re: Parallel INSERT (INTO ... SELECT ...) 📎 Greg Nancarrow 09:04
Re: Parallel Inserts in CREATE TABLE AS Amit Kapila 09:26
RE: Parallel copy Hou, Zhijie 09:30
Re: PoC/WIP: Extended statistics on expressions Dean Rasheed 09:56
Re: Yet another fast GiST build 📎 Andrey Borodin 10:05
get_constraint_index() and conindid 📎 Peter Eisentraut 10:09
Re: RFC: Deadlock detector hooks for victim selection and edge injection Amit Kapila 10:12
Re: Parallel Inserts in CREATE TABLE AS Bharath Rupireddy 10:13
Re: Add primary keys to system catalogs 📎 Peter Eisentraut 10:28
Re: Parallel Inserts in CREATE TABLE AS Amit Kapila 10:35
Re: [bug fix] ALTER TABLE SET LOGGED/UNLOGGED on a partitioned table does nothing silently Bharath Rupireddy 10:42
Re: Parallel Inserts in CREATE TABLE AS Bharath Rupireddy 10:50
Re: [Patch] Optimize dropping of relation buffers using dlist Amit Kapila 11:48
Re: Parallel Inserts in CREATE TABLE AS Amit Kapila 11:56
Re: [PATCH] Keeps tracking the uniqueness with UniqueKey Andy Fan 12:14
initscan for MVCC snapshot Andy Fan 12:26
Re: [PATCH] Keeps tracking the uniqueness with UniqueKey Ashutosh Bapat 12:27

Browse Archives

Prev | Next