How to deal with long-running transactions (OLTP)
Identify and handle long-running transactions that can impact OLTP system performance
3 docs tagged with "transactions"
View all tagsHow to troubleshoot and speed up Postgres stop and restart attempts
#PostgresMarathon day 2. Let's discuss PostgreSQL shutdown and restarts. It's not uncommon to see quite long and even failed shutdown/restart attempts.
How to use subtransactions in Postgres
Understand subtransactions, savepoints, and their impact on database performance