·8 min read
pgvector in Production: High-Scale Vector Search & Hybrid RRF in PostgreSQL
Production guide to pgvector in PostgreSQL: HNSW vs IVFFlat indexing, parameter tuning, hybrid full-text search with RRF, and metadata filtering.
Technical Writings
Stories, tutorials, and deep dives spanning across diverse worlds.
Top Topics
17Showing 1–10 of 11 articles
·19 min read
PostgreSQL Connection Pooling: PgCat vs PgBouncer vs Supavisor under High Concurrency
Deep-dive architectural guide covering postgresql connection pooling: pgcat vs pgbouncer vs supavisor under high concurrency with battle-tested production examples.
·25 min read
Distributed Locking in Distributed Systems: Redlock, PostgreSQL Advisory Locks & etcd Leases
Comprehensive guide covering Distributed Locking in Distributed Systems: Redlock, PostgreSQL Advisory Locks & etcd Leases with production-grade architecture and code examples.
·16 min read
PgBouncer Architecture & Tuning: Transaction Pooling, Prepared Statements & Session Overhead
Comprehensive guide covering PgBouncer Architecture & Tuning: Transaction Pooling, Prepared Statements & Session Overhead with production-grade architecture and code examples.
·15 min read
PostgreSQL Change Data Capture (CDC): Debezium, Kafka Connect & Transactional Outbox
Comprehensive guide covering PostgreSQL Change Data Capture (CDC): Debezium, Kafka Connect & Transactional Outbox with production-grade architecture and code examples.
·17 min read
PostgreSQL 17 Query Optimization: Execution Plans, Memory Tuning & EXPLAIN ANALYZE
Comprehensive guide covering PostgreSQL 17 Query Optimization: Execution Plans, Memory Tuning & EXPLAIN ANALYZE with production-grade architecture and code examples.
·17 min read
pgvector vs Qdrant at Scale: Memory Overhead, HNSW Recall & Tail Latencies (2026)
Comprehensive guide covering pgvector vs Qdrant at Scale: Memory Overhead, HNSW Recall & Tail Latencies (2026) with production-grade architecture and code examples.
·19 min read
PostgreSQL Vacuum & Index Bloat: Detection, Mitigation, and Automated Tuning
Diagnose and eliminate PostgreSQL table and index bloat. Master autovacuum tuning formulas, pg_repack zero-downtime compaction, and MVCC visibility maps.
·20 min read
Vector Search at Scale: HNSW vs IVFFlat Indexing in pgvector and SQLite-vec
Compare HNSW and IVFFlat vector indexing algorithms in pgvector and sqlite-vec. Analyze recall accuracy, build times, memory footprints, and query latency.
·10 min read
Modern Database Sharding Strategies for Hyper-Growth
Master modern database sharding architectures: horizontal partitioning, range vs consistent hash keys, cross-shard joins, distributed transactions (2PC vs Saga), Vitess, and Citus.
Showing 1-10 of 11 posts