Hacker News Reader

Here's the companion essay with more code snippets: https://taylor.town/pg-task

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?

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