keeping the transaction open while the job is running is probably dubious. presu...

		benmmurphy on Jan 30, 2022 \| parent \| context \| favorite \| on: Devious SQL: Message Queuing Using Native PostgreS... 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.