Postgres Pro
Downloads
Home   >   mailing lists

Re: Reducing relation locking overhead - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Reducing relation locking overhead
Date
Msg-id 12414.1133752058@sss.pgh.pa.us
Whole thread Raw
In response to Re: Reducing relation locking overhead  (Kevin Brown <kevin@sysexperts.com>)
Responses Re: Reducing relation locking overhead
List pgsql-hackers
Tree view 
Kevin Brown <kevin@sysexperts.com> writes:
> - when requesting a type of lock, one must first acquire all lesser
>   lock types against the object in order of strength.  Hence, one must
>   acquire AccessShareLock before acquiring AccessExclusiveLock.

This is exactly wrong ...
        regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: MIN() performance regression 8.0 -> 8.1
Next
From: Tom Lane
Date:
Subject: Re: generalizing the planner knobs