Blog

#postgres

Posts com a tag "postgres" no blog do AtendePraMim.

Multi-tenant database design

Most SaaS products pick their multi-tenancy model once and live with it forever. The migration cost later is so high that teams build entire companies around the constraints of a decision they made in their first sprint. Every row carries orgid. One database, one schema, one set of connections. Cheap to operate and dead simple until you need a row-level…

ALAlexandre Awadallak

postengineering

5 de fev.

Zero-downtime Postgres migrations

Every serious schema change wants to be three deploys. New teams routinely ship them as one, take down production, and learn the rules the hard way. ALTER TABLE users ADD COLUMN tier TEXT NOT NULL rewrites every row. Worse, pre-11 versions hold an ACCESS EXCLUSIVE lock for the duration — reads and writes both block. The safe version: Deploy 1: add column as…

Multi-tenant database design

Zero-downtime Postgres migrations

Fique por dentro