Re: Multithreaded queue in PgSQL

Поиск
Список
Период
Сортировка
От valgog
Тема Re: Multithreaded queue in PgSQL
Дата
Msg-id 9c3e1218-9930-4e9a-be52-67ca7625e01f@m73g2000hsh.googlegroups.com
обсуждение исходный текст
Ответ на Re: Multithreaded queue in PgSQL  (Nikola Milutinovic <alokin1@yahoo.com>)
Ответы Re: Multithreaded queue in PgSQL  (Stevo Slavić <s.slavic@levi9.com>)
Список pgsql-general
Дерево обсуждения 
On Jun 10, 1:58 pm, alok...@yahoo.com (Nikola Milutinovic) wrote:
> > You may find that the PGQ component of skytools is what you want:
> >  http://pgfoundry.org/projects/skytools
> >  http://skytools.projects.postgresql.org/doc/
> >  http://skytools.projects.postgresql.org/doc/pgq-sql.html
>
> Thanks, we will look into it. Still, I am surprised to learn that SQL as such cannot handle it. I do realize that the
questionis not trivial. Would setting transaction isolation level to SERIALIZABLE help in any way? Would locking of the
entiretable help in any way? 
>
> Nix.

The easiest solution that I have found by now, is to use advisory
lock, so that every thread is waiting until the other has released the
lock.

-- Valentine

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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: what gives: SELECT INVALID SELECT STATEMENT TO FORCE ODBC DRIVER TO UNPREPARED STATE
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: Insert into master table ->" 0 rows affected" -> Hibernate problems