Re: Allowing VACUUM to time out when waiting for locks?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Allowing VACUUM to time out when waiting for locks?
Date: 2005-01-29 14:59:57
Message-ID: 20050129145957.GA28885@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, Jan 30, 2005 at 01:23:11 +1100,
Philip Warner <pjw(at)rhyme(dot)com(dot)au> wrote:
>
> We have a frequently updated (peak > 5/sec) table with about 1000 rows.
>
> We run VACCUM FULL on this table every 5 minutes.

Why not just use plain VACUUM? The table will reach a steady state size.
You should only need to use VACUUM FULL if an event causes the table
to bloat to significantly more than steady state size and you want to reduce
the size again.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-01-29 15:53:53 Re: Allowing VACUUM to time out when waiting for locks?
Previous Message Robert Treat 2005-01-29 14:54:50 Re: [pgsql-hackers] Patent issues and 8.1