[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] How do I vacuum safely?  And how often should I reindex
From:       Marc Spitzer <marc () oscar ! eng ! cv ! net>
Date:       2001-12-18 18:09:40
[Download RAW message or body]

On Tue, Dec 18, 2001 at 11:29:02AM +0100, Florian Helmberger wrote:
> 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
> 

In my exp absolutely, I have a db that adds and deletes +1,000,000
rows a day.  If you dont have much change in your db then it should
not matter much, not much space wasted.  I hope this will change for
the better in 7.2, I have to start coming up to speed on 7.2.

marc

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html
[prev in list] [next in list] [prev in thread] [next in thread]