Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group