Give your database superpowers with OtterTune's revolutionary machine learning and machine training algorithms that make the database backend run in the best possible configurations, now and in the future.
ottertune.com/features/
OtterTune
788 posts
OtterTune
@OtterTuneAI
Automatically improve your Amazon RDS and Aurora MySQL and PostgreSQL database efficiency & performance.
- Let's face it: manual database optimization is the worst. Let OtterTune put database optimization on autopilot So you can get back to what you do best. ottertune.com/features/
- Don't own an otter? Do the next best thing and take OtterTune for a spin on your database: ottertune.com/try
00:00 - 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.
- Imagine you have a Postgres table that has 1.5 billion rows and it's growing by 300k rows every minute. Take a journey into indexes, ANALYZE and more.
- 👻 "When a row in PostgreSQL is updated or deleted, it doesn't disappear. Instead, it evolves into a 'dead tuple' - think of it as the row's ghost," writes Fırat Tamur. Check out his overview of dead tuples, MVCC and vacuum in Postgres. 🐘
- In his latest article, @andy_pavlo discusses the top 3 reasons people pay @JeffBezos too much for their databases on Amazon RDS and what Bezos buys for himself with that extra cash. Help bring Bezos' spending habits back down to earth: ottertune.com/blog/overpayin…
- Time for a deep, nerdy dive. @eatonphil does an extensive walk through a Postgres query plan. notes.eatonphil.com/2023-11-19-exp…
- From the rise of vector databases to SQL:2023 to MariaDB troubles and the FAA outage, 2023 was an exciting year in database history. @OtterTuneAI CEO @andy_pavlo covers all that, plus database VC funding. ottertune.com/blog/databases…
- 🐘 This PostgreSQL post from @andatki is a gold mine. It's loaded with tips and tricks covering topics like queries, autovacuum and indexes, as well as shares some great resources and tools. 🔥
- Slow #PostgreSQL queries are the worst. Read about how we tricked Postgres' planner to make the right decision for an ORDER BY LIMIT query without the use of hints: ottertune.com/blog/fixing-sl…
- Benchmark wars, #PostgreSQL dominance, and Larry Ellison's comeback. Read Dr. @andy_pavlo's review of 2021 DBMS industry highlights.
- Want a FREE dashboard for Postgres that monitors system stats, queries, disk space, connections, autovacuum and knob settings, and can run EXPLAIN? Check out PgHero.
- Did you miss @andy_pavlo's "Databases in 2023: A Year in Review" blog? Check out our video companion where he goes over the blog and provides additional commentary
