Re: Allowing VACUUM to time out when waiting for locks? - Mailing list pgsql-hackers

From Bruno Wolff III
Subject Re: Allowing VACUUM to time out when waiting for locks?
Date
Msg-id 20050129145957.GA28885@wolff.to
Whole thread Raw
In response to Allowing VACUUM to time out when waiting for locks?  (Philip Warner <pjw@rhyme.com.au>)
List pgsql-hackers
On Sun, Jan 30, 2005 at 01:23:11 +1100, Philip Warner <pjw@rhyme.com.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.


pgsql-hackers by date:

Previous
From: Philip Warner
Date:
Subject: Allowing VACUUM to time out when waiting for locks?
Next
From: Robert Treat
Date:
Subject: Re: [pgsql-hackers] Patent issues and 8.1