Postgres picks suboptimal index after building extended statistics

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, 11 months ago)

Latest email 2022-11-22 17:14:50 (1 year, 11 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