Postgres picks suboptimal index after building extended statistics

Title

Topic

Performance

Created

2021-07-12 06:04:33

Last modified

2022-08-01 16:53:14 (2 weeks, 1 day ago)

Latest email

2022-07-11 07:57:36 (1 month 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

Authors

Andrey Lepikhov (lepikhov)

Reviewers

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