Database
Christophe Pettus: Everyone into the Pool
Planet PostgreSQL0 views
PostgreSQL connection poolers lie to both sides of the wire: your app thinks it has thousands of connections while the database sees dozens. (I consult on PostgreSQL through PGX Inc..)
Source:https://postgr.es/p/9w_PreviousPrateek Arora: I timed 179 index recommendations on real data. 18% made the query slower.NextChristophe Pettus: The Vector That Lied About Its Dimensions
Related posts

We're Looking for 10 dbt Developers to Test Relationship-Aware JOINs — 12 Months Free
0dev.to Data
The Best Disaster Recovery Solutions for Cross-Geography Replication (2026): Compared by What They Replicate
0dev.to Database

SQL Challenge: Can You Find the Second Purchase of Every Customer Using ROW_NUMBER()?
0dev.to Database

Database Migrations at Scale: How to Change Production Databases Without Breaking Applications
0dev.to Database

The Double-Booked Seat: Fixing a Booking Race Condition in Postgres
0dev.to Database

Preventing Duplicate Contact Names From Silently Corrupting Your Lending Ledger
0dev.to Database