Case Study - Alphacoach Evolve
Alphacoach Evolve is a health and fitness platform, that generates huge volumes of time-series data. The data is then run through computational layers before insights are generated and offered to the users as actionable outcomes.
PostgreSQL - Cancelling statement due to conflict with recovery
Running queries on a standby replica node may cause queries to error out with a message 'Cancelling statement due to conflict with recovery'.
SQLAlchemy and Idle in transaction queries
Orphaned transactions are a problem that could lead to messy states in the database. This is usually a good indicator that the something is not right in the manner in which connections are established and closed on the services that query the database.
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.
SQL - Postgres Long running queries
Quick snippet to discover queries that have been running for over 1 minute on Postgres