study notes

Postgres partitions A better resources is https://www.postgresql.org/docs/10/ddl-partitioning.html Postgres let's us split a large table in to smaller entities, done for managebility, performance. Typical usecase includes: Improve query performance of frequently accessed data from fewer partitions. Bulk delete or upload. Eg: Delete all records more than 3 months old. Seperate stale data from actively used data. Partitioning Declarative Declarative partitioning lets us specify the desired outcome without much details on how the partition happens behind the scenes.