Postgres picks suboptimal index after building extended statistics

Edit
ID 3245
Title Postgres picks suboptimal index after building extended statistics
CI (CFBot) Not processed
Stats (from CFBot) Unknown
Topic Performance
Tags
Created 2021-07-12 06:04:33
Last modified 2022-11-24 04:38:51 (2 years ago)
Latest email 2022-11-22 17:14:50 (2 years ago)
Status
2022-11 (2022-11-01 – 2022-11-30): Withdrawn
2022-09 (2022-09-01 – 2022-09-30): Moved to different CF
2022-07 (2022-07-01 – 2022-07-31): Moved to different CF
2022-03 (2022-03-01 – 2022-03-31): Moved to different CF
2022-01 (2022-01-01 – 2022-01-31): Moved to different CF
2021-11 (2021-11-01 – 2021-11-30): Moved to different CF
2021-09 (2021-09-01 – 2021-09-30): Moved to different CF
Target version 14
Authors Andrei 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-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