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

May 29, 2020

Thread Author Time
Re: Make the qual cost on index Filter slightly higher than qual cost on index Cond. Tomas Vondra 00:16
Re: Trouble with hashagg spill I/O pattern and costing 📎 Jeff Davis 00:48
Re: segmentation fault using currtid and partitioned tables Andres Freund 00:55
Re: Make the qual cost on index Filter slightly higher than qual cost on index Cond. Tom Lane 01:04
Re: segmentation fault using currtid and partitioned tables Andres Freund 01:05
Re: Make the qual cost on index Filter slightly higher than qual cost on index Cond. Andy Fan 01:10
Re: segmentation fault using currtid and partitioned tables Tom Lane 01:11
Re: Trouble with hashagg spill I/O pattern and costing Jeff Davis 01:14
Re: Make the qual cost on index Filter slightly higher than qual cost on index Cond. Andy Fan 01:20
Re: Problem with pg_atomic_compare_exchange_u64 at 32-bit platforms Andres Freund 01:46
Re: SIGSEGV from START_REPLICATION 0/XXXXXXX in XLogSendPhysical () at walsender.c:2762 Kyotaro Horiguchi 03:10
feature idea: use index when checking for NULLs before SET NOT NULL John Bachir 03:24
Re: speed up unicode normalization quick check John Naylor 03:54
Speeding up parts of the planner using a binary search tree structure for nodes 📎 David Rowley 05:16
Re: Incorrect comment in be-secure-openssl.c Michael Paquier 05:38
Re: Internal key management system 📎 Masahiko Sawada 05:49
Re: OpenSSL 3.0.0 compatibility Laurenz Albe 06:06
RE: archive status ".ready" files may be created too early matsumura.ryo@fujitsu.com 06:41
Re: segmentation fault using currtid and partitioned tables 📎 Michael Paquier 06:48
Re: feature idea: use index when checking for NULLs before SET NOT NULL Sergei Kornilov 06:56
Re: OpenSSL 3.0.0 compatibility Daniel Gustafsson 07:04
Re: SIGSEGV from START_REPLICATION 0/XXXXXXX in XLogSendPhysical () at walsender.c:2762 Michael Paquier 07:21
Re: race condition when writing pg_control Fujii Masao 07:24
Re: feature idea: use index when checking for NULLs before SET NOT NULL Oleksandr Shulgin 07:26
Re: password_encryption default Michael Paquier 07:33
Does PG server process keep backend info brajmohan saxena 08:12
Re: SIGSEGV from START_REPLICATION 0/XXXXXXX in XLogSendPhysical () at walsender.c:2762 Kyotaro Horiguchi 08:56
Re: SIGSEGV from START_REPLICATION 0/XXXXXXX in XLogSendPhysical () at walsender.c:2762 Masahiko Sawada 09:09
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Amit Kapila 09:24
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Amit Kapila 10:22
Re: OpenSSL 3.0.0 compatibility Peter Eisentraut 11:34
Re: feature idea: use index when checking for NULLs before SET NOT NULL John Bachir 12:08
Re: OpenSSL 3.0.0 compatibility Daniel Gustafsson 12:45
Re: feature idea: use index when checking for NULLs before SET NOT NULL Darafei Komяpa Praliaskouski 12:56
Re: Trouble with hashagg spill I/O pattern and costing 📎 Tomas Vondra 13:04
Re: password_encryption default Jonathan S. Katz 13:13
pg_dump fail to not dump public schema orders 📎 Adrien Nayrat 13:13
Re: password_encryption default Stephen Frost 13:18
Re: feature idea: use index when checking for NULLs before SET NOT NULL Sergei Kornilov 13:21
Re: password_encryption default Stephen Frost 13:22
Re: password_encryption default Jonathan S. Katz 13:23
Re: password_encryption default Tom Lane 13:34
Re: Make the qual cost on index Filter slightly higher than qual cost on index Cond. Ashutosh Bapat 13:37
Re: Speeding up parts of the planner using a binary search tree structure for nodes Ashutosh Bapat 13:52
Re: pg_dump fail to not dump public schema orders David G. Johnston 13:56
Re: Make the qual cost on index Filter slightly higher than qual cost on index Cond. Andy Fan 13:58
Re: Make the qual cost on index Filter slightly higher than qual cost on index Cond. 📎 Andy Fan 14:11
proposal: possibility to read dumped table's name from file 📎 Pavel Stehule 14:21
Re: proposal: possibility to read dumped table's name from file Tom Lane 14:28
Re: pg_dump fail to not dump public schema orders Tom Lane 14:40
Re: pg_dump fail to not dump public schema orders Adrien Nayrat 14:42
PG function with pseudotype "anyelement" for IN, OUT parameter shows wrong behaviour. Prabhat Sahu 14:44
Re: proposal: possibility to read dumped table's name from file Pavel Stehule 14:47
Re: PG function with pseudotype "anyelement" for IN, OUT parameter shows wrong behaviour. Pavel Stehule 14:59
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions 📎 Dilip Kumar 15:00
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Dilip Kumar 15:01
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Dilip Kumar 15:01
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Dilip Kumar 15:01
Re: proposal: possibility to read dumped table's name from file David Fetter 15:28
Re: PG function with pseudotype "anyelement" for IN, OUT parameter shows wrong behaviour. Prabhat Sahu 15:31
Re: proposal: possibility to read dumped table's name from file Tom Lane 16:03
Re: speed up unicode normalization quick check Mark Dilger 16:13
Re: proposal: possibility to read dumped table's name from file Pavel Stehule 16:14
Re: pie-in-sky idea: 'sensitive' function parameters Chapman Flack 16:38
Re: Expand the use of check_canonical_path() for more GUCs Robert Haas 17:24
Re: pg_dump fail to not dump public schema orders David G. Johnston 17:40
Re: Expand the use of check_canonical_path() for more GUCs Alvaro Herrera 18:14
Re: proposal: possibility to read dumped table's name from file Justin Pryzby 18:25
Re: pie-in-sky idea: 'sensitive' function parameters Robert Haas 18:51
Re: pie-in-sky idea: 'sensitive' function parameters Chapman Flack 19:05
Re: Internal key management system Robert Haas 19:20
Re: pie-in-sky idea: 'sensitive' function parameters Tom Lane 19:26
Re: pie-in-sky idea: 'sensitive' function parameters Robert Haas 19:28
Re: pie-in-sky idea: 'sensitive' function parameters Robert Haas 19:32
Re: pie-in-sky idea: 'sensitive' function parameters Chapman Flack 19:36
Re: Default gucs for EXPLAIN Robert Haas 19:44
Re: pie-in-sky idea: 'sensitive' function parameters Tom Lane 19:47
Re: Trouble with hashagg spill I/O pattern and costing Jeff Davis 20:12
Re: Read access for pg_monitor to pg_replication_origin_status view 📎 Martín Marqués 20:39
Re: [PATCH] Fix install-tests target for vpath builds 📎 Andrew Dunstan 21:58
Re: [PATCH] Fix install-tests target for vpath builds Alvaro Herrera 22:37

May 30, 2020

Thread Author Time
Re: feature idea: use index when checking for NULLs before SET NOT NULL John Bachir 01:53
Re: feature idea: use index when checking for NULLs before SET NOT NULL Justin Pryzby 02:10
Re: Inlining of couple of functions in pl_exec.c improves performance Amit Khandekar 05:28
Re: Inlining of couple of functions in pl_exec.c improves performance Pavel Stehule 05:40
Re: speed up unicode normalization quick check John Naylor 06:52
Re: pg_dump fail to not dump public schema orders Adrien Nayrat 08:23
Re: OpenSSL 3.0.0 compatibility Peter Eisentraut 09:29
Re: OpenSSL 3.0.0 compatibility Andrew Dunstan 12:34

May 31, 2020

Thread Author Time
Re: Read access for pg_monitor to pg_replication_origin_status view Michael Paquier 02:02
Re: Inlining of couple of functions in pl_exec.c improves performance Michael Paquier 02:34
Re: OpenSSL 3.0.0 compatibility Michael Paquier 02:52
Re: Incorrect comment in be-secure-openssl.c Michael Paquier 06:54
Proposal: remove string "contains errors; unaffected changes were applied" Антон Пацев 07:43
Re: Internal key management system Fabien COELHO 08:13
A wrong index choose issue because of inaccurate statistics 📎 Andy Fan 13:24
Re: Read access for pg_monitor to pg_replication_origin_status view Martín Marqués 15:13
Compatible defaults for LEAD/LAG 📎 Vik Fearing 17:20
Re: Proposal: remove string "contains errors; unaffected changes were applied" Justin Pryzby 17:31
Re: Compatible defaults for LEAD/LAG Tom Lane 19:53
Re: Compatible defaults for LEAD/LAG Vik Fearing 20:02
Re: race condition when writing pg_control 📎 Bossart, Nathan 21:11
Re: Incorrect comment in be-secure-openssl.c Robert Haas 21:47
Re: Add MAIN_RELATION_CLEANUP and SECONDARY_RELATION_CLEANUP options to VACUUM 📎 Bossart, Nathan 22:13
Re: archive status ".ready" files may be created too early Bossart, Nathan 22:28
Re: Compatible defaults for LEAD/LAG Vik Fearing 23:30

June 1, 2020

Thread Author Time
Re: Default gucs for EXPLAIN David Fetter 01:00
Re: segmentation fault using currtid and partitioned tables Michael Paquier 01:57
Re: Compatible defaults for LEAD/LAG Tom Lane 02:07
Re: segmentation fault using currtid and partitioned tables 📎 Michael Paquier 02:20
Re: segmentation fault using currtid and partitioned tables Tom Lane 02:26
Re: Compatible defaults for LEAD/LAG Pavel Stehule 03:35
Re: Inlining of couple of functions in pl_exec.c improves performance Amit Khandekar 05:53
Re: segmentation fault using currtid and partitioned tables Michael Paquier 05:55
Re: Inlining of couple of functions in pl_exec.c improves performance Amit Khandekar 06:02
Re: Incorrect comment in be-secure-openssl.c Michael Paquier 06:06
Re: Internal key management system Masahiko Sawada 06:34
Re: Inlining of couple of functions in pl_exec.c improves performance Pavel Stehule 06:56
Re: Internal key management system Masahiko Sawada 06:58
Re: Strange decreasing value of pg_last_wal_receive_lsn() godjan • 07:44
Re: OpenSSL 3.0.0 compatibility Peter Eisentraut 08:33
Re: Incorrect comment in be-secure-openssl.c Daniel Gustafsson 08:39
Re: OpenSSL 3.0.0 compatibility Peter Eisentraut 08:44
Re: OpenSSL 3.0.0 compatibility Daniel Gustafsson 08:49
Re: shared-memory based stats collector 📎 Kyotaro Horiguchi 09:00
[POC] Fast COPY FROM command for the table with foreign partitions 📎 Andrey Lepikhov 09:29
Re: pg_dump dumps row level policies on extension tables Masahiko Sawada 11:08
Re: OpenSSL 3.0.0 compatibility Andrew Dunstan 11:58
Re: OpenSSL 3.0.0 compatibility Daniel Gustafsson 12:03
Re: OpenSSL 3.0.0 compatibility 📎 Andrew Dunstan 13:23
Wrong width of UNION statement Kenichiro Tanaka 13:35
Re: Inlining of couple of functions in pl_exec.c improves performance Amit Khandekar 13:59
Re: OpenSSL 3.0.0 compatibility Tom Lane 14:00
Re: feature idea: use index when checking for NULLs before SET NOT NULL John Bachir 14:49
Re: Wrong width of UNION statement Tom Lane 15:04
Re: Compatible defaults for LEAD/LAG Tom Lane 15:36
Small code cleanup 📎 Mark Dilger 15:37
Re: Small code cleanup Tom Lane 15:53
Re: Small code cleanup Mark Dilger 16:23
Re: Compatible defaults for LEAD/LAG Pavel Stehule 16:26
Re: Small code cleanup Tom Lane 16:59
Re: Small code cleanup Mark Dilger 17:07
Re: Read access for pg_monitor to pg_replication_origin_status view 📎 Martín Marqués 18:38
Re: Just for fun: Postgres 20? Robert Haas 19:11
Re: Just for fun: Postgres 20? Tom Lane 19:20
Re: Speeding up parts of the planner using a binary search tree structure for nodes David Rowley 21:42
Re: Another modest proposal for docs formatting: catalog descriptions Josef Šimánek 22:40
Re: Another modest proposal for docs formatting: catalog descriptions Tom Lane 22:57
Re: Another modest proposal for docs formatting: catalog descriptions Jonathan S. Katz 23:17

June 2, 2020

Thread Author Time
Re: [POC] Fast COPY FROM command for the table with foreign partitions Etsuro Fujita 00:02
Re: Postgres Windows build system doesn't work with python installed in Program Files David Zhang 00:05
Re: Read access for pg_monitor to pg_replication_origin_status view Martín Marqués 00:41
Re: feature idea: use index when checking for NULLs before SET NOT NULL John Bachir 01:55
Re: feature idea: use index when checking for NULLs before SET NOT NULL Justin Pryzby 02:04
Re: feature idea: use index when checking for NULLs before SET NOT NULL John Bachir 02:22
Small doc improvement about spilled txn tracking 📎 Masahiko Sawada 03:40
Re: making update/delete of inheritance trees scale better 📎 Amit Langote 04:15
Re: SIGSEGV from START_REPLICATION 0/XXXXXXX in XLogSendPhysical () at walsender.c:2762 📎 Michael Paquier 04:24
Re: Read access for pg_monitor to pg_replication_origin_status view Michael Paquier 04:49
Re: Small doc improvement about spilled txn tracking Amit Kapila 04:52
Re: Read access for pg_monitor to pg_replication_origin_status view Kyotaro Horiguchi 05:01
Re: SIGSEGV from START_REPLICATION 0/XXXXXXX in XLogSendPhysical () at walsender.c:2762 Fujii Masao 05:23
Re: race condition when writing pg_control Michael Paquier 05:24
Re: Small doc improvement about spilled txn tracking 📎 Amit Kapila 05:49
Re: [POC] Fast COPY FROM command for the table with foreign partitions 📎 Andrey Lepikhov 05:51
Re: Small doc improvement about spilled txn tracking Masahiko Sawada 05:59
Re: SIGSEGV from START_REPLICATION 0/XXXXXXX in XLogSendPhysical () at walsender.c:2762 Kyotaro Horiguchi 06:05
Re: Small doc improvement about spilled txn tracking Amit Kapila 06:15
Resetting spilled txn statistics in pg_stat_replication Masahiko Sawada 06:17
Re: Small doc improvement about spilled txn tracking Masahiko Sawada 06:18
Re: Resetting spilled txn statistics in pg_stat_replication Kyotaro Horiguchi 07:00
elog(DEBUG2 in SpinLocked section. 📎 Kyotaro Horiguchi 07:15
Re: More tests with USING INDEX replident and dropped indexes Masahiko Sawada 07:46
Re: Resetting spilled txn statistics in pg_stat_replication Fujii Masao 08:22
Re: elog(DEBUG2 in SpinLocked section. Fujii Masao 08:35
Re: elog(DEBUG2 in SpinLocked section. Amit Kapila 08:42
Re: OpenSSL 3.0.0 compatibility Peter Eisentraut 08:57
Re: Expand the use of check_canonical_path() for more GUCs Peter Eisentraut 09:04
Re: Hybrid Hash/Nested Loop joins and caching results from subplans 📎 Andy Fan 09:04
Re: Proposal: remove string "contains errors; unaffected changes were applied" Антон Пацев 09:33
Re: Resetting spilled txn statistics in pg_stat_replication Amit Kapila 09:34
Re: Resetting spilled txn statistics in pg_stat_replication Masahiko Sawada 09:38
Re: Resetting spilled txn statistics in pg_stat_replication Amit Kapila 09:40
Re: elog(DEBUG2 in SpinLocked section. Fujii Masao 10:24
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Dilip Kumar 10:28
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Amit Kapila 11:25
Add LWLock blocker(s) information 📎 Drouvot, Bertrand 12:24
Re: Index Skip Scan Andy Fan 12:36
Re: Resetting spilled txn statistics in pg_stat_replication Masahiko Sawada 13:24
Re: Index Skip Scan Dmitry Dolgov 13:40
Re: Strange decreasing value of pg_last_wal_receive_lsn() Jehan-Guillaume de Rorthais 14:11
Re: PATCH: logical_work_mem and logical streaming of large in-progress transactions Dilip Kumar 14:22
Re: Read access for pg_monitor to pg_replication_origin_status view Martín Marqués 14:23
Re: Additional Chapter for Tutorial 📎 Jürgen Purtz 15:01
Re: Read access for pg_monitor to pg_replication_origin_status view Stephen Frost 15:11
Re: Read access for pg_monitor to pg_replication_origin_status view 📎 Martín Marqués 16:13
Re: Command statistics system (cmdstats) 📎 Mark Dilger 16:58
Re: Command statistics system (cmdstats) 📎 Mark Dilger 17:02
Re: what can go in root.crt ? Bruce Momjian 17:14
Re: Default gucs for EXPLAIN Bruce Momjian 17:25

Browse Archives

Prev | Next