Re: automatic REINDEX-ing

Поиск
Список
Период
Сортировка
Искать
От
Ow Mun Heng
Тема
Re: automatic REINDEX-ing
Дата
Msg-id
1218599219.24223.18.camel@neuromancer.home.net
Ответ на
Re: automatic REINDEX-ing (Lennin Caro)
Список
Дерево обсуждения
automatic REINDEX-ing Joao Ferreira gmail <joao.miguel.c.ferreira@gmail.com>
Re: automatic REINDEX-ing Tom Lane <tgl@sss.pgh.pa.us>
Re: automatic REINDEX-ing Joao Ferreira gmail <joao.miguel.c.ferreira@gmail.com>
Re: automatic REINDEX-ing Bill Moran <wmoran@collaborativefusion.com>
Re: automatic REINDEX-ing Kevin Hunter <hunteke@earlham.edu>
Re: automatic REINDEX-ing Martijn van Oosterhout <kleptog@svana.org>
Re: automatic REINDEX-ing Joao Ferreira gmail <joao.miguel.c.ferreira@gmail.com>
Re: automatic REINDEX-ing Kevin Hunter <hunteke@earlham.edu>
Re: automatic REINDEX-ing Martijn van Oosterhout <kleptog@svana.org>
Re: automatic REINDEX-ing Kevin Hunter <hunteke@earlham.edu>
Re: automatic REINDEX-ing Tino Wildenhain <tino@wildenhain.de>
Re: automatic REINDEX-ing Alvaro Herrera <alvherre@commandprompt.com>
Re: automatic REINDEX-ing Tom Lane <tgl@sss.pgh.pa.us>
Re: automatic REINDEX-ing Alvaro Herrera <alvherre@commandprompt.com>
Re: automatic REINDEX-ing "Scott Marlowe" <scott.marlowe@gmail.com>
Re: automatic REINDEX-ing William Garrison <postgres@mobydisk.com>
Re: automatic REINDEX-ing "Scott Marlowe" <scott.marlowe@gmail.com>
Re: automatic REINDEX-ing Lennin Caro <lennin.caro@yahoo.com>
Re: automatic REINDEX-ing Ow Mun Heng <Ow.Mun.Heng@wdc.com> 
On Tue, 2008-08-12 at 08:38 -0700, Lennin Caro wrote:
> you can use a cron job
> 

I have my cron setup to do database wide vacuums each night and it
usually takes ~between 4-6 hours on ~200G DB size. 

On days where there is huge activity, it can drag on for like 15+ hours.

I've recently dropped all my indexes and started to only rebuild _some_
needed ones.


What's the method for looking at index bloats anyway?
В списке pgsql-general по дате отправления
Предыдущее
От: Craig Ringer
Дата:
Следующее
От: Sathish Duraiswamy
Дата:
FAQ