Re: [GENERAL] Re: Postgresql the right tool (queue using advisory_locks + long transactions)

2014-04-27 Thread Dorian Hoxha
I'll probably ask @pgbouncer mailing list if i can use it with advisory_locks per session. If not, even raw sessions will be enough. Some comments inline. Thanks On Sun, Apr 27, 2014 at 10:07 PM, David G Johnston < david.g.johns...@gmail.com> wrote: > Dorian Hoxha wrote > > Hi list, > > > > I am

[GENERAL] Re: Postgresql the right tool (queue using advisory_locks + long transactions)

2014-04-27 Thread David G Johnston
Dorian Hoxha wrote > Hi list, > > I am trying to use postgresql as a queue for long-jobs (max ~4 hours) > using > advisory_locks. I can't separate the long-job into sub-jobs. > > >1. At ultimate-best-case scenario there will be ~100 workers, so no >web-scale performance required. >Is