19h ago · 11 min read · Backend systems revolve around data. User accounts, payments, orders, logs, analytics, permissions — almost everything a backend service does eventually becomes data stored somewhere. Because of that,
Join discussion2d ago · 4 min read · PostGIS Spatial Indexing: Why Your Queries Are Doing Sequential Scans Last year I helped a delivery platform debug why their "restaurants near me" feature was timing out during lunch rush. The restaurants table had 4.2 million rows. Every proximity q...
Join discussion
Mar 7 · 4 min read · Scaling pgvector: Memory, Quantization, and Index Build Strategies pgvector is the easiest way to add vector search to PostgreSQL. At small scale -- a few hundred thousand embeddings -- it just works. HNSW indexes deliver sub-millisecond similarity s...
Join discussion
Mar 5 · 4 min read · Your pgvector Queries Are Doing Sequential Scans -- Here's Why pgvector is the fastest way to add vector similarity search to an existing PostgreSQL database. It's also the fastest way to create a performance problem that hides in plain sight: uninde...
Join discussion
Mar 3 · 4 min read · pgvector Index Selection: IVFFlat vs HNSW for PostgreSQL Vector Search A team I worked with spent three weeks convinced their OpenAI embeddings were low quality. Their RAG pipeline returned vaguely related documents instead of the precise matches the...
Join discussion
Feb 27 · 5 min read · How to Find and Fix Missing Indexes in PostgreSQL A sequential scan on a 100-row table takes microseconds. A sequential scan on a 10-million-row table takes hundreds of milliseconds. The SQL is identical. The schema is identical. The only difference ...
Join discussionFeb 13 · 9 min read · Content Role: pillar Database Query Optimization Guide for High-Traffic Applications When your application scales from thousands to millions of requests per day, database query optimization transforms from a nice-to-have into a critical survival ski...
Join discussionFeb 12 · 12 min read · Database Indexing: Performance Optimization Guide Database indexing performance optimization remains the most impactful lever for improving application responsiveness, yet most engineering teams discover indexing problems only after queries start tim...
Join discussion