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.

Data Science & Analytics·1 min read

SQL or NoSQL for high-volume semi-structured event ingestion?

Choose an event store by access patterns, write volume, consistency and operational cost. Document stores fit flexible payloads; PostgreSQL JSONB is also a valid option.

Topics 0

No topics found. Try a different keyword.

Roles 0

No roles found. Try a different keyword.