10h ago · 5 min read · PostgreSQL Table Partitioning: Range, List & Hash Strategies Last month I helped a team whose 400-million-row events table was causing cascading problems. VACUUM took 6 hours. Index builds required maintenance windows. Deleting 3 months of old data g...
Join discussion
12h ago · 8 min read · Row-level security (RLS) is a database feature that enforces access control at the level of individual rows. Instead of granting or denying access to a whole table, RLS lets you define policies that d
Join discussion
1d ago · 4 min read · PostgreSQL Connection Pooling: PgBouncer, Supavisor & Built-In The most common PostgreSQL production incident I see follows this pattern: application scales up, connections multiply, someone increases max_connections to 1000, and performance gets wor...
Join discussion
2d ago · 5 min read · PostgreSQL GIN Indexes: JSONB, Arrays & Full-Text Search Here's a pattern I see constantly: a team stores flexible data in a JSONB column, writes queries that filter on specific keys, and everything is fast in development. Six months later, with mill...
Join discussion
3d ago · 9 min read · This post was originally published on basecut.dev. The standard GitHub Actions job for PostgreSQL tests looks something like this: - name: Set up test database run: psql "$TEST_DB_URL" -f scripts/s
Join discussion
3d ago · 5 min read · PostgreSQL Foreign Data Wrappers: Cross-Database Queries Explained Every few months I see a team build an elaborate ETL pipeline to sync data between two PostgreSQL instances -- scheduled jobs, temporary staging tables, conflict resolution logic, mon...
Join discussion
4d ago · 8 min read · Here we go again. This is my second post in a series documenting my transition into Backend + ML Systems Engineering. The first post covered building a fraud detection model from scratch. This one co
Join discussion
4d ago · 4 min read · PostgreSQL Logical Replication: Setup, Monitoring & Troubleshooting I've seen logical replication take down more primaries than it's protected replicas. Not because the feature is broken -- it works exactly as documented. The problem is that teams se...
Join discussion
5d ago · 12 min read · Introduction You spent three weeks building a RAG pipeline. The embeddings are clean. The retrieval scores look good. The demo works perfectly. Then it goes to production, and a week later the support team starts forwarding user complaints: the assis...
Join discussion
