Expert PostgreSQL tutorials, tips, and performance optimization guides. Learn database administration, query optimization, and best practices for PostgreSQL 18 and beyond.
Vector search has moved from exotic to table stakes. pgvector is bundled into Amazon RDS and Aurora, Google Cloud SQL, Azure Database for PostgreSQL, and countless self-managed clusters — and the benchmark posts keep coming: 10,000 queries per second! 50x faster than brute force! The New Stack recently published a sharp critique of the genre […]
If you’ve been paying attention to the AI landscape in early 2026, you’ve almost certainly stumbled across the name OpenClaw. It blew past 280,000 GitHub stars in just weeks, Jensen Huang called it “the new Linux” at NVIDIA GTC 2026, and developers everywhere are asking the same question: where does PostgreSQL fit into all of […]
Remember when building an AI app meant stitching together five different databases? A relational database for your core data, Pinecone for vectors, Elasticsearch for search, Redis for caching, and maybe InfluxDB if you had time-series needs. Each one with its own query language, backup strategy, and 3 a.m. pager duty incident. That era is over. […]
Retrieval-Augmented Generation (RAG) has become one of the most practical applications of AI in production systems, and PostgreSQL’s pgvector extension has emerged as a robust solution for implementing vector search. However, getting optimal results requires more than just installing pgvector and throwing embeddings at it. Let’s explore proven best practices and real-world examples to help […]
PostgreSQL has quietly crossed an important line in the last year: AI with Postgres is no longer a science project, it is genuinely competitive with specialized vector databases at production scale. From “possible” to “competitive” For a long time, the story around AI and Postgres sounded like “you can do it if you really want […]
