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. @freshdaz provides a number of MySQL performance tips.

Join millions who have switched to Grok.

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 Mohammad gives an overview of how to install and use PgBouncer.

Have you every tuned some of the memory-related knobs or parameters in Postgres? @d3rh5n goes over nine of them, showing how tuning them can improve latency 10-20% and vacuum performance 12.5%. @OtterTuneAI 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? @rustcodeweb 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_sharma goes over tuning autovacuum, healthier checkpoint operation and background writer. Several of the knobs mentioned @OtterTuneAI automatically optimizes.

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

Yikes, a query tied to indexing that ran for 1,076 minutes and kept climbing. Alejandro García Montoro dives into the solution to this problem and lessons learned, noting that query optimization is rarely linear.

Want to level up your MySQL skills? Auriga Aristo dives into subqueries, multiple JOIN types, indexes and a number of optimization techniques.

"pgvector has made significant gains across the board in index build times, index sizes, throughput, and latency," notes @jkatz05. Check out his year-in-review of pgvector.

From missing conditions to column order to low selectivity to outdated statistics, Radim Marek goes over scenarios where Postgres may ignore indexes.

What is table partitioning? What are its benefits? When is it helpful and when is it not? Mert Yavaşca goes over those items.

Every. Single. Time.

Efficient table management in Postgres can improve performance and simplify data insertion and removal. Check out this thorough, beginner-friendly guide from @Suffyan_Asad.

"Never ever disable autovacuum. It is your ally. If you have any problem with autovacuum, tune it properly. Don’t disable it," notes Mert Yavaşca. That's why @OtterTuneAI monitors and reports on autovacuum, and tunes multiple knobs tied to it.

Did you know you can use GitHub Actions to automate Postgres backups? Learn how in this guide.

The "pg_hint_plan" extension allows you to tweak Postgres execution plans, but is highly dependent on normalized SQL statements. @sborden76 shows how to leverage the extension.