How often do I need to reindex tables?

Поиск
Список
Период
Сортировка
От Dhaval Shah
Тема How often do I need to reindex tables?
Дата
Msg-id 565237760702271126t79ca0aa5w8d2f9276db96f803@mail.gmail.com
обсуждение исходный текст
Ответы Re: How often do I need to reindex tables?  ("Jim C. Nasby" <jim@nasby.net>)
Re: How often do I need to reindex tables?  (Ron Johnson <ron.l.johnson@cox.net>)
Список pgsql-general
I am planning to use 8.2 and the average inserts/deletes and updates
across all tables is moderate. That is, it is a moderate sized
database with moderate usage of tables.

Given that, how often do I need to reindex the tables? Do I need to do
it everyday?

Also with 8.2, I do not have to do vacuum anymore or that is what I
understand. Does it do auto-vacuum?

Thanks in advance
Dhaval Shah

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

Предыдущее
От: Andrew Edson
Дата:
Сообщение: Re: How does filter order relate to query optimization?
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: Re: pg_dump and restore problem with function as DEFAULT-Constraint