Re: automatic REINDEX-ing

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: automatic REINDEX-ing
Дата
Msg-id
8016.1218556438@sss.pgh.pa.us
Ответ на
automatic REINDEX-ing (Joao Ferreira gmail)
Список
Дерево обсуждения
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> 
Joao Ferreira gmail  writes:
> I executed REINDEX by hand and the disk ocupation imediatelly dropped 6
> Giga...!!!

> is there a way to configure postgres to automatically execute the needed
> REINDEXING (on indexes and tables) for a given database....

Generally speaking, there shouldn't be a need for "automatic
reindexing".  What the above suggests is that you need more aggressive
routine vacuuming, so that you don't get into this situation in the
first place.

BTW, "more aggressive routine vacuuming" does NOT mean "use vacuum full".
Vacuum full tends to make index bloat worse, not better.

			regards, tom lane
В списке pgsql-general по дате отправления
Предыдущее
От: Lennin Caro
Дата:
Сообщение: Re: automatic REINDEX-ing
Следующее
От: Willy-Bas Loos
Дата:
FAQ