Postgres picks suboptimal index after building extended statistics

Edit
ID 3245
Title Postgres picks suboptimal index after building extended statistics
Topic Performance
Created 2021-07-12 06:04:33
Last modified 2022-11-24 04:38:51 (1 year, 10 months ago)
Latest email 2022-11-22 17:14:50 (1 year, 10 months ago)
Status
2022-11: Withdrawn
2022-09: Moved to next CF
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 Andrei Lepikhov (lepikhov)
Reviewers Become reviewer
Committer
Links CFbot results (CirrusCI) CFbot GitHub
Checkout latest CFbot patchset Go to your local checkout of the PostgreSQL repository and run:
git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/3245
git checkout commitfest/cf/3245
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-11-22 17:14:50 by Andres Freund <andres at anarazel.de>
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-11-24 04:38:51 Andrei Lepikhov (lepikhov) Closed in commitfest 2022-11 with status: Withdrawn
2022-10-12 08:31:25 Michael Paquier (michael-kun) Closed in commitfest 2022-09 with status: Moved to next CF
2022-10-12 08:31:22 Michael Paquier (michael-kun) New status: Waiting on Author
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 Andrei Lepikhov (lepikhov) Changed authors to Andrey Lepikhov (lepikhov)
2021-07-12 06:05:13 Andrei Lepikhov (lepikhov) Changed targetversion to 14
2021-07-12 06:04:34 Andrei Lepikhov (lepikhov) Attached mail thread 0ca4553c-1f34-12ba-9122-44199d1ced41@postgrespro.ru
2021-07-12 06:04:34 Andrei Lepikhov (lepikhov) Created patch record
Edit