meaning of default_statistics_target

Поиск
Список
Период
Сортировка
От Martin Marques
Тема meaning of default_statistics_target
Дата
Msg-id 4815C2A5.4050300@marquesminen.com.ar
обсуждение исходный текст
Ответы Re: meaning of default_statistics_target
Список pgsql-general
I'm trying to understand the implications of changing the value of the
STATISTICS of a column with ALTER TABLE, and there are somethings I'm
not understanding correctly.

How much, and which extra statistics information will ANALYZE gather if
I set a higher value for one specific column (maybe one with and index,
and heavily used in SELECT clauses)? If instead of 100 I set a column to
250, which extra data will I see in pg_statistics after an ANALYZE?

Thanks.

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

Предыдущее
От: Lew
Дата:
Сообщение: Re: timestamp with time zone output incorrect
Следующее
От: Pascal Cohen
Дата:
Сообщение: varchar or text