Re: Multivariate MCV list vs. statistics target

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: Multivariate MCV list vs. statistics target
Дата
Msg-id CAKJS1f9M1mmdfW0G+PS-dgO2xdPer9LsPkaH3e6c2GEnrW-XKw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Multivariate MCV list vs. statistics target  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
On Fri, 21 Jun 2019 at 19:09, Dean Rasheed <dean.a.rasheed@gmail.com> wrote:
> Hmm, maybe. I can certainly understand your dislike of using text[].
> I'm not sure that we can confidently say that multivariate statistics
> won't ever need additional tuning knobs, but I have no idea at the
> moment what they might be, and nothing else has come up so far in all
> the time spent considering MCV lists and histograms, so maybe this is
> OK.

I agree with having the stxstattarget column. Even if something did
come up in the future, then we could consider merging the
stxstattarget column with a new text[] column at that time.

-- 
 David Rowley                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Goel, Dhruv"
Дата:
Сообщение: Re: Avoiding deadlock errors in CREATE INDEX CONCURRENTLY
Следующее
От: Fabien COELHO
Дата:
Сообщение: Re: make \d pg_toast.foo show its indices ; and, \d toast show itsmain table ; and \d relkind=I show its partitions (and tablespace)