Deadlocks and downtime

Every second* of every day, your Postgres database could be hunting with intent to kill. *or whatever your deadlock_timeout setting is. Deadlocks happen when multiple transactions each hold a lock that the other needs, blocking both from proceeding.