keeping the transaction open while the job is running is probably dubious. presumably you are using a queue because the job takes a long time to run. having lon

keeping the transaction open while the job is running is probably dubious. presumably you are using a queue because the job takes a long time to run. having long running transactions steals a scarce PG resource (connections) and also causes issues with vacuuming.