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'.
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
Kill a running query - Postgres
Often we notice long running queries in idle or idle in transaction state.