Postgres picks suboptimal index after building extended statistics

Edit
Title Postgres picks suboptimal index after building extended statistics
Topic Performance
Created 2021-07-12 06:04:33
Last modified 2022-08-01 16:53:14 (1 month, 3 weeks ago)
Latest email 2022-07-11 07:57:36 (2 months, 2 weeks ago)
Status
2022-09: Needs review
2022-07: Moved to next CF
2022-03: Moved to next CF
2022-01: Moved to next CF
2021-11: Moved to next CF
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 2022-07-11 07:57:36 by Andrey Lepikhov <a.lepikhov at postgrespro.ru>
Latest attachment (0001-Use-Index-path-with-the-best-selectivity-estimation.patch) at 2022-07-11 07:57:36 from Andrey Lepikhov <a.lepikhov at postgrespro.ru>
    Attachment (0001-Use-Index-path-with-the-best-selectivity-estimation.patch) at 2022-07-11 07:57:36 from Andrey Lepikhov <a.lepikhov at postgrespro.ru> (Patch: Yes)
    Attachment (badestimate.sql) at 2022-07-07 22:07:36 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: No)
    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
2022-08-01 16:53:14 Jacob Champion (jchampion) Closed in commitfest 2022-07 with status: Moved to next CF
2022-04-08 13:12:50 Greg Stark (stark) Closed in commitfest 2022-03 with status: Moved to next CF
2022-02-02 16:33:44 Julien Rouhaud (rjuju) Closed in commitfest 2022-01 with status: Moved to next CF
2021-12-29 13:21:43 Justin Pryzby (justinpryzby) Changed name to Postgres picks suboptimal index after building extended statistics
2021-12-02 21:40:49 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2021-11 with status: Moved to next CF
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