Hacker News new | ask | show | jobs
by rbranson 638 days ago
Yeah, this almost never happens in practice. It’s not even worth being concerned about.
1 comments
nikisweeting 638 days ago
Happened all the time to me before I did some tuning Depends how much write contention you have and how long open transactions take to finish.
link
rbranson 638 days ago
The list of circumstances for WAL-mode busy errors is in the doc linked by one of the posters above. It has nothing to do with transactions.
link
ncruces 636 days ago
That list lists reasons queries might return busy; queries aka. reads.

Reads returning busy is rare under WAL, but WAL mode does very little for writer-writer contention.

link