Re: default_statistics_target WAS: max_wal_senders must die

Поиск
Список
Период
Сортировка
От Nathan Boley
Тема Re: default_statistics_target WAS: max_wal_senders must die
Дата
Msg-id AANLkTinsGBjF=wh-N0XuujWB_es8VmAqgGMq=OwfxM7Y@mail.gmail.com
обсуждение исходный текст
Ответ на Re: default_statistics_target WAS: max_wal_senders must die  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
> That one's used, too, but the other is used as an upper bound.
> n_distinct tends to come out too small on large tables, so that
> formula is prone to overestimation.  Actually, both formulas are prone
> to overestimation.
>

Right - thanks.

> When this happens depends on the values of a whole boat-load of GUCs...

Well, then doesn't the 'proper' number of buckets depend on a whole
boat-load of GUCs...

-Nathan


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: lazy snapshots?
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: default_statistics_target WAS: max_wal_senders must die