Re: [GENERAL] Queuing query

2015-09-22 Thread Steve Crawford
Thanks, Jeff. Like I said, this is the way-stripped-down version of the core query with things like "the_priority" and "the_work" standing for more complicated expressions. Lots of other stuff is going on to make sure we get a response, clear the queue, etc. and we will index appropriately. I'm re

Re: [GENERAL] Queuing query

2015-09-22 Thread Jeff Janes
On Mon, Sep 21, 2015 at 3:51 PM, Steve Crawford < scrawf...@pinpointresearch.com> wrote: > While awaiting the awesomeness of the upcoming "skip locked" feature in > 9.5 I need to handle a work queue. > > Does anyone see any glaring issues or subtle nuances with the basic method > below which combi

[GENERAL] Queuing query

2015-09-21 Thread Steve Crawford
While awaiting the awesomeness of the upcoming "skip locked" feature in 9.5 I need to handle a work queue. Does anyone see any glaring issues or subtle nuances with the basic method below which combines CTEs with queue-handling methods posted by depesz, on the PG wiki and elsewhere. Note that it