On 12/13/2010 07:35 PM, Simon Riggs wrote:
Same lock space is good. Easy to separate if required.

Explicitly nameable lock spaces would be even better, since if multiple
applications use them you get strange and unmanageable contention.

Yeah. I have a table of lock names for different locks, and do stuff like:

   perform pg_advisory_lock(l.lockid, some_value)
   from my_advisory_locks l
   where l.lockname = 'my_lock_name';


I don't know that we need a separately nameable lockspace for transaction-scoped locks, though, do we?

cheers

andrew




--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to