Re: good old VACUUM FULL

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: good old VACUUM FULL
Дата
Msg-id 4D95496E.1050407@postnewspapers.com.au
обсуждение исходный текст
Ответ на Re: good old VACUUM FULL  (Chris <dmagick@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
On 23/03/2011 12:24 PM, Chris wrote:

> You'll need to reindex that table now - vacuum full can bloat your
> indexes which will affect your other queries.

It doesn't seem to matter much for a one-off. Index bloat problems have
mainly been encountered where people are running VACUUM FULL as part of
routine maintenance - for example, from a nightly cron job.

--
Craig Ringer

Tech-related writing at http://soapyfrogs.blogspot.com/

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

Предыдущее
От: Joseph Shraibman
Дата:
Сообщение: table contraints checks only happen in planner phase
Следующее
От: Greg Smith
Дата:
Сообщение: Re: COPY with high # of clients, partitioned table locking issues?