OtterTune

Changing column type in Postgres should be a quick ALTER TABLE command, but that has downstream impacts you should consider. Radim Marek dives into the internals of what Postgres must do and how to safely change column type for production environments

Like Postgres, a stock implementation of MySQL will only get you so far and throwing more hardware power at issues isn't a scalable solution. Olivier DASINI provides a number of MySQL performance tips.

Now this is our kind of documentary: a history of SQL and relational databases. Many thanks to Asianometry for putting to this together. Be sure to check out his other SQL videos, too.

Tired of creating indexes in Postgres? Dexter can do it for you. Dileep Kumar shows you how to install and use Dexter. When it comes to indexes, more is not always better, so proceed with caution.

Connection pooling recycles database connections for multiple requests instead of closing them immediately when a query has completed, helping with throughput and latency. Shadab M. gives an overview of how to install and use PgBouncer.

Have you every tuned some of the memory-related knobs or parameters in Postgres? Hüseyin Demir goes over nine of them, showing how tuning them can improve latency 10-20% and vacuum performance 12.5%. OtterTune tunes many of these automatically.

Normalization helps reduce redundancy and dependency. This thorough guide goes into the why and types of normalization, and provides examples.

How much do you know about Postgres data types? Rustcode Web provides an overview of numeric, character, temporal, boolean, binary, array, JSON (and JSONB) and geometric types.

How do you optimize Postgres for write-heavy work? Samay S. goes over tuning autovacuum, healthier checkpoint operation and background writer. Several of the knobs mentioned OtterTune automatically optimizes.

Join Mateus Trentz for a step-by-step guide about SQL window functions.