Explains how to implement database connection pooling for Django applications using PostgreSQL to improve performance.
A guide for developers on monitoring and improving PostgreSQL database performance, covering cache hit rates and index usage.
A technical deep-dive into making Partition Change Tracking (PCT) refresh with partition truncation work correctly for Materialized Views in Oracle 11g.
Explains why average I/O throughput metrics from AWR snapshots can be misleading for capacity planning, using real database examples.
A technical guide on optimizing SQL queries with wildcard-prefixed LIKE conditions using indexed computed columns for better performance.
Compares three methods for passing multiple IDs to a SQL Server stored procedure: CSV lists, XML, and Table Valued Parameters.
Analysis of a now-removed blog post containing performance results from an Oracle Exadata V2 proof-of-concept test.
James Morle's blog post on identifying key warning signs for diagnosing performance issues in Oracle databases.
