Postgres picks suboptimal index after building of an extended statistics

Edit
Title Postgres picks suboptimal index after building of an extended statistics
Topic Performance
Created 2021-07-12 06:04:33
Last modified 2021-10-04 07:32:17 (3 weeks, 2 days ago)
Latest email 2021-08-30 06:44:28 (1 month, 4 weeks ago)
Status
2021-11: Needs review
2021-09: Moved to next CF
Target version 14
Authors Andrey Lepikhov (lepikhov)
Reviewers Become reviewer
Committer
Links
Emails
Postgres picks suboptimal index after building of an extended statistics
First at 2021-06-23 14:19:26 by "Andrey V. Lepikhov" <a.lepikhov at postgrespro.ru>
Latest at 2021-08-30 06:44:28 by Andrey Lepikhov <a.lepikhov at postgrespro.ru>
Latest attachment (0001-Estimating-number-of-fetched-rows-in-a-btree-index-w.patch) at 2021-08-30 06:44:28 from Andrey Lepikhov <a.lepikhov at postgrespro.ru>
    Attachment (0001-Estimating-number-of-fetched-rows-in-a-btree-index-w.patch) at 2021-08-30 06:44:28 from Andrey Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
    Attachment (v2-0001-In-the-case-of-an-unique-one-row-btree-index-scan-on.patch) at 2021-08-13 07:01:24 from "Andrey V. Lepikhov" <a.lepikhov at postgrespro.ru> (Patch: Yes)
    Attachment (t.sql) at 2021-06-23 14:19:26 from "Andrey V. Lepikhov" <a.lepikhov at postgrespro.ru> (Patch: No)
History
When Who What
2021-10-04 07:32:17 Jaime Casanova (jcasanov) Closed in commitfest 2021-09 with status: Moved to next CF
2021-07-12 06:05:13 Andrey Lepikhov (lepikhov) Changed authors to Andrey Lepikhov (lepikhov)
2021-07-12 06:05:13 Andrey Lepikhov (lepikhov) Changed targetversion to 14
2021-07-12 06:04:34 Andrey Lepikhov (lepikhov) Attached mail thread 0ca4553c-1f34-12ba-9122-44199d1ced41@postgrespro.ru
2021-07-12 06:04:34 Andrey Lepikhov (lepikhov) Created patch record
Edit