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

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 (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.

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

pgsql-performance by date

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

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