Blog
PostgreSQL, pgvector, and AI infrastructure: guides and deep dives.
Filter by tag
All posts
pgvector HNSW Tuning on Managed PostgreSQL
Learn how to tune pgvector HNSW indexes on managed PostgreSQL, including ef_search, m, ef_construction, memory, filters, and storage latency.
8 min read
pgvector Hosting Guide: How to Choose Managed PostgreSQL for Vector Search
A practical pgvector hosting checklist for production teams: storage, memory, HNSW indexes, backups, high availability, pricing, and migration support.
8 min read
Supabase pgvector Alternative: When to Move Vector Search to Managed PostgreSQL
Compare Supabase pgvector with focused managed PostgreSQL for vector-heavy workloads, including cost, latency, HNSW tuning, and migration paths.
7 min read
PostgreSQL Monitoring: A Practical Guide to Metrics, Tools, and Alerts
Learn how to monitor PostgreSQL in production, from built-in stats views to Prometheus and pganalyze. Covers the metrics that actually matter, query performance, and alerting.
10 min read
Postgres Row-Level Security: Policies, Pitfalls, Performance
How RLS actually behaves in multi-tenant apps: writing policies, the planner surprises that slow them down, and the mistakes that silently leak rows.
11 min read
PostgreSQL Backup and Recovery: A Complete Guide
Learn how PostgreSQL backup works, from pg_dump basics to WAL archiving and point-in-time recovery. Covers pg_basebackup, pgBackRest, backup verification, and production strategies.
11 min read
PostgreSQL JSONB: A Complete Guide to Storing and Querying JSON Data
Learn how to use PostgreSQL JSONB for storing, indexing, and querying JSON data. Covers JSONB vs JSON, operators, GIN indexes, real world patterns, and performance tips for production.
14 min read
pgvector with LangChain: Build a RAG Pipeline on PostgreSQL
Learn how to use pgvector with LangChain to build a production-ready RAG pipeline on PostgreSQL. Covers setup, embeddings, similarity search, metadata filtering, and retrieval chains.
10 min read
PostgreSQL Connection Pooling with PgBouncer: A Complete Guide
Learn how PostgreSQL connection pooling works, how to set up PgBouncer, and when transaction mode is the right choice. Covers config, monitoring, and common pitfalls.
10 min read