REINDEX Issue - DB Management

From: Rodrigo Hjort <rodrigo(dot)hjort(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: REINDEX Issue - DB Management
Date: 2005-12-08 16:33:14
Message-ID: 731083980512080833q47791a2fr@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

- 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Guido Barosio 2005-12-08 16:44:01 Re: the time for pgsql-starting@postgresql.org has come?
Previous Message Tom Lane 2005-12-08 16:13:36 Re: the time for pgsql-starting@postgresql.org has come?