Re: perfromance impact of vacuum

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Jay O'Connor <joconnor(at)cybermesa(dot)com>
Cc: "Matthew T (dot) O'Connor" <matthew(at)zeut(dot)net>, PostgreSQL List <pgsql-general(at)postgresql(dot)org>
Subject: Re: perfromance impact of vacuum
Date: 2003-07-15 16:53:50
Message-ID: 20030715165350.GA12809@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jul 15, 2003 at 10:37:28 -0700,
Jay O'Connor <joconnor(at)cybermesa(dot)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).

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Crawford 2003-07-15 16:58:08 Re: Are you frustrated with PostgreSQL
Previous Message Tom Lane 2003-07-15 16:53:34 Re: [GENERAL] INSTEAD rule bug?