- How often do you REINDEX your databases?
- What do you verify on the database to know that it is time to reindex?
I currently have a PostgreSQL 7.4.7 server with a 500 MB database
(about 200 tables). I made a Shell script that calls
/contrib/reindexdb. Then I put it on crontab, the way it is executed
once a week and mails me the results after the operation. Do you think
it is reasonable?
--
Regards,
Rodrigo Hjort
GTI - Projeto PostgreSQL
CELEPAR - Cia de Informática do Paraná
http://www.pr.gov.br