search

apinstein / jqjobs

A job queue engine for PHP.
33 stars 5 forks source link

JQStore_Propel is slow when # queued jobs is high #28

Open apinstein opened 9 years ago

apinstein commented 9 years ago

I believe it's due to the query for "next" that has the coalesce; not sure if something can be done about that (index on function?).

Postgres seems unhappy with such an index... needs research.

> * create index qidx_multi on jqstore_managed_job (priority desc, coalesce(now(), START_DTS) asc, job_id asc);
ERROR:  functions in index expression must be marked IMMUTABLE