Postgres

Extensions

1. visualise long-running requests and DB load we should use some statistics extension for Postgres

Database migration

We version control our database schema with a lightweight, framework-agnostic database migration tool called dbmate.

The database schema and migrations are open-source and can be found here. This repository acts like a single source of truth (SSOT) for the DB schema.

Partitioning

Replication

Notes

• https://sqlfordevs.com/multiple-aggregates-in-one-query