Re: Is there a reason _not_ to vacuum continuously?

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Oliver Scheit" <oliver(dot)scheit(at)REALGARANT(dot)DE>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Is there a reason _not_ to vacuum continuously?
Date: 2003-09-18 08:24:32
Message-ID: 003f01c37dbe$4b6f9d10$2800a8c0@mars
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.

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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Oliver Scheit 2003-09-18 08:29:42 Re: Is there a reason _not_ to vacuum continuously?
Previous Message Oliver Scheit 2003-09-18 08:18:27 Re: Is there a reason _not_ to vacuum continuously?