PostgreSQL - Cancelling statement due to conflict with recovery.
When running a CQRS based system or long running analytics workloads a replica is the fastest route. However, the default PostgreSQL...
top of page
Blog
- Oct 24, 2022
SQLAlchemy and Idle in transaction queries
Summary Orphaned transactions are a problem that could lead to messy states in the database. This is usually a good indicator that the...
- Dec 19, 2021
Kill a running query - Postgres
Often we notice long running queries in idle or idle in transaction state. This may or may not interfere with other operations that you...
- Dec 19, 2021
SQL - Postgres Long running queries
Quick snippet to discover queries that have been running for over 1 minute on Postgres This gives us a break down of the query and the...
bottom of page