Blog
Tutorials, guides, and insights on PostgreSQL, pgvector, and AI infrastructure.
pgvector vs Pinecone: Which Should You Use in 2026?
pgvector vs Pinecone compared on performance, cost, and developer experience. Find out which vector database fits your AI stack in 2026.
Best Supabase Alternatives for PostgreSQL in 2026
Looking for a Supabase alternative? Compare 7 managed PostgreSQL platforms for 2026, including the best options for pgvector and AI workloads.
pgvector Performance on NVMe vs Cloud SSDs: Benchmarks and Results
We benchmarked pgvector HNSW search on NVMe and AWS gp3 with the same PostgreSQL 18 setup. Here are the numbers, and why storage is the bottleneck nobody talks about.
PostgreSQL 18: What's New and Why It Matters
PostgreSQL 18 brings async I/O, faster JSONB, smarter partitioning, and better replication. Here's what actually matters for production workloads and AI applications.
Getting Started with pgvector on Rivestack
A practical guide to setting up pgvector for AI-powered similarity search on managed PostgreSQL. From first query to production-ready indexes in one sitting.
Why Managed PostgreSQL is the Best Choice for AI Workloads
Self-hosted databases create hidden costs for AI teams. Here's a real breakdown of what it actually costs to run your own PostgreSQL for vector search vs using a managed service.