pgsql-hackers since 2020-10-13 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
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Oct. 13, 2020

Thread Author Time
Re: Resetting spilled txn statistics in pg_stat_replication Masahiko Sawada 00:10
Re: BUG #15858: could not stat file - over 4GB Michael Paquier 00:25
Re: Transactions involving multiple postgres foreign servers, take 2 Kyotaro Horiguchi 01:00
RE: [Patch] Optimize dropping of relation buffers using dlist [email protected] 01:08
Re: Add a description to the documentation that toast_tuple_target affects "Main" Kasahara Tatsuhito 01:40
Re: Transactions involving multiple postgres foreign servers, take 2 Masahiko Sawada 02:56
Re: New statistics for tuning WAL buffer size 📎 Masahiro Ikeda 02:57
Re: Resetting spilled txn statistics in pg_stat_replication Amit Kapila 03:32
Re: Resetting spilled txn statistics in pg_stat_replication Amit Kapila 03:41
Re: Resetting spilled txn statistics in pg_stat_replication Amit Kapila 03:52
Re: Resetting spilled txn statistics in pg_stat_replication Tom Lane 03:55
Re: Resetting spilled txn statistics in pg_stat_replication Amit Kapila 04:24
Re: partition routing layering in nodeModifyTable.c Amit Langote 04:32
Re: Resetting spilled txn statistics in pg_stat_replication Tom Lane 04:51
Re: [HACKERS] Custom compression methods Dilip Kumar 05:00
Re: Resetting spilled txn statistics in pg_stat_replication Amit Kapila 05:03
Re: Resetting spilled txn statistics in pg_stat_replication Tom Lane 05:05
Re: Resetting spilled txn statistics in pg_stat_replication 📎 Amit Kapila 05:29
Re: Resetting spilled txn statistics in pg_stat_replication Tom Lane 05:35
Re: Resetting spilled txn statistics in pg_stat_replication Amit Kapila 05:54
Re: Resetting spilled txn statistics in pg_stat_replication Masahiko Sawada 06:18
Re: Resetting spilled txn statistics in pg_stat_replication 📎 Amit Kapila 06:27
Re: Resetting spilled txn statistics in pg_stat_replication Masahiko Sawada 06:46
Re: Resetting spilled txn statistics in pg_stat_replication Amit Kapila 07:12
Re: Resetting spilled txn statistics in pg_stat_replication Amit Kapila 07:15
Re: Resetting spilled txn statistics in pg_stat_replication Masahiko Sawada 07:20
Re: [HACKERS] Runtime Partition Pruning Amit Langote 07:48
Re: Resetting spilled txn statistics in pg_stat_replication Amit Kapila 07:54
RE: Use list_delete_cell instead in some places Hou, Zhijie 08:02
allow partial union-all and improve parallel subquery costing 📎 Luc Vlaming 08:57
Re: Assertion failure with LEFT JOINs among >500 relations 📎 David Rowley 09:10
Re: Weird corner-case failure mode for VPATH builds Noah Misch 09:48
Re: partition routing layering in nodeModifyTable.c Heikki Linnakangas 10:12
Re: Add session statistics to pg_stat_database 📎 Laurenz Albe 11:44
Re: Two fsync related performance issues? Michael Banck 11:53
Re: partition routing layering in nodeModifyTable.c Amit Langote 12:03
Re: Add header support to text format and matching feature 📎 Rémi Lapeyre 12:49
Re: Improved Cost Calculation for IndexOnlyScan Hamid Akhtar 12:56
[Patch] Using Windows groups for SSPI authentication 📎 Russell Foster 13:10
Re: PATCH: Attempt to make dbsize a bit more consistent 📎 gkokolatos 13:28
Remove unnecessary else branch Li Japin 13:30
Re: Remove unnecessary else branch Heikki Linnakangas 13:36
Re: Remove unnecessary else branch Hamid Akhtar 13:59
Re: Resetting spilled txn statistics in pg_stat_replication Tom Lane 14:27
Re: Resetting spilled txn statistics in pg_stat_replication Amit Kapila 14:54
Re: Remove unnecessary else branch Li Japin 15:03
Re: Remove unnecessary else branch Li Japin 15:03
Re: Assertion failure with LEFT JOINs among >500 relations Tom Lane 15:16
Re: Remove unnecessary else branch Tom Lane 15:25
Re: partition routing layering in nodeModifyTable.c 📎 Heikki Linnakangas 16:09
lost replication slots after pg_upgrade Pavel Stehule 16:20
Re: Add a description to the documentation that toast_tuple_target affects "Main" Fujii Masao 16:30
Re: partition routing layering in nodeModifyTable.c 📎 Heikki Linnakangas 16:30
Re: lost replication slots after pg_upgrade Bruce Momjian 16:33
Re: lost replication slots after pg_upgrade Pavel Stehule 16:37
Getting rid of intermittent PPC64 buildfarm failures 📎 Tom Lane 16:50
Re: lost replication slots after pg_upgrade Bruce Momjian 16:57
Re: [Patch] Using Windows groups for SSPI authentication Tom Lane 17:15
Re: lost replication slots after pg_upgrade Pavel Stehule 17:23
Re: setLastTid() and currtid() Bruce Momjian 18:12
Re: [Patch] Using Windows groups for SSPI authentication Russell Foster 19:02
Using pgadmin with AWS RDS https based Data API Benoit Marchant 19:05
Re: gs_group_1 crashing on 13beta2/s390x Andres Freund 19:21
Re: Improve pg_dump dumping publication tables Cary Huang 19:23
Re: [Patch] Using Windows groups for SSPI authentication Tom Lane 19:32
Re: avoid bitmapOR-ing indexes with scan condition inconsistent with partition constraint Justin Pryzby 20:20
Re: [Patch] Using Windows groups for SSPI authentication Tom Lane 20:32
Re: [Patch] Using Windows groups for SSPI authentication Russell Foster 21:08
Re: lost replication slots after pg_upgrade Peter Eisentraut 21:34
Re: lost replication slots after pg_upgrade Bruce Momjian 21:37
Re: gs_group_1 crashing on 13beta2/s390x Christoph Berg 21:42
Re: Add Information during standby recovery conflicts 📎 Masahiko Sawada 22:36
Re: Add Information during standby recovery conflicts Alvaro Herrera 22:44
Re: Add session statistics to pg_stat_database Justin Pryzby 22:55

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

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31