Preventing duplicate vacuums? - Mailing list pgsql-hackers

From Josh Berkus
Subject Preventing duplicate vacuums?
Date
Msg-id 200402051237.14615.josh@agliodbs.com
Whole thread Raw
Responses Re: Preventing duplicate vacuums?  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Preventing duplicate vacuums?  (Rod Taylor <pg@rbt.ca>)
List pgsql-hackers
Folks,

Just occurred to me that we have no code to prevent a user from running two 
simultaneos lazy vacuums on the same table.    I can't think of any 
circumstance why running two vacuums would be desirable behavior; how 
difficult would it be to make this an exception?

This becomes a more crucial issue now since the introduction of vacuum_delay 
makes overlapping vacuums more probable.

-- 
-Josh BerkusAglio Database SolutionsSan Francisco



pgsql-hackers by date:

Previous
From: evgen
Date:
Subject: Re: Recursive queries?
Next
From: Jan Wieck
Date:
Subject: Re: Vacuum Delay feature