Re: Is there a reason _not_ to vacuum continuously?

From: "Oliver Scheit" <oliver(dot)scheit(at)REALGARANT(dot)DE>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Is there a reason _not_ to vacuum continuously?
Date: 2003-09-18 08:18:27
Message-ID: B7397E6AC70AB1418180FA3480B9365556A612@deun2kex01.realgarant.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Christopher Kings-Lynne 2003-09-18 08:24:32 Re: Is there a reason _not_ to vacuum continuously?
Previous Message Alexander Priem 2003-09-18 08:13:11 Many fields in one table or many tables?