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

From Christopher Kings-Lynne
Subject Re: Is there a reason _not_ to vacuum continuously?
Date
Msg-id 003f01c37dbe$4b6f9d10$2800a8c0@mars
Whole thread Raw
In response to Re: Is there a reason _not_ to vacuum continuously?  ("Oliver Scheit" <oliver.scheit@REALGARANT.DE>)
List 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.

Try monthly maybe.

> 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 ?

Yes, there is reindexdb :)

Chris


pgsql-performance by date:

Previous
From: "Oliver Scheit"
Date:
Subject: Re: Is there a reason _not_ to vacuum continuously?
Next
From: "Oliver Scheit"
Date:
Subject: Re: Is there a reason _not_ to vacuum continuously?