On Thu, 17 Jul 2008, Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
> Volkan YAZICI wrote:
>> 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.
Is this documented in somewhere? I couldn't figure out that from the
In response to
pgsql-sql by date
|Next:||From: Tom Lane||Date: 2008-07-18 05:40:37|
|Subject: Re: pg_advisory_lock(bigint) vs. LOCK TABLE |
|Previous:||From: Alvaro Herrera||Date: 2008-07-17 16:16:54|
|Subject: Re: pg_advisory_lock(bigint) vs. LOCK TABLE|