Re: [HACKERS] Fixing Simms' vacuum problems - Mailing list pgsql-hackers

From Vadim Mikheev
Subject Re: [HACKERS] Fixing Simms' vacuum problems
Date
Msg-id 37DD40F0.8164BA32@krs.ru
Whole thread Raw
In response to Fixing Simms' vacuum problems  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> 
> So, it looks like a solution involves two components: first, being more
> careful to lock system relations appropriately, and second, being sure
> that SI messages are seen soon enough.  I think the read-SI-messages-
> at-lock-time code that's already in place for 6.6 will be sufficient for
> the second point, if we are religious about acquiring appropriate locks.
> (BTW, I think that in most cases an appropriate lock on a system table
> will be less strong than AccessExclusiveLock --- Vadim, do you agree?)

ExclusiveLock should be ok.

Vadim


pgsql-hackers by date:

Previous
From: Leon
Date:
Subject: Re: [HACKERS] Status report: long-query-string changes
Next
From: Vadim Mikheev
Date:
Subject: Re: [HACKERS] Vacuum analyze bug CAUGHT