'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/…

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

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…

It seems like a simple question: Will Postgres use my index or not? Denis Magda stumbled upon an index question on Reddit and turned it into a great scenario and teaching moment. medium.com/@magda7817/wil…

Latest OtterTune release notes👇

📊New feature: Trends. Get comparative data about your DBs and similar OtterTune accounts.
✅Updates to index recs. Longer observation periods, less-strict cluster criteria, etc.
🎉Many other fixes and enhancements.

updates.ottertune.com/en/whats-in-th…

How many hours a month do you spend optimizing MySQL or Postgres knobs / parameters?

There's always more than one way to write a query. Jobin Augustine dives into different ways of writing queries for Postgres to show where things can go wrong and what should be considered. percona.com/blog/sql-optim…

Do you know the differences between Amazon RDS and Aurora? Ashish Patel provides this overview. On the OtterTune front, we've found we can get 15-20% better performance out of Aurora vs. RDS which helps offset the price increase for Aurora. medium.com/awesome-cloud/…

Indexes in Postgres are about balance: too many can cause issues and too few can as well. Dmitry Romanoff shares a query for finding ineffective indexes with a breakdown of its lines. medium.com/@dmitry.romano…

Sometimes a simple and small query can cause big issues. (Dr.) Eric Fritz uses that type of situation as a learning experience and does a deep dive in query debugging. render.com/blog/postgresq…

As Hüseyin Demir notes, optimizing timeout settings in Postgres can prevent resource exhaustion, enhance responsiveness and mitigate deadlocks. Many of the knobs he references are automatically optimized by OtterTune. demirhuseyinn-94.medium.com/postgresql-con…

🌱 A 50% cost reduction and no more data inconsistencies. Learn how Tony Dang and Infisical moved from MongoDB to Postgres. 🐘infisical.com/blog/postgresq…

How much has the Postgres query optimizer improved over the years? When using Join Order Benchmark (JOB), Ryan Marcus found an average 15% performance improvement with each version of Postgres. rmarcus.info/blog/2024/04/1…

True, but please don't disregard backups.

Lots of great updates in the latest OtterTune release.

🛢️Index recommendations for clusters.
✅ Improved tooltips and counters.
🗓️ More filters and granular date picker for reports.
🚀 And much more 👍

updates.ottertune.com/en/whats-in-th…

Looking to sanitize your Postgres input? Check out this code snippet from Cyrill Bolliger 🥸 that strips any whitespace characters (spaces, tabs, newlines, carriage returns) in the beginning and the end of text inputs. ✂️ medium.com/@cyrillbollige…

Managing a large Postgres table with millions of records and need to create an index? Wouldn't it be helpful if you had a checklist? Dmitry Denshchikov has you covered. ✅ medium.com/@HereAndBeyond…

Learn via Doron how you can scale Postgres via partitioning (inheritance and declarative) and sharding (application and extensions). doronsegal.medium.com/scaling-postgr…

Be careful when a product mentions it uses AI. Usually it's OpenAI, Gemini, etc. That's not the case with OtterTune. Our models are custom built and tailored to real-world objectives like P99 query latency, average latency, CPU utilization, throughput and read/write IOPs.

We give a lot of attention to Postgres tips, but what about MySQL? From normalizing data to cache aggregations to batch statements, Priyank Gondaliya offers 15 tips. medium.com/@priyankgondal…