Postgres Pro
Downloads
Home   >   mailing lists

How often do I need to reindex tables? - Mailing list pgsql-general

From Dhaval Shah
Subject How often do I need to reindex tables?
Date
Msg-id 565237760702271126t79ca0aa5w8d2f9276db96f803@mail.gmail.com
Whole thread Raw
Responses Re: How often do I need to reindex tables?  ("Jim C. Nasby" <jim@nasby.net>)
Re: How often do I need to reindex tables?  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
Tree view 
I am planning to use 8.2 and the average inserts/deletes and updates
across all tables is moderate. That is, it is a moderate sized
database with moderate usage of tables.

Given that, how often do I need to reindex the tables? Do I need to do
it everyday?

Also with 8.2, I do not have to do vacuum anymore or that is what I
understand. Does it do auto-vacuum?

Thanks in advance
Dhaval Shah

pgsql-general by date:

Previous
From: Andrew Edson
Date:
Subject: Re: How does filter order relate to query optimization?
Next
From: Andreas Kretschmer
Date:
Subject: Re: pg_dump and restore problem with function as DEFAULT-Constraint