Postgres Pro
Downloads
Home   >   mailing lists

Re: Is there a reason _not_ to vacuum continuously? - Mailing list pgsql-performance

From Oliver Scheit
Subject Re: Is there a reason _not_ to vacuum continuously?
Date
Msg-id B7397E6AC70AB1418180FA3480B9365556A612@deun2kex01.realgarant.de
Whole thread Raw
In response to Is there a reason _not_ to vacuum continuously?  ("Matt Clark" <matt@ymogen.net>)
List pgsql-performance
Tree view 
3) using PG 7.3 or less, you will also need to REINDEX these
   tables+indexes often (daily?).   This issue will go away
   in 7.4, which should make you an early adopter of 7.4.

Is this true? Haven't heard of this before.
If so, how can this be managed in a cronjob?
For the hourly VACUUM there's vacuumdb, but is
there somehting similar like reindexdb ?

regards,
Oliver Scheit

pgsql-performance by date:

Previous
From: "Alexander Priem"
Date:
Subject: Many fields in one table or many tables?
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: Is there a reason _not_ to vacuum continuously?