The Grounds

The estate, organized for your visit. Each series gathers the articles that belong together — from first principles to production-grade patterns — arranged in the order they read best.

Connection Pooling & Resource Management

Your application has a finite number of connections to the kitchen, and the queue forms faster than you think. Pool sizing, PgBouncer, and the exhaustion patterns I see across every major framework.

16 articles Start reading →

Query Optimization & EXPLAIN

A slow query is a conversation waiting to happen. EXPLAIN ANALYZE tells you what PostgreSQL is actually doing — and more importantly, why. From plan nodes to sequential scans, allow me to walk you through.

12 articles Start reading →

Indexes & Missing Index Detection

The right index turns a full-table scan into a microsecond lookup. The wrong one wastes disk and slows writes. B-tree, GIN, partial, composite — and how to detect the ones you are missing.

8 articles Start reading →

ORM Performance & Raw SQL

The question is not whether your ORM is slow. The question is how much performance you are leaving on the table, and whether you have measured it. I have. Extensively.

5 articles Start reading →

Django & Python

Django's ORM is capable of remarkable things when properly directed — and remarkable damage when left to its defaults. FastAPI, SQLAlchemy async, psycopg3, and the patterns that separate production Python from tutorial Python.

14 articles Start reading →

Rails & Ruby

ActiveRecord's conveniences come with hidden queries, silent pool leaks, and counter cache contention that surfaces only at scale. I have documented each pattern — and each remedy.

13 articles Start reading →

Spring Boot & Java

Hibernate has opinions about how your database should behave. PostgreSQL has different ones. HikariCP pool exhaustion, batch insert failures, QueryPlanCache OOMs, and the JPA defaults that need correcting.

15 articles Start reading →

Laravel & PHP

Eloquent makes the simple things effortless and the complex things invisible — which is the problem. whereHas(), withCount(), chunk vs cursor, Doctrine hydration modes, and the PHP patterns worth understanding.

13 articles Start reading →

Go & PostgreSQL

Go developers tend to care about performance, which makes the gap between database/sql and pgx's native interface all the more worth examining. Bulk inserts, query execution modes, and GORM's Preload problem.

7 articles Start reading →

Node.js & Edge

The JavaScript ORM landscape moves quickly. The performance patterns underneath do not. Prisma's hidden overhead, Drizzle's prepared statements, Sequelize's cartesian explosions, and what happens to your connections at the edge.

8 articles Start reading →

PostgreSQL Internals & Maintenance

PostgreSQL rewards those who understand what is happening beneath the surface. VACUUM, autovacuum, buffer cache, table bloat, lock contention, JSONB storage, and the ten configuration settings that actually matter.

16 articles Start reading →

Monitoring, Observability & Compliance

You cannot optimize what you do not measure. pg_stat_statements, pg_stat_monitor, monitoring stacks for production, and pgAudit configuration for SOC 2 and HIPAA — the operational visibility your database deserves.

6 articles Start reading →

Replication, Scaling & Cloud PostgreSQL

Before you add infrastructure, make certain you have exhausted what PostgreSQL already provides. Replication, partitioning, cloud-specific tuning for RDS, Heroku, Supabase, and Neon — and the Redis workloads PostgreSQL handles natively.

13 articles Start reading →

Materialized Views

The materialized view is PostgreSQL's native cache — no external infrastructure required. Creating, refreshing, and the pitfalls that the documentation neglected to mention. This is the foundation Gold Lapel is built on.

3 articles Start reading →

Search, Vectors & AI

PostgreSQL does search, vector similarity, and geospatial queries — often well enough to retire the external service you are paying for. tsvector, pgvector, PostGIS, and an honest assessment of when you do need something else.

8 articles Start reading →