Re: [PERFORM] Message queue table - strange performance drop with changing limit size.

Greg Williamson wrote: > Jesper -- > > I apologize for top-quoting -- a challenged reader. > > This doesn't directly address your question, but I can't help but > notice that the estimates for rows is _wildly_ off the actual number > in each and every query. How often / recently have you run ANAL

Re: [PERFORM] Message queue table - strange performance drop with changing limit size.

Jesper -- I apologize for top-quoting -- a challenged reader. This doesn't directly address your question, but I can't help but notice that the estimates for rows is _wildly_ off the actual number in each and every query. How often / recently have you run ANALYZE on this table ? Are the timin

[PERFORM] Message queue table - strange performance drop with changing limit size.

Hi. I have a "message queue" table, that contains in the order of 1-10m "messages". It is implemented using TheSchwartz: http://search.cpan.org/~bradfitz/TheSchwartz-1.07/lib/TheSchwartz.pm So when a "worker" picks the next job it goes into the "job" table an select the top X highest priority mes