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

Sept. 25, 2020

Thread Author Time
Re: history file on replica and double switchover Fujii Masao 00:00
Re: Handing off SLRU fsyncs to the checkpointer Tom Lane 00:05
Re: shared-memory based stats collector 📎 Kyotaro Horiguchi 00:27
Re: "cert" + clientcert=verify-ca in pg_hba.conf? 📎 Kyotaro Horiguchi 00:33
Re: Handing off SLRU fsyncs to the checkpointer 📎 Thomas Munro 00:53
pg_upgrade: fail early if a tablespace dir already exists for new cluster version 📎 Justin Pryzby 00:55
Re: "cert" + clientcert=verify-ca in pg_hba.conf? Michael Paquier 01:05
Re: Memory allocation abstraction in pgcrypto Michael Paquier 01:27
Re: BUG #15383: Join Filter cost estimation problem in 10.5 David Rowley 01:49
Re: Logical replication from PG v13 and below to PG v14 (devel version) is not working. Dilip Kumar 01:51
Re: "cert" + clientcert=verify-ca in pg_hba.conf? Tom Lane 01:59
Re: fixing old_snapshot_threshold's time->xid mapping Michael Paquier 02:00
Re: Logical replication from PG v13 and below to PG v14 (devel version) is not working. Amit Kapila 02:38
Re: Logical replication from PG v13 and below to PG v14 (devel version) is not working. Amit Kapila 02:42
Re: New statistics for tuning WAL buffer size 📎 Masahiro Ikeda 03:06
Re: Parallel INSERT (INTO ... SELECT ...) Amit Kapila 03:18
Re: scram-sha-256 broken with FIPS and OpenSSL 1.0.2 Michael Paquier 03:19
Re: scram-sha-256 broken with FIPS and OpenSSL 1.0.2 Michael Paquier 03:32
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 03:40
Re: history file on replica and double switchover David Zhang 04:00
Re: scram-sha-256 broken with FIPS and OpenSSL 1.0.2 Michael Paquier 04:21
Re: scram-sha-256 broken with FIPS and OpenSSL 1.0.2 Tom Lane 04:27
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 04:31
Feature improvement of tab completion for DEALLOCATE 📎 btnakamichin 04:45
Re: Retry Cached Remote Connections for postgres_fdw in case remote backend gets killed/goes away 📎 Bharath Rupireddy 04:56
Feature improvement for FETCH tab completion 📎 btnakamichin 05:24
Re: scram-sha-256 broken with FIPS and OpenSSL 1.0.2 Peter Eisentraut 05:25
Re: Feature improvement of tab completion for DEALLOCATE Fujii Masao 05:30
Re: scram-sha-256 broken with FIPS and OpenSSL 1.0.2 Tom Lane 05:36
Re: <xref> vs <command> formatting in the docs Peter Eisentraut 05:38
Re: [PATCH] Add features to pg_stat_statements Katsuragi Yuta 05:46
Re: Range checks of pg_test_fsync --secs-per-test and pg_test_timing --duration Peter Eisentraut 05:52
Re: Logical replication from PG v13 and below to PG v14 (devel version) is not working. Ashutosh Sharma 06:12
Re: Feature improvement of tab completion for DEALLOCATE 📎 btnakamichin 06:18
Problem of ko.po on branch REL9_5_STABLE Yang, Rong 06:28
Re: Load TIME fields - proposed performance improvement 📎 Peter Smith 06:34
Re: Feature improvement for FETCH tab completion Fujii Masao 06:38
Re: [patch] Concurrent table reindex per-index progress reporting 📎 Michael Paquier 06:44
Re: [patch] Fix checksum verification in base backups for zero page headers 📎 Michael Banck 06:53
Re: scram-sha-256 broken with FIPS and OpenSSL 1.0.2 Michael Paquier 06:56
Re: history file on replica and double switchover 📎 Fujii Masao 07:07
Re: Handing off SLRU fsyncs to the checkpointer Thomas Munro 07:09
Re: Get memory contexts of an arbitrary backend process 📎 torikoshia 07:28
[PATCH] Runtime control of CLOBBER_CACHE_ALWAYS 📎 Craig Ringer 07:40
RE: [Patch] Optimize dropping of relation buffers using dlist 📎 [email protected] 08:18
Re: Feature improvement for FETCH tab completion 📎 btnakamichin 08:21
Re: Logical replication from PG v13 and below to PG v14 (devel version) is not working. 📎 Dilip Kumar 08:22
Re: Transactions involving multiple postgres foreign servers, take 2 Masahiko Sawada 08:35
AppendStringInfoChar instead of appendStringInfoString 📎 Hou, Zhijie 08:49
RE: [Patch] Optimize dropping of relation buffers using dlist [email protected] 08:55
enable pg_stat_statements to track rows processed by REFRESH MATERIALIZED VIEW 📎 Katsuragi Yuta 08:55
Re: Parallel INSERT (INTO ... SELECT ...) Bharath Rupireddy 09:01
RE: [Patch] Optimize dropping of relation buffers using dlist [email protected] 09:01
Re: Dynamic gathering the values for seq_page_cost/xxx_cost Ashutosh Bapat 09:15
RE: Transactions involving multiple postgres foreign servers, take 2 [email protected] 09:21
Re: FETCH FIRST clause PERCENT option 📎 Surafel Temesgen 09:25
RE: [Patch] Optimize dropping of relation buffers using dlist [email protected] 09:25
Re: [patch] Concurrent table reindex per-index progress reporting Matthias van de Meent 09:32
Re: Retry Cached Remote Connections for postgres_fdw in case remote backend gets killed/goes away 📎 Fujii Masao 09:51
Re: enable pg_stat_statements to track rows processed by REFRESH MATERIALIZED VIEW legrand legrand 10:04
Re: Online checksums verification in the backend Julien Rouhaud 10:11
Re: enable pg_stat_statements to track rows processed by REFRESH MATERIALIZED VIEW Fujii Masao 10:17
Re: Resetting spilled txn statistics in pg_stat_replication 📎 Amit Kapila 11:03
Re: BUG #16419: wrong parsing BC year in to_date() function Asif Rehman 11:39
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 11:41
Re: enable pg_stat_statements to track rows processed by REFRESH MATERIALIZED VIEW legrand legrand 11:57
Re: Parallel INSERT (INTO ... SELECT ...) Amit Kapila 12:17
Re: Retry Cached Remote Connections for postgres_fdw in case remote backend gets killed/goes away 📎 Bharath Rupireddy 12:19
Re: Feature improvement for FETCH tab completion 📎 Fujii Masao 12:46
Re: Dumping/restoring fails on inherited generated column 📎 Peter Eisentraut 13:07
Re: Parallel INSERT (INTO ... SELECT ...) Bharath Rupireddy 13:09
Re: Dumping/restoring fails on inherited generated column Daniel Gustafsson 13:51
Re: Transactions involving multiple postgres foreign servers, take 2 Masahiko Sawada 14:11
Re: Dumping/restoring fails on inherited generated column Tom Lane 14:16
Re: Probable documentation errors or improvements 📎 Justin Pryzby 14:30
Re: gs_group_1 crashing on 13beta2/s390x Christoph Berg 14:30
Re: gs_group_1 crashing on 13beta2/s390x Christoph Berg 14:37
Re: gs_group_1 crashing on 13beta2/s390x Christoph Berg 15:29
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 15:52
Optimize memory allocation code 📎 Li Japin 16:14
Re: Load TIME fields - proposed performance improvement 📎 Tom Lane 16:17
Re: gs_group_1 crashing on 13beta2/s390x Andres Freund 16:42
Re: [HACKERS] [PATCH] Generic type subscripting Pavel Stehule 16:43
Re: gs_group_1 crashing on 13beta2/s390x Christoph Berg 17:05
Re: "cert" + clientcert=verify-ca in pg_hba.conf? Bruce Momjian 17:30
Re: New statistics for tuning WAL buffer size Fujii Masao 17:36
Re: gs_group_1 crashing on 13beta2/s390x Ranier Vilela 17:36
Re: history file on replica and double switchover Grigory Smolkin 17:58
Re: gs_group_1 crashing on 13beta2/s390x Ranier Vilela 18:05
Re: gs_group_1 crashing on 13beta2/s390x Tom Lane 18:11
Re: Problem of ko.po on branch REL9_5_STABLE Alvaro Herrera 18:18
Re: Asynchronous Append on postgres_fdw nodes. Andrey Lepikhov 18:34
Re: history file on replica and double switchover 📎 Fujii Masao 19:05
Re: scram-sha-256 broken with FIPS and OpenSSL 1.0.2 Bruce Momjian 19:13
Re: gs_group_1 crashing on 13beta2/s390x Andres Freund 19:14
Re: gs_group_1 crashing on 13beta2/s390x Andres Freund 19:23
Re: scram-sha-256 broken with FIPS and OpenSSL 1.0.2 John Scalia 19:38
Re: scram-sha-256 broken with FIPS and OpenSSL 1.0.2 Bruce Momjian 19:39
Re: scram-sha-256 broken with FIPS and OpenSSL 1.0.2 John Scalia 19:48
Re: extension patch of CREATE OR REPLACE TRIGGER Tom Lane 20:11
Re: history file on replica and double switchover David Zhang 20:34
Re: pg_upgrade: fail early if a tablespace dir already exists for new cluster version 📎 Justin Pryzby 20:47
Re: Libpq support to connect to standby server as priority Tom Lane 21:58
What does pg_stat_get_xact_function_self_time count exactly? Chapman Flack 22:24
a potential size overflow issue 📎 David Zhang 23:39

Sept. 26, 2020

Thread Author Time
Re: Optimize memory allocation code Julien Rouhaud 00:09
Re: Dynamic gathering the values for seq_page_cost/xxx_cost Andy Fan 00:16
Re: Optimize memory allocation code Li Japin 00:32
Re: Optimize memory allocation code Merlin Moncure 00:37
Re: a potential size overflow issue Tom Lane 05:03
Re: Parallel INSERT (INTO ... SELECT ...) Amit Kapila 05:16
Re: Parallel INSERT (INTO ... SELECT ...) Amit Kapila 05:29
Re: Parallel INSERT (INTO ... SELECT ...) Bharath Rupireddy 05:30
Re: VACUUM PARALLEL option vs. max_parallel_maintenance_workers Amit Kapila 05:32
Re: Parallel INSERT (INTO ... SELECT ...) Amit Kapila 05:41
Re: Dynamic gathering the values for seq_page_cost/xxx_cost Julien Rouhaud 05:51
Re: [Patch] Optimize dropping of relation buffers using dlist Amit Kapila 06:09
Re: [Patch] Optimize dropping of relation buffers using dlist Amit Kapila 06:14
Re: Logical replication from PG v13 and below to PG v14 (devel version) is not working. Amit Kapila 06:16
Re: Parallel INSERT (INTO ... SELECT ...) Amit Kapila 06:37
Re: Dynamic gathering the values for seq_page_cost/xxx_cost Andy Fan 07:06
Re: Display individual query in pg_stat_activity 📎 Drouvot, Bertrand 07:37
Re: New statistics for tuning WAL buffer size Amit Kapila 10:18
Re: Asynchronous Append on postgres_fdw nodes. Etsuro Fujita 10:45
Re: Logical replication CPU-bound with TRUNCATE/DROP/CREATE many tables Amit Kapila 10:58
Avoid suspects casts VARHDRSZ (c.h) 📎 Ranier Vilela 14:20
Re: Get rid of runtime handling of AlternativeSubPlan? David Rowley 15:56
Re: Parallel INSERT (INTO ... SELECT ...) vignesh C 16:03
Re: Libpq support to connect to standby server as priority 📎 Tom Lane 18:34
enable_incremental_sort changes query behavior 📎 Jaime Casanova 18:49
Re: 回复：how to create index concurrently on partitioned table 📎 Justin Pryzby 19:56
Re: Get rid of runtime handling of AlternativeSubPlan? Tom Lane 21:03
Re: Avoid suspects casts VARHDRSZ (c.h) Tom Lane 21:49

Sept. 27, 2020

Thread Author Time
Re: More efficient RI checks - take 2 Justin Pryzby 02:59
Pedagogical example for KNN usage in GiST indexes? Esteban Zimanyi 08:08
Re: Get rid of runtime handling of AlternativeSubPlan? 📎 David Rowley 08:48
Re: Fwd: Extending range type operators to cope with elements 📎 Esteban Zimanyi 14:00
Wrong example in the bloom documentation 📎 Daniel Westermann (DWE) 15:58
Re: Get rid of runtime handling of AlternativeSubPlan? Tom Lane 15:59
Re: Fwd: Extending range type operators to cope with elements Tom Lane 17:06
Re: AppendStringInfoChar instead of appendStringInfoString Justin Pryzby 18:37
Partition prune with stable Expr 📎 Andy Fan 19:59
Re: Partition prune with stable Expr David Rowley 20:46
Small improvements to pg_list.h's linitial(), lsecond(), lthird() etc macros 📎 David Rowley 21:08
Re: Partition prune with stable Expr Andy Fan 21:35
Re: Partition prune with stable Expr Tom Lane 23:15
Re: Parallel INSERT (INTO ... SELECT ...) Greg Nancarrow 23:41
Re: Small improvements to pg_list.h's linitial(), lsecond(), lthird() etc macros Tom Lane 23:58

Sept. 28, 2020

Thread Author Time
Re: "cert" + clientcert=verify-ca in pg_hba.conf? Kyotaro Horiguchi 00:21
Planner making bad choice in alternative subplan decision David Rowley 00:22
RE: Use appendStringInfoString and appendPQExpBufferStr where possible 📎 Hou, Zhijie 00:47
Re: New statistics for tuning WAL buffer size Kyotaro Horiguchi 00:51
Re: Partition prune with stable Expr Andy Fan 00:54
Re: calling procedures is slow and consumes extra much memory against calling function 📎 Tom Lane 01:04
Re: Partition prune with stable Expr Tom Lane 01:15
Re: Range checks of pg_test_fsync --secs-per-test and pg_test_timing --duration Michael Paquier 01:19
Re: New statistics for tuning WAL buffer size 📎 Masahiro Ikeda 01:30
Re: Asynchronous Append on postgres_fdw nodes. Kyotaro Horiguchi 01:35
RE: Global snapshots [email protected] 01:36
Re: Small improvements to pg_list.h's linitial(), lsecond(), lthird() etc macros David Rowley 01:50
Re: Small improvements to pg_list.h's linitial(), lsecond(), lthird() etc macros Tom Lane 01:58
Re: Logical replication CPU-bound with TRUNCATE/DROP/CREATE many tables Keisuke Kuroda 02:20
Re: Feature improvement of tab completion for DEALLOCATE Fujii Masao 02:31
Re: Small improvements to pg_list.h's linitial(), lsecond(), lthird() etc macros Tom Lane 02:35
Re: New statistics for tuning WAL buffer size Amit Kapila 02:41
Re: Logical replication CPU-bound with TRUNCATE/DROP/CREATE many tables Amit Kapila 02:46
Re: Small improvements to pg_list.h's linitial(), lsecond(), lthird() etc macros David Rowley 02:47
RE: [Patch] Optimize dropping of relation buffers using dlist [email protected] 02:50
Re: Partition prune with stable Expr 📎 Andy Fan 02:51
Re: Load TIME fields - proposed performance improvement Peter Smith 02:51
Re: New statistics for tuning WAL buffer size Kyotaro Horiguchi 02:54
Re: Parallel INSERT (INTO ... SELECT ...) 📎 Greg Nancarrow 03:14
[PATCH] SET search_path += octopus 📎 Abhijit Menon-Sen 03:39
The return value of SPI_connect Hou, Zhijie 03:42
Re: New statistics for tuning WAL buffer size Amit Kapila 03:43
pgsql: Change SHA2 implementation based on OpenSSL to use EVP digest ro Michael Paquier 03:48
Re: scram-sha-256 broken with FIPS and OpenSSL 1.0.2 Michael Paquier 03:55
Re: Logical replication CPU-bound with TRUNCATE/DROP/CREATE many tables Keisuke Kuroda 04:31
RE: Transactions involving multiple postgres foreign servers, take 2 [email protected] 04:58
a problem about XLogReader callback system Wang, Shenhao 06:28
remove useless returns 📎 Tang, Haiying 06:42
Re: Partition prune with stable Expr Jesse Zhang 06:43
Re: Report error position in partition bound check Amit Langote 06:49
Re: Parallel copy Amit Kapila 06:49
Re: Yet another fast GiST build Heikki Linnakangas 06:53
Re: Partition prune with stable Expr Andy Fan 07:22
RE: [Patch] Optimize dropping of relation buffers using dlist [email protected] 07:29
__pg_log_level in anonynous enum should be initialized? (Was: pgsql: Change SHA2 implementation based on OpenSSL to use EVP digest ro) Michael Paquier 07:33
Re: [HACKERS] logical decoding of two-phase transactions 📎 Ajin Cherian 07:42
RE: [Patch] Optimize dropping of relation buffers using dlist [email protected] 08:07
Re: Yet another fast GiST build 📎 Heikki Linnakangas 08:12
Re: [HACKERS] logical decoding of two-phase transactions Amit Kapila 08:36
Re: Partition prune with stable Expr Juan José Santamaría Flecha 08:41
Re: Logical replication CPU-bound with TRUNCATE/DROP/CREATE many tables Amit Kapila 08:52
RE: [Patch] Optimize dropping of relation buffers using dlist 📎 [email protected] 08:57
Re: [HACKERS] logical decoding of two-phase transactions Ajin Cherian 09:01
Re: calling procedures is slow and consumes extra much memory against calling function Pavel Stehule 09:14
Re: Parallel copy Amit Kapila 09:31
Re: [HACKERS] [PATCH] Generic type subscripting Dmitry Dolgov 09:36
Re: [HACKERS] [PATCH] Generic type subscripting Pavel Stehule 09:39

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