pgsql: Provide statistics for hypothetical BRIN indexes
От | Michael Paquier |
---|---|
Тема | pgsql: Provide statistics for hypothetical BRIN indexes |
Дата | |
Msg-id | E1iXbD6-000147-4l@gemulon.postgresql.org обсуждение исходный текст |
Список | pgsql-committers |
Provide statistics for hypothetical BRIN indexes Trying to use hypothetical indexes with BRIN currently fails when trying to access a relation that does not exist when looking for the statistics. With the current API, it is not possible to easily pass a value for pages_per_range down to the hypothetical index, so this makes use of the default value of BRIN_DEFAULT_PAGES_PER_RANGE, which should be fine enough in most cases. Being able to refine or enforce the hypothetical costs in more optimistic ways would require more refactoring by filling in the statistics when building IndexOptInfo in plancat.c. This would involve ABI breakages around the costing routines, something not fit for stable branches. This is broken since 7e534ad, so backpatch down to v10. Author: Julien Rouhaud, Heikki Linnakangas Reviewed-by: Álvaro Herrera, Tom Lane, Michael Paquier Discussion: https://postgr.es/m/CAOBaU_ZH0LKEA8VFCocr6Lpte1ab0b6FpvgS0y4way+RPSXfYg@mail.gmail.com Backpatch-through: 10 Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/168d2064001f704965899bb2057591271c44e57a Modified Files -------------- src/backend/utils/adt/selfuncs.c | 37 ++++++++++++++++++++++++++++--------- 1 file changed, 28 insertions(+), 9 deletions(-)
В списке pgsql-committers по дате отправления: