Postgres picks suboptimal index after building extended statistics

Title

Topic

Performance

Created

2021-07-12 06:04:33

Last modified

2021-12-29 13:21:43 (2 weeks, 5 days ago)

Latest email

2021-08-30 06:44:28 (4 months, 2 weeks ago)

Status

2022-01: Needs review

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 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-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