percona.com
Unknown
Percona is an open-source database solutions site focused on performance, tuning, and optimization. It features tutorials, blogs, webinars, case studies, and tools for MySQL, PostgreSQL, and MongoDB performance, backups, and monitoring.
More resources on Database Performance
use-the-index-luke.com
A practical guide to database indexing and query optimization, offering clear explanations of how indexes work, how to design them, and tutorials with SQL examples across major relational databases.
Explain Extended
Long-running blog by Quassnoi devoted to SQL query performance, dissecting individual problems across MySQL, PostgreSQL, SQL Server and Oracle with execution plans, timings and rewritten queries. Shows why an optimizer picks a plan and how rewrites change it.
PG Mustard Blog
Michael Christofides' blog at pgMustard on PostgreSQL query performance: reading EXPLAIN output and query plans, indexing strategy, pg_stat_statements, and changes in new Postgres releases, with practical guidance for diagnosing and fixing slow queries.
Percona Blog
Engineering blog from Percona, a MySQL, PostgreSQL and MongoDB support vendor. Posts benchmark storage engines, dissect replication and failover behaviour, and explain version changes, giving practitioners evidence-based guidance on tuning and operating open-source databases in production.
High Performance MySQL
A practical guide to MySQL performance from Percona engineers, covering schema and index design, query optimization, replication, scaling, and server tuning. Readers learn to diagnose bottlenecks and configure MySQL for high-throughput production workloads.
SQL Performance Explained
A concise, vendor-neutral book on SQL indexing for developers, covering B-tree internals, WHERE-clause indexing, joins, sorting, and partial results across Oracle, MySQL, PostgreSQL, and SQL Server. Readers learn to design indexes that make queries fast.