Skip site navigation (1) Skip section navigation (2)

Re: Allowing VACUUM to time out when waiting for

From: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Allowing VACUUM to time out when waiting for
Date: 2005-01-30 06:51:51
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
At 02:53 AM 30/01/2005, Tom Lane wrote:
>Philip Warner <pjw(at)rhyme(dot)com(dot)au> writes:
> > We have a frequently updated (peak > 5/sec) table with about 1000 rows.
> > We run VACCUM FULL on this table every 5 minutes.
>Plain vacuum (perhaps executed even more often, like
>once a minute) will cause fewer locking headaches.

We have done both in the past, but found some tables still just grew 
(perhaps just because of infrequent locks that prevented the plain VACUUM). 
I'll go back to the plain VACUUM and monitor the table growth.

Am I correct in saying that the FSM now tracks the entire table, and that 
the FSM parameters just determine how much is stored in memory?

>I think you could do that by setting a statement timeout.

This would be a good solution if we still see growth with plain VACUUM.

Is any type of opportunistic locking likely/planned for a future version 
(ie. a has lock, b asks for conflicting lock, c asks for lock that is OK 
with a but denied by b; so c's lock is allowed and b stays waiting).

Philip Warner                    |     __---_____
Albatross Consulting Pty. Ltd.   |----/       -  \
(A.B.N. 75 008 659 498)          |          /(@)   ______---_
Tel: (+61) 0500 83 82 81         |                 _________  \
Fax: (+61) 03 5330 3172          |                 ___________ |
Http://          |                /           \|
                                  |    --________--
PGP key available upon request,  |  /
and from       |/ 

In response to


pgsql-hackers by date

Next:From: Oleg BartunovDate: 2005-01-30 06:58:19
Subject: Re: Huge memory consumption during vacuum (v.8.0)
Previous:From: Tom LaneDate: 2005-01-30 06:51:08
Subject: Re: Huge memory consumption during vacuum (v.8.0)

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group