15 min read/0 views
Our 15-minute batch ETL caused a billing incident. Debezium reading the Postgres WAL replaced the entire pipeline. CDC setup, consumer patterns, and production gotchas.
13 min read/1 views
A single missing PostgreSQL index cost $40K/month. Partial indexes, covering indexes, BRIN — the indexing tricks most devs never learn.
14 min read/1 views
How I killed a 2,400-line Python ETL pipeline and replaced it with 300 lines of SQL using CTEs, materialized views, and pg_cron.
16 min read/10 views
Most teams don't need Pinecone. pgvector benchmarks, decision framework, and when dedicated vector DBs actually make sense.