Category: Features and extensions

Deep dives into new PostgreSQL release features and how to use them in real apps.

Practical guides to popular extensions (PostGIS, pg_partman, pg_stat_statements, vector/TSDB extensions, etc.).

Features and extensions postgresql

PostgreSQL Developer Ergonomics: How EXPLAIN, SQL/JSON, and Replication Features Are Making Life Easier

When you’re deep in the trenches of database work—optimizing queries, debugging replication lag, or untangling JSON transforms—the quality of your tools matters. PostgreSQL has always been powerful, but the community has been laser-focused on something equally important: making that power accessible. Developer ergonomics—how smoothly you can understand, debug, and deploy database logic—is front and center […]

Avatar photo admin 
AI Features and extensions pgvector

PostgreSQL pgvector and RAG: Best Practices and Examples for Better Results

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 […]

Avatar photo admin 
Features and extensions postgresql

What Is pgvector and When You Should Use It Instead of a Dedicated Vector DB

pgvector is a PostgreSQL extension that adds a native vector data type and similarity search so you can turn Postgres into a capable “vector DB” without adding new infrastructure. For many workloads—especially RAG over modest corpora, recommendations tied tightly to transactional data, and anomaly detection in existing Postgres-backed systems—pgvector is often simpler and cheaper than […]

Avatar photo admin 
AI Features and extensions pgvector pgvectorscale

PostgreSQL Vector Search: From Possible to Competitive with pgvector and pgvectorscale

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 […]

Avatar photo admin