Re: perfromance impact of vacuum - Mailing list pgsql-general

From Dan Langille
Subject Re: perfromance impact of vacuum
Date
Msg-id 3F12DAF0.18836.2A89A60E@localhost
Whole thread Raw
In response to perfromance impact of vacuum  ("Jay O'Connor" <joconnor@cybermesa.com>)
List pgsql-general
On 14 Jul 2003 at 14:13, Jay O'Connor wrote:

> What impact in performance does vacuum have on an active database?  I'm
> being asked about this...or rather...someone is questioning the use of
> postgresql because of this

I run it daily at off-peak times and it doesn't seem to affect
performance at all.  If you vacuum regularly, the impact is
minimized.  It really depends upon how many updates/deletes your
database has done since the last time you ran vacumm.

But don't take my word for it. See what others have to say.
--
Dan Langille : http://www.langille.org/


pgsql-general by date:

Previous
From: "Jay O'Connor"
Date:
Subject: perfromance impact of vacuum
Next
From: "scott.marlowe"
Date:
Subject: Re: perfromance impact of vacuum