Re: automatic REINDEX-ing

Поиск
Список
Период
Сортировка
От Joao Ferreira gmail
Тема Re: automatic REINDEX-ing
Дата
Msg-id 1218646718.13644.98.camel@jmf-ubuntu
обсуждение исходный текст
Ответ на Re: automatic REINDEX-ing  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-general
> Because VACUUM FULL needs to move stuff around in the table which means it
> need to mess around with the indexes (adding new entries). Ordinary
> VACUUM only needs to delete stuff so doesn't cause anywhere near as
> many problems.

so.... in  the event that I really end up running VACUUM FULL once in a
while, it seems to me it is a good idea to run REINDEX.

Is this correct ?

thx
joao


>
> Have a nice day,



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

Предыдущее
От: Jeff Ross
Дата:
Сообщение: Column alias in where clause?
Следующее
От: Steve Crawford
Дата:
Сообщение: Re: Postgres eats all memory