Re: VACUUM Question

Поиск
Список
Период
Сортировка
От Joseph Shraibman
Тема Re: VACUUM Question
Дата
Msg-id 40C0C475.8070609@selectacast.net
обсуждение исходный текст
Ответ на Re: VACUUM Question  (Greg Stark <gsstark@mit.edu>)
Ответы Re: VACUUM Question  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Greg Stark wrote:
> Alex <alex@meerkatsoft.com> writes:
>

> There won't be anything to VACUUM after the insert, but perhaps you still want
> to run ANALYZE. Note that a plain ANALYZE uses a statistical sample which is
> much faster, whereas VACUUM ANALYZE has to look at every record anyways so
> it's slower but produces more accurate statistics. If you don't have

That is not true.  My nightly vacuum analyze clearly is sampling:

INFO:  "tablename": 22102 pages, 30000 rows sampled, 1712934 estimated
total rows

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

Предыдущее
От: Keary Suska
Дата:
Сообщение: Re: Building Thread-Safe on OS X
Следующее
От: Rick Gigger
Дата:
Сообщение: Re: [HACKERS] Slony-I goes BETA