In one of the snippets, there is a 10 second sleep inside a transaction to add d... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		698969 on June 16, 2024 \| parent \| context \| favorite \| on: How/Why to Sweep Async Tasks Under a Postgres Tabl... In one of the snippets, there is a 10 second sleep inside a transaction to add delays between polling if there are no tasks, Shouldn't that be outside the transaction?

surprisetalk on June 16, 2024 [–]

Yes, it would definitely be more performant to move it outside of the transaction :) good catch

Consider applying for YC's Winter 2026 batch! Applications are open till Nov 10
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact