Re: First steps with 8.3 and autovacuum launcher - Mailing list pgsql-hackers

From Michael Paesold
Subject Re: First steps with 8.3 and autovacuum launcher
Date
Msg-id 47020D3A.7060909@gmx.at
Whole thread Raw
In response to Re: First steps with 8.3 and autovacuum launcher  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> Alvaro Herrera <alvherre@commandprompt.com> writes:
>> How about getting ShareUpdateExclusiveLock on manual analyze and plain
>> AccessShareLock on autovacuum-induced analyze?
> 
> Wouldn't fix the original problem because those two lock types don't
> conflict; hence might as well keep the behavior simple.

What about a new separate lock type for analyze? Couldn't that really 
solve the issue? I know I'm just hand-waving here ;-)

Best Regards
Michael Paesold



pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: [COMMITTERS] pgsql: Use BIO functions to avoid passing FILE * pointers to OpenSSL
Next
From: Michael Paesold
Date:
Subject: Re: First steps with 8.3 and autovacuum launcher