PostgreSQL

15 articles · Page 2 of 2

Database cluster diagram showing data distributed across multiple shards with a routing layer

Database Sharding Strategies and Trade-Offs

A practical guide to database sharding — covering partitioning strategies, shard key selection, cross-shard queries, and the operational complexity that comes with distributing data.

Dec 4, 2021·5 min read

Diagram showing a connection pool managing multiple database connections between an application and database server

Backend

Database Connection Management in Production

How to configure and monitor database connection pools — covering pool sizing, leak detection, failover handling, and common misconfiguration pitfalls.

May 17, 2021·5 min read

SQL EXPLAIN output showing query execution plan with sequential and index scans

Backend

SQL Query Optimization: From Slow Queries to Fast Results

Practical techniques for identifying and fixing slow SQL queries using EXPLAIN plans, indexing strategies, and query restructuring patterns.

Dec 17, 2020·4 min read

View all articles