Re: automatic REINDEX-ing

Поиск
Список
Период
Сортировка
От Joao Ferreira gmail
Тема Re: automatic REINDEX-ing
Дата
Msg-id 1218557084.6460.57.camel@jmf-ubuntu
обсуждение исходный текст
Ответ на Re: automatic REINDEX-ing  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: automatic REINDEX-ing
Re: automatic REINDEX-ing
Re: automatic REINDEX-ing
Список pgsql-general
On Tue, 2008-08-12 at 11:53 -0400, Tom Lane wrote:
> TW, "more aggressive routine vacuuming" does NOT mean "use vacuum
> full".
> Vacuum full tends to make index bloat worse, not better.
>
>                         regards, tom lane
>
Ok. so what does it mean ?



I'm a bit lost here.  I'm currently executing VACUUM FULL _and_ REINDEX
(tbls & idxs) every week.

Should I keep the REINDEX and drop VACUUM FULL ?

How do I iterate to a better approach ?

thanks.

joao



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

Предыдущее
От: William Garrison
Дата:
Сообщение: ftell error during pg_dump
Следующее
От: Tom Lane
Дата:
Сообщение: Re: ftell error during pg_dump