Concurrent VACUUM and ANALYZE

From: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
To: "Postgres Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Concurrent VACUUM and ANALYZE
Date: 2008-07-21 21:50:46
Message-ID: 36e682920807211450t26aefefap64107e30dc123f2b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Currently, one cannot perform a concurrent VACUUM and ANALYZE. This
is a significant problem for tables which are not only large and have
designated cost-delays, but which are also heavily inserted into and
deleted from. After performing a quick cursory investigation on this,
it doesn't appear to be difficult to change. Other than the
ShareUpdateExclusiveLock, is there anything technically preventing us
from performing both concurrently?

Because we wouldn't want multiple ANALYZEs running on the same table,
changing the lock back to an AccessShareLock doesn't sound like a
solution. However, what are the thoughts around creating another,
more-specific lock? Perhaps something like ShareUpdateAnalysisLock?
Any other suggestions?

-Jonah

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Sullivan 2008-07-21 22:13:59 Re: Load spikes on 8.1.11
Previous Message Andrew Dunstan 2008-07-21 21:27:11 Re: typedefs for indent