Search

Bites 111

Docker & Kubernetes·1 min read

Persist PostgreSQL data across compose down

Define a named volume and mount it at the database's data directory (/var/lib/postgresql/data); named volumes survive compose down.

Growth & Experimentation·2 min read

Compare PostgreSQL versus a columnar warehouse for raw event data

Contrast row vs column storage, compression, and scan speed; note Postgres suits OLTP and point lookups while columnar stores excel at aggregations.

Databases & Architecture·2 min read

PostgreSQL's Free Space Map: Finding Room to Write

A Free Space Map is a table of contents for empty space in a Postgres table. It lets Postgres quickly find a page with enough room for a new row or index entry, avoiding a slow scan. It's used on every INSERT/UPDATE.

Databases & Architecture·2 min read

Single-Leader Replication: One Node to Rule Them All

Think of a single source of truth. One 'leader' server takes all writes, while 'follower' servers handle read traffic. This is the default for many databases like PostgreSQL and MongoDB to scale reads.

Topics 0

No topics found. Try a different keyword.

Roles 0

No roles found. Try a different keyword.