Re: SKIP LOCKED DATA

Поиск
Список
Период
Сортировка
От Dimitri Fontaine
Тема Re: SKIP LOCKED DATA
Дата
Msg-id m2sjjfv0o9.fsf@2ndQuadrant.fr
обсуждение исходный текст
Ответ на SKIP LOCKED DATA  (Thomas Munro <munro@ip9.org>)
Список pgsql-hackers
Thomas Munro <munro@ip9.org> writes:
> A common usage for this is to increase parallelism in systems with
> multiple workers taking jobs from a queue.  I've used it for this
> purpose myself on another RDBMS, having seen it recommended for some
> types of work queue implementation.  It may have other uses.

To attack this problem in PostgreSQL we also have PGQ, which is
Skytools3 has support for cooperative consumers.

Regards,
-- 
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support


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

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: pg_stat_database deadlock counter
Следующее
От: Magnus Hagander
Дата:
Сообщение: Warning in views.c