Volkan YAZICI wrote:
> Hi,
> 
> What's the difference between below two queue implementations?

They are two different lock spaces.  pg_advisory_lock does not conflict
with regular system locks, whereas LOCK TABLE does.


-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

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

Reply via email to