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...
- Oct 9, 2022
Transactional Unit Tests with Pytest and Async SQLAlchemy
Summary This is a quick how to post if you’re working on migrating your database backed applications to async-sqlalchemy and are looking...
- Jan 1, 2022
Generating series with Postgres
Social websites usually have a feature that displays the users engagement with a site or a log of a particular activity over time. Here's...
- 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