Aureus Blog
Infrastructure insights
Engineering deep-dives, product updates, and hosting best practices from the Aureus team.
Running pgvector in Production: One Year of Lessons
A year ago we started seeing pgvector workloads on customer clusters in earnest. Some patterns work beautifully. Others quietly destroy your query planner at exactly the wrong moment. Here is what we have learned.
PgBouncer vs Built-in Connection Pooling: What Actually Matters
PostgreSQL 17 ships with improved built-in pooling capabilities. Does that mean you can drop PgBouncer? Usually not. Here's the practical breakdown.
PostgreSQL 17 in Production: What We Changed and What We Left Alone
We've been running PostgreSQL 17 across our cluster fleet since the stable release. Here's an honest account of what's better, what required tuning, and one gotcha we didn't see coming.
How We Migrated a 2TB PostgreSQL Database with Zero Downtime
Moving terabytes of production data without dropping a single request sounds impossible. Here's the exact playbook we used for one of our largest cluster migrations.