Re: Query optimizer 8.0.1 (and 8.0)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Query optimizer 8.0.1 (and 8.0)
Дата
Msg-id 17961.1107555455@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Query optimizer 8.0.1 (and 8.0)  (pgsql@mohawksoft.com)
Ответы Re: Query optimizer 8.0.1 (and 8.0)
Список pgsql-hackers
pgsql@mohawksoft.com writes:
> I suspect that analyze only samples a very small amount of the database
> and gets the wrong idea about it. Is there a way to force analyze to
> sample more  rows?

default_statistics_target.  But let's see the pg_stats rows for these
columns before assuming that analyze is getting it wrong.
        regards, tom lane


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