pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedREINDEX 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