pg_advisory_lock(bigint) vs. LOCK TABLE

Поиск
Список
Период
Сортировка
От Volkan YAZICI
Тема pg_advisory_lock(bigint) vs. LOCK TABLE
Дата
Msg-id 87sku9wph7.fsf@alamut.mobiliz.com.tr
обсуждение исходный текст
Ответы Re: pg_advisory_lock(bigint) vs. LOCK TABLE  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-sql
Hi,

What's the difference between below two queue implementations?
 -- -- With advisory locks. -- BEGIN; SELECT pg_advisory_lock((SELECT oid                            FROM pg_class
                    WHERE relname = 'queue')); DELETE FROM queue       WHERE id = (SELECT MIN(id) FROM queue)
RETURNINGid, val; SELECT pg_advisory_unlock((SELECT oid                              FROM pg_class
      WHERE relname = 'queue')); COMMIT;  -- -- With LOCK table command. -- BEGIN; LOCK TABLE queue; DELETE FROM queue
    WHERE id = (SELECT MIN(id) FROM queue)   RETURNING id, val; COMMIT;
 

Any helps will be appreciated. (BTW, yep, I'm aware of PGQ module of
skyytools[1].)


Regards.

[1] http://skytools.projects.postgresql.org/


В списке pgsql-sql по дате отправления:

Предыдущее
От: Steve Midgley
Дата:
Сообщение: Re: Problem with ORDER BY and DISTINCT ON
Следующее
От: Milan Oparnica
Дата:
Сообщение: Re: PERSISTANT PREPARE (another point of view)