pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
REINDEX Issue - DB Management
2+ messages / 2 participants
[nested] [flat]

* REINDEX Issue - DB Management
@ 2005-12-08 16:33 Rodrigo Hjort <rodrigo.hjort@gmail.com>
  2005-12-09 04:18 ` Re: REINDEX Issue - DB Management Qingqing Zhou <zhouqq@cs.toronto.edu>
  0 siblings, 1 reply; 2+ messages in thread

From: Rodrigo Hjort @ 2005-12-08 16:33 UTC (permalink / raw)
  To: 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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: REINDEX Issue - DB Management
  2005-12-08 16:33 REINDEX Issue - DB Management Rodrigo Hjort <rodrigo.hjort@gmail.com>
@ 2005-12-09 04:18 ` Qingqing Zhou <zhouqq@cs.toronto.edu>
  0 siblings, 0 replies; 2+ messages in thread

From: Qingqing Zhou @ 2005-12-09 04:18 UTC (permalink / raw)
  To: pgsql-admin


"Rodrigo Hjort" <rodrigo.hjort@gmail.com> wrote
>- How often do you REINDEX your databases?
> - What do you verify on the database to know that it is time to reindex?
>

There is no unique answer to the first one. You can binary search your 
optimal reindex rate. Suppose the workload is steady, then you first set 
reindex rate at, say, one time per week, then try twice per week, if it gets 
better, then try more frequent reindex. If not, then you can try 1 time per 
two-weeks and so on.

Regards,
Qingqing 





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-12-09 04:18 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-12-08 16:33 REINDEX Issue - DB Management Rodrigo Hjort <rodrigo.hjort@gmail.com>
2005-12-09 04:18 ` Qingqing Zhou <zhouqq@cs.toronto.edu>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox