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

Oct. 14, 2020

Thread Author Time
Re: archive status ".ready" files may be created too early 📎 Kyotaro Horiguchi 00:06
Re: [HACKERS] Runtime Partition Pruning Andy Fan 00:40
Re: Transactions involving multiple postgres foreign servers, take 2 Kyotaro Horiguchi 01:15
Re: libpq debug log Kyotaro Horiguchi 01:18
Re: Wrong statistics for size of XLOG_SWITCH during pg_waldump. Kyotaro Horiguchi 01:29
Re: Two fsync related performance issues? Thomas Munro 01:48
Re: pgstat_report_activity() and parallel CREATE INDEX (was: Parallel index creation & pg_stat_activity) 📎 Noah Misch 02:26
Re: Assertion failure with LEFT JOINs among >500 relations 📎 David Rowley 02:53
RE: Resetting spilled txn statistics in pg_stat_replication 📎 Shinoda, Noriyoshi (PN Japan A&PS Delivery) 03:03
Re: BUG #16663: DROP INDEX did not free up disk space: idle connection hold file marked as deleted Kyotaro Horiguchi 03:05
Re: Transactions involving multiple postgres foreign servers, take 2 Masahiko Sawada 03:09
Re: Wired if-statement in gen_partprune_steps_internal Andy Fan 03:26
Re: Assertion failure with LEFT JOINs among >500 relations Tom Lane 03:26
Re: scram-sha-256 broken with FIPS and OpenSSL 1.0.2 📎 Michael Paquier 03:29
Track statistics for streaming of in-progress transactions 📎 Amit Kapila 03:40
Re: Transactions involving multiple postgres foreign servers, take 2 Kyotaro Horiguchi 04:19
Re: BUG #16663: DROP INDEX did not free up disk space: idle connection hold file marked as deleted Andres Freund 04:35
Re: Transactions involving multiple postgres foreign servers, take 2 Masahiko Sawada 04:52
Re: Two fsync related performance issues? Michael Paquier 05:06
Re: libpq debug log Michael Paquier 05:18
Re: More efficient RI checks - take 2 Antonin Houska 05:22
RE: [PoC] Non-volatile WAL buffer Takashi Menjo 05:30
Some remaining htonl() and ntohl() calls in the code 📎 Michael Paquier 05:53
Re: Wired if-statement in gen_partprune_steps_internal Kyotaro Horiguchi 06:27
Re: partition routing layering in nodeModifyTable.c 📎 Amit Langote 06:44
Re: BUG #16663: DROP INDEX did not free up disk space: idle connection hold file marked as deleted denis.patron 06:47
Re: Wrong statistics for size of XLOG_SWITCH during pg_waldump. Michael Paquier 06:52
Re: Use list_delete_xxxcell O(1) instead of list_delete_ptr O(N) in some places Luc Vlaming 07:13
Re: Add a description to the documentation that toast_tuple_target affects "Main" 📎 Shinya Okano 07:21
Re: Remove some unnecessary if-condition Michael Paquier 07:22
Re: allow partial union-all and improve parallel subquery costing 📎 Luc Vlaming 07:38
Re: scram-sha-256 broken with FIPS and OpenSSL 1.0.2 Heikki Linnakangas 07:40
Re: Use appendStringInfoString and appendPQExpBufferStr where possible 📎 David Rowley 08:05
Re: Transactions involving multiple postgres foreign servers, take 2 Kyotaro Horiguchi 08:10
Re: Two fsync related performance issues? Michael Banck 08:14
Re: scram-sha-256 broken with FIPS and OpenSSL 1.0.2 Michael Paquier 08:18
Re: Add Information during standby recovery conflicts 📎 Masahiko Sawada 08:39
Re: Loose ends after CVE-2020-14350 (extension installation hazards) Noah Misch 08:46
Re: partition routing layering in nodeModifyTable.c Heikki Linnakangas 09:04
Re: Parallel Inserts in CREATE TABLE AS 📎 Bharath Rupireddy 09:16
Re: Add session statistics to pg_stat_database 📎 Laurenz Albe 09:28
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? 📎 Julien Rouhaud 09:43
Re: partition routing layering in nodeModifyTable.c Amit Langote 09:51
Re: Parallel copy 📎 vignesh C 09:53
Re: Transactions involving multiple postgres foreign servers, take 2 Masahiko Sawada 10:11
Re: Logical replication CPU-bound with TRUNCATE/DROP/CREATE many tables 📎 Amit Kapila 10:42
Re: Logical replication CPU-bound with TRUNCATE/DROP/CREATE many tables Dilip Kumar 11:21
Re: Parallel copy Bharath Rupireddy 11:35
RelationGetNumberOfBlocks is called every time of heap_rescan. Andy Fan 12:02
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? 📎 Julien Rouhaud 12:25
Re: [HACKERS] logical decoding of two-phase transactions 📎 Ajin Cherian 12:44
Re: Parallel Inserts in CREATE TABLE AS Amit Kapila 12:46
Re: Parallel copy vignesh C 12:54
WIP psql \df choose functions by their arguments 📎 Greg Sabino Mullane 12:56
Re: Parallel copy vignesh C 13:20
Re: Parallel copy vignesh C 13:29
Re: Parallel copy vignesh C 13:41
Re: Deleting older versions in unique indexes to avoid page splits Anastasia Lubennikova 14:07
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Bruce Momjian 14:09
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Julien Rouhaud 14:21
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Bruce Momjian 14:25
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Tom Lane 14:31
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Julien Rouhaud 14:34
Re: Deleting older versions in unique indexes to avoid page splits Peter Geoghegan 14:40
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Bruce Momjian 14:40
Re: Global snapshots Fujii Masao 16:41
speed up unicode decomposition and recomposition 📎 John Naylor 16:58
Re: speed up unicode decomposition and recomposition Tom Lane 17:06
kevent latch paths don't handle postmaster death well Tom Lane 18:58
Re: BUG #16663: DROP INDEX did not free up disk space: idle connection hold file marked as deleted Thomas Munro 19:08
Re: BUG #16663: DROP INDEX did not free up disk space: idle connection hold file marked as deleted Tom Lane 19:14
Re: kevent latch paths don't handle postmaster death well Thomas Munro 19:36
jit and explain nontext Justin Pryzby 19:39
Re: kevent latch paths don't handle postmaster death well Tom Lane 19:40
Re: kevent latch paths don't handle postmaster death well Heikki Linnakangas 20:10
Re: More aggressive vacuuming of temporary tables Andres Freund 20:31
Re: Some remaining htonl() and ntohl() calls in the code Andres Freund 20:41
Re: Wrong statistics for size of XLOG_SWITCH during pg_waldump. Andres Freund 20:46
Re: Minor documentation error regarding streaming replication protocol 📎 Bruce Momjian 20:46
Re: Minor documentation error regarding streaming replication protocol Tom Lane 21:10
Failures during FATAL exit Tom Lane 21:37
Re: gs_group_1 crashing on 13beta2/s390x Andres Freund 21:58
Re: kevent latch paths don't handle postmaster death well 📎 Thomas Munro 22:10
Re: kevent latch paths don't handle postmaster death well Tom Lane 22:18
Re: kevent latch paths don't handle postmaster death well Thomas Munro 22:50
Re: kevent latch paths don't handle postmaster death well 📎 Tom Lane 22:57
Re: kevent latch paths don't handle postmaster death well Andres Freund 22:59
Re: kevent latch paths don't handle postmaster death well Tom Lane 23:14
pgsql: Restore replication protocol's duplicate command tags Alvaro Herrera 23:16
Re: kevent latch paths don't handle postmaster death well Thomas Munro 23:55

Oct. 15, 2020

Thread Author Time
Re: speed up unicode decomposition and recomposition Michael Paquier 00:25
Re: pgsql: Restore replication protocol's duplicate command tags Alvaro Herrera 00:36
Re: gs_group_1 crashing on 13beta2/s390x Andres Freund 00:56
Re: jit and explain nontext David Rowley 01:02
Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY Andy Fan 01:04
Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY Alvaro Herrera 01:08
Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY David Rowley 01:09
Re: jit and explain nontext Tom Lane 01:15
Re: jit and explain nontext David Rowley 01:23
Re: BUG #16663: DROP INDEX did not free up disk space: idle connection hold file marked as deleted 📎 Thomas Munro 01:26
Re: BUG #16663: DROP INDEX did not free up disk space: idle connection hold file marked as deleted Kyotaro Horiguchi 01:42
Re: jit and explain nontext Justin Pryzby 01:43
Re: jit and explain nontext David Rowley 01:51
Re: Add a description to the documentation that toast_tuple_target affects "Main" Fujii Masao 02:12
Re: Minor documentation error regarding streaming replication protocol Bruce Momjian 02:25
Re: Wrong statistics for size of XLOG_SWITCH during pg_waldump. 📎 Kyotaro Horiguchi 02:44
Re: speed up unicode decomposition and recomposition John Naylor 02:56
Re: speed up unicode decomposition and recomposition Tom Lane 03:06
Re: Add Information during standby recovery conflicts Kyotaro Horiguchi 03:13
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila 03:16
Re: VACUUM PARALLEL option vs. max_parallel_maintenance_workers Amit Kapila 03:32
RE: [Patch] Optimize dropping of relation buffers using dlist 📎 [email protected] 03:34
Re: ALTER TABLE .. DETACH PARTITION CONCURRENTLY Andy Fan 03:38
Re: Feature improvement: can we add queryId for pg_catalog.pg_stat_activity view? Julien Rouhaud 03:41
Re: Parallel Inserts in CREATE TABLE AS Bharath Rupireddy 03:44
Re: Parallel INSERT (INTO ... SELECT ...) 📎 Greg Nancarrow 04:25
Re: Wrong statistics for size of XLOG_SWITCH during pg_waldump. 📎 [email protected] 04:56
Re: Add Information during standby recovery conflicts Masahiko Sawada 05:28
Re: speed up unicode decomposition and recomposition Kyotaro Horiguchi 05:30
Re: Resetting spilled txn statistics in pg_stat_replication Masahiko Sawada 05:36
Re: Online checksums verification in the backend 📎 Julien Rouhaud 05:37
Re: kevent latch paths don't handle postmaster death well Thomas Munro 05:42
Re: Add Information during standby recovery conflicts Kyotaro Horiguchi 05:52
Aw: Re: Minor documentation error regarding streaming replication protocol Brar Piening 06:27
RE: [Patch] Optimize dropping of relation buffers using dlist [email protected] 06:55
Re: scram-sha-256 broken with FIPS and OpenSSL 1.0.2 📎 Michael Paquier 06:56
Re: BUG #16663: DROP INDEX did not free up disk space: idle connection hold file marked as deleted denni.pat 06:57
Re: pgsql: Restore replication protocol's duplicate command tags Amit Kapila 07:07
Re: Logical replication CPU-bound with TRUNCATE/DROP/CREATE many tables Amit Kapila 07:08
Re: Add Information during standby recovery conflicts 📎 Masahiko Sawada 07:15
Possible memory leak in pgcrypto with EVP_MD_CTX 📎 Michael Paquier 07:22
Re: Logical replication CPU-bound with TRUNCATE/DROP/CREATE many tables Dilip Kumar 07:31
Re: Use appendStringInfoString and appendPQExpBufferStr where possible David Rowley 07:38
Re: Feature improvement for FETCH tab completion Fujii Masao 07:53
Re: Online checksums verification in the backend 📎 Julien Rouhaud 07:59
Re: setLastTid() and currtid() Michael Paquier 08:12
Re: Wrong statistics for size of XLOG_SWITCH during pg_waldump. 📎 Kyotaro Horiguchi 08:32
Re: gs_group_1 crashing on 13beta2/s390x Andres Freund 08:32
Re: recovering from "found xmin ... from before relfrozenxid ..." 📎 Andres Freund 08:37
Re: Wrong statistics for size of XLOG_SWITCH during pg_waldump. Kyotaro Horiguchi 08:38
Re: Resetting spilled txn statistics in pg_stat_replication Amit Kapila 08:52
Re: Logical replication CPU-bound with TRUNCATE/DROP/CREATE many tables Keisuke Kuroda 09:09
Re: Parallel copy Amit Kapila 09:10
Re: Parallel Inserts in CREATE TABLE AS Amit Kapila 09:48
Re: [HACKERS] logical decoding of two-phase transactions 📎 Ajin Cherian 10:31
Re: New statistics for tuning WAL buffer size Fujii Masao 10:49
Re: Parallel INSERT (INTO ... SELECT ...) Amit Kapila 12:43
Re: pgsql: Restore replication protocol's duplicate command tags Alvaro Herrera 12:52
improve the algorithm cached_plan_cost with real planning time? Andy Fan 13:12
Re: Parallel Append can break run-time partition pruning Amit Langote 14:01
Re: Aw: Re: Minor documentation error regarding streaming replication protocol Tom Lane 14:03
Re: Is the doc for SHOW somewhat stale? Fujii Masao 14:18
Re: Aw: Re: Minor documentation error regarding streaming replication protocol Fujii Masao 14:23
Packaging - Packages names consistency (RPM) Bruno Lavoie 14:23
Re: partition routing layering in nodeModifyTable.c Heikki Linnakangas 14:59
Re: Aw: Re: Minor documentation error regarding streaming replication protocol Bruce Momjian 15:14
Re: Logical Replication - detail message with names of missing columns Alvaro Herrera 15:17
Re: Aw: Re: Minor documentation error regarding streaming replication protocol Tom Lane 15:18
Re: [Patch] Using Windows groups for SSPI authentication Stephen Frost 15:31
Aw: Re: Re: Minor documentation error regarding streaming replication protocol Brar Piening 15:36
Re: Aw: Re: Minor documentation error regarding streaming replication protocol Bruce Momjian 15:45
Re: Aw: Re: Minor documentation error regarding streaming replication protocol Tom Lane 16:01
Re: [PATCH] We install pg_regress and isolationtester but not pg_isolation_regress Alvaro Herrera 16:20
Re: Packaging - Packages names consistency (RPM) Devrim Gündüz 16:26
Re: Aw: Re: Minor documentation error regarding streaming replication protocol 📎 Bruce Momjian 16:43
Re: [PATCH] We install pg_regress and isolationtester but not pg_isolation_regress Alvaro Herrera 16:47
Re: [PATCH] We install pg_regress and isolationtester but not pg_isolation_regress Tom Lane 17:06
psql \df choose functions by their arguments 📎 Greg Sabino Mullane 17:21
Re: AppendStringInfoChar instead of appendStringInfoString Alvaro Herrera 17:36
plan cache doesn't clean plans with references to dropped procedures Pavel Stehule 17:54
Re: CREATE TABLE .. PARTITION OF fails to preserve tgenabled for inherited row triggers Justin Pryzby 17:57
Re: speed up unicode decomposition and recomposition 📎 John Naylor 17:59
Re: plan cache doesn't clean plans with references to dropped procedures Tom Lane 18:17
Re: plan cache doesn't clean plans with references to dropped procedures Pavel Stehule 18:51
Re: improve the algorithm cached_plan_cost with real planning time? Andy Fan 19:18
Re: Partition prune with stable Expr Andy Fan 19:36
Re: [Patch] Using Windows groups for SSPI authentication Russell Foster 19:56
Re: Logical replication CPU-bound with TRUNCATE/DROP/CREATE many tables Andres Freund 20:30
Re: kevent latch paths don't handle postmaster death well Thomas Munro 21:32
Re: kevent latch paths don't handle postmaster death well Tom Lane 21:40
Re: stress test for parallel workers Thomas Munro 22:11
Re: Use list_delete_xxxcell O(1) instead of list_delete_ptr O(N) in some places 📎 David Rowley 22:24
Re: gs_group_1 crashing on 13beta2/s390x Andres Freund 22:29
Re: gs_group_1 crashing on 13beta2/s390x Andres Freund 22:37
Re: jit and explain nontext Andres Freund 23:00
Re: pg_upgrade: fail early if a tablespace dir already exists for new cluster version Bruce Momjian 23:35
Re: Wrong example in the bloom documentation Bruce Momjian 23:50
Re: BUG #16663: DROP INDEX did not free up disk space: idle connection hold file marked as deleted Thomas Munro 23:54

Oct. 16, 2020

Thread Author Time
Re: Some remaining htonl() and ntohl() calls in the code Michael Paquier 00:01
Re: gs_group_1 crashing on 13beta2/s390x Andres Freund 00:12
Re: pg_upgrade: fail early if a tablespace dir already exists for new cluster version Andres Freund 00:19
Re: pg_upgrade: fail early if a tablespace dir already exists for new cluster version Bruce Momjian 00:37
Re: Online checksums verification in the backend 📎 Julien Rouhaud 00:59
Re: [PATCH] We install pg_regress and isolationtester but not pg_isolation_regress Michael Paquier 01:00
Re: Is the doc for SHOW somewhat stale? 📎 Kyotaro Horiguchi 01:00
upcoming API changes for LLVM 12 Andres Freund 01:12
Re: Online checksums verification in the backend 📎 Julien Rouhaud 01:22
Re: [PATCH] We install pg_regress and isolationtester but not pg_isolation_regress Craig Ringer 02:19
Re: upcoming API changes for LLVM 12 Thomas Munro 02:37
Re: Logical replication CPU-bound with TRUNCATE/DROP/CREATE many tables Amit Kapila 02:49

Browse Archives

Prev | Next