Case Studies

8 pages in this section.

A conceptual model for how to read, evaluate, and transfer lessons from PostgreSQL reference architectures and before/after case studies without copying someone else's context by mistake.

Explainer Case Studies Reference Architecture Postmortems

Reference: Multi-Tenant SaaS

Examine a multi-tenant SaaS architecture using PostgreSQL 18.4, PgBouncer, and Patroni. Learn about RLS, connection pooling, and migration strategies.

Sql Case Studies Reference Multi

Reference: Analytics Replica Topology

Configure an analytics replica topology for PostgreSQL 18.4 with a 15-minute delayed replica for BI and dbt workloads, isolating them from OLTP.

Sql Case Studies Reference Analytics

Reference: pgvector RAG Store

Explore a pgvector RAG store reference for PostgreSQL 18.4+, pgvector 0.8+, with 40M chunks, HNSW tuning, and RLS for multi-tenant SaaS.

Sql Case Studies Reference Pgvector

Before/After: Major Version Upgrade

Sql Case Studies Advanced Before

Before/After: Query Optimization Win

Sql Case Studies Advanced Before

Case Studies Best Practices

Learn best practices for authoring and consuming internal PostgreSQL case studies, including metadata, rigor, and safety considerations.

Sql Case Studies Best Practices List

Case Studies Highlights Summary

A single-page roundup of every highlight bullet from the 7 pages in the Case Studies section, grouped by source page so you can scan all 41 takeaways without opening each article individually.

Highlights Summary Case Studies

Case Studies

Search Documentation

Case Studies