Postgres Pro
Downloads
Home   >   mailing lists

How do I vacuum safely? And how often should I reindex - Mailing list pgsql-admin

From Florian Helmberger
Subject How do I vacuum safely? And how often should I reindex
Date
Msg-id OPEOLKEAAIMGBAMJNACKAEEDDFAA.f.helmberger@uptime.at
Whole thread Raw
Responses Re: How do I vacuum safely? And how often should I reindex  (Marc Spitzer <marc@oscar.eng.cv.net>)
List pgsql-admin
Tree view 
Hi!

> > 2: how often should I reindex my db, are there any standards
> >    or accepted practices out there
>
> I recreate my indices every week, or after any extensive updates or
> deletes.  Again, I believe that 7.2 has some new stuff to deal with this
> issue.

This brings me to another point. Is it really necessary to recreate indices
if you vacuum analyze your database regulary (say, every once in a week)?

Cheers,
Florian

pgsql-admin by date:

Previous
From: "Andrew G. Hammond"
Date:
Subject: Re: Resetting connection errors and incomplete restores.
Next
From: Marc Spitzer
Date:
Subject: Re: How do I vacuum safely? And how often should I reindex