oltp – WorthPosting

Software Engineering

Database Connection Pooling: PgBouncer, Pool Sizing, and the Math Behind Both

September 2, 2026September 3, 2026 teliaz

Every PostgreSQL connection is a process on the server. Not a thread, not an entry in a table — a

Continue readingDatabase Connection Pooling: PgBouncer, Pool Sizing, and the Math Behind Both

Software Engineering

Row Stores vs Column Stores: Why Analytics and OLTP Are Opposites

August 25, 2026August 26, 2026 teliaz

Every data engineer eventually has the same moment: the dashboard query that was instant on a million rows takes ninety

Continue readingRow Stores vs Column Stores: Why Analytics and OLTP Are Opposites