OtterTune

OtterTune Automatically optimize your AWS MySQL and PostgreSQL databases.

06/04/2024

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

Deep dive into SQL & PostgreSQL to build reliable, rock-solid solutions with tips and tricks that keep business online. Data is everything. Explore, learn and innnovate to get them where you need faster and more efficiently.

Like Postgres, a stock implementation of MySQL will only get you so far and throwing more hardware power at issues isn't...
06/03/2024

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.

It’s easy to find generic performance and tuning tips for MySQL, valid for many versions. However, if you are using MySQL 8, you would probably like to know and use the latest features that will optimize your environments. Join this webinar to discover the MySQL 8 specific features that will help ...

Tired of creating indexes in Postgres? Dexter can do it for you. Dileep Kumar shows you how to install and use Dexter. W...
05/30/2024

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.

In the context of the information provided about Dexter and Postgres Indexing, here are some potential prerequisites:

Connection pooling recycles database connections for multiple requests instead of closing them immediately when a query ...
05/29/2024

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.

Leveraging PgBouncer for Efficient PostgreSQL Connection Management

Have you every tuned some of the memory-related k***s or parameters in Postgres? Hüseyin Demir goes over nine of them, s...
05/28/2024

Have you every tuned some of the memory-related k***s 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.

We explore the fundamental role memory plays within the architecture of PostgreSQL databases, shedding light on the intricacies of…

Normalization helps reduce redundancy and dependency. This thorough guide goes into the why and types of normalization, ...
05/27/2024

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

Normalization is a critical concept in database management, particularly in SQL (Structured Query Language), where it ensures the…

How much do you know about Postgres data types? Rustcode Web provides an overview of numeric, character, temporal, boole...
05/24/2024

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.

PostgreSQL, often referred to as Postgres, is a robust open-source relational database management system (RDBMS) known for its advanced…

How do you optimize Postgres for write-heavy work? Samay Sharma goes over tuning autovacuum, healthier checkpoint operat...
05/23/2024

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

Slides from my talk at Citus Con - An Event for Postgres 2023 on Optimizing Postgres for high write workloads. Talk Abstract below: As you ramp up the write load on your Postgres database, you will often benefit from tuning checkpoint and WAL related configs for better performance. In the last decad...

Join Mateus Trentz for a step-by-step guide about SQL window functions.
05/22/2024

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

A step-by-step guide to understanding window functions

Yikes, a query tied to indexing that ran for 1,076 minutes and kept climbing. Alejandro García Montoro dives into the so...
05/21/2024

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.

Learn how we discovered what was slowing down large database queries, and what we did to make Postgres queries 1000x faster.

Want to level up your MySQL skills? Auriga Aristo dives into subqueries, multiple JOIN types, indexes and a number of op...
05/20/2024

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

Explore advanced query techniques to craft powerful, efficient SQL queries that tackle even your trickiest data challenges.

Address

201 S Craig Street Ste 2E
Pittsburgh, PA
15213

Alerts

Be the first to know and let us send you an email when OtterTune posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Share