Long form
Articles
Essays and deep dives. Updated when something is worth saying.
Indexing Postgres without regret
A pragmatic walk through B-tree, GIN, BRIN and partial indexes — and when each one earns its keep.
postgresqlperformanceA mental model for Row-Level Security
RLS is just a WHERE clause the database glues onto every query. Once you see it that way, policies stop being scary.
postgresqlsecuritypsql Quick Reference
A printable cheat sheet of the most useful psql meta-commands, connection flags, and formatting options — keep it next to your terminal.
PDFpostgresqlpsqlreferenceHow Oracle DBAs can get started with Postgres
A practical on-ramp for Oracle DBAs moving into PostgreSQL — terminology mapping, architectural differences, and the first tasks to practice.
PDFpostgresqloraclemigrationUnderstanding Postgres for Oracle DBA's
A SEMOP presentation comparing Oracle and PostgreSQL for experienced Oracle database administrators — terminology, capabilities, architecture, and where to start.
PDFpostgresqloraclepresentation