Postgres FM cover image

Zero-downtime migrations

Postgres FM

CHAPTER

How to Use Lock Time Out to Cancel Transactions

There's a setting where we can cancel things that we can set a time out walk time out or statement time. So in this case, if you statement time out, it will be applied both to DDL and DML including selects. A finer grade, how to say fine grained, special time out fine grained setting, which will be applied only to lock acquisition, not to call statement duration. And of course, I prefer using it. But I wanted to mention you're right. This is one kind of a problems when you think it's so simple. Everyone hits it at least like silently not noticing until some level of forecode. If you have a tobacco processing, well

00:00
Transcript
Play full episode

Remember Everything You Learn from Podcasts

Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.
App store bannerPlay store banner