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

From Bruno Wolff III
Subject Re: perfromance impact of vacuum
Date
Msg-id 20030715165350.GA12809@wolff.to
Whole thread Raw
In response to Re: perfromance impact of vacuum  ("Jay O'Connor" <joconnor@cybermesa.com>)
Responses Re: perfromance impact of vacuum  ("Jay O'Connor" <joconnor@cybermesa.com>)
Re: perfromance impact of vacuum  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
On Tue, Jul 15, 2003 at 10:37:28 -0700,
  Jay O'Connor <joconnor@cybermesa.com> wrote:
>
> Just curious but is the length of time to vacuum influenced more by the
> size of the table or the number of dead tuples?

I think the fraction of the table that is dead tuples is probably the best
thing to look at for deciding when to vacuum (unless the tables are very
small in which case checking for the number of blocks used may be better).

pgsql-general by date:

Previous
From: Dmitry Tkach
Date:
Subject: Re: [BUGS] INSTEAD rule bug?
Next
From: Tom Lane
Date:
Subject: Re: [BUGS] INSTEAD rule bug?