POSTGRESQL: Queueworker not running?
While trying to revive my hub, I see workerq table getting locked while executing those queries:
update workerq set workerq_reservationid = null where workerq_processtimeout < now() at time zone 'UTC';
and
select distinct workerq_reservationid from workerq;
Not sure what should I look for ot fix it, but I would love to get some directions.
My workerq is 7354 big.
Edited by Mario