The "pg_hint_plan" extension allows you to tweak Postgres execution plans, but is highly dependent on normalized SQL statements. shane borden 🛩️ shows how to leverage the extension. stborden.wordpress.com/2023/04/06/usi…

Did you know you can use GitHub Actions to automate Postgres backups? Learn how in this guide. joshstrange.com/2024/04/26/nig…

"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 OtterTune monitors and reports on autovacuum, and tunes multiple knobs tied to it. medium.com/@mert_yavasca/…

Efficient table management in Postgres can improve performance and simplify data insertion and removal. Check out this thorough, beginner-friendly guide from Suffyan Asad. medium.com/@suffyan.asad1…

Every. Single. Time.

What is table partitioning? What are its benefits? When is it helpful and when is it not? Mert Yavaşca goes over those items. medium.com/@mert_yavasca/…

From missing conditions to column order to low selectivity to outdated statistics, Radim Marek goes over scenarios where Postgres may ignore indexes. notso.boringsql.com/posts/why-post…

"pgvector has made significant gains across the board in index build times, index sizes, throughput, and latency," notes Jonathan S. Katz. Check out his year-in-review of pgvector. jkatz05.com/post/postgres/…

Want to level up your MySQL skills? Auriga Aristo dives into subqueries, multiple JOIN types, indexes and a number of optimization techniques. medium.com/xtmd/advanced-…

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. mattermost.com/blog/making-a-…

Join Mateus Trentz for a step-by-step guide about SQL window functions. towardsdatascience.com/understand-sql…

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 OtterTune automatically optimizes. speakerdeck.com/samaysharma/op…

How much do you know about Postgres data types? Rustcode provides an overview of numeric, character, temporal, boolean, binary, array, JSON (and JSONB) and geometric types. rustcodeweb.medium.com/what-are-data-…

Normalization helps reduce redundancy and dependency. This thorough guide goes into the why and types of normalization, and provides examples. medium.com/learning-sql/m…

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. demirhuseyinn-94.medium.com/postgresql-con…

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. medium.com/oracledevs/enh…

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. towardsdev.com/automating-pos…

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. youtube.com/watch?v=z8L202…

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. speakerdeck.com/freshdaz/mysql…

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. notso.boringsql.com/posts/how-not-…