Re: Extended statistics for correlated columns, row estimates when values are not in MCVs list

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: Extended statistics for correlated columns, row estimates when values are not in MCVs list
Дата
Msg-id CAMcsB=wSWvVwkj4NyuKFvyyPK+v0w=an700qUgy2k1Sj7G1raA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Extended statistics for correlated columns, row estimates when values are not in MCVs list  (Tomas Vondra <tomas.vondra@enterprisedb.com>)
Список pgsql-general
Дерево обсуждения
On Mon, Dec 7, 2020 at 8:31 AM Tomas Vondra <tomas.vondra@enterprisedb.com> wrote:
What you might try is defining the statistics with only the functional
dependencies. That should consider the column-level correlation even
when the combination of values is not in the MCV. It might make the
"good" estimate worse, but that's an inherent trade-off.

Thanks very much. Removing MCVs type works perfectly for my use cases. 

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

Предыдущее
От: Dirk Mika
Дата:
Сообщение: Re: Set COLLATE on a session level
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: JDBC driver - is "getGeneratedKeys()" guaranteed to return the ids in the same order a batch insert was made?