OtterTune

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

How not to change PostgreSQL column type | boringSQL 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 a scalable solution. Olivier DASINI provides a number of MySQL performance tips.

MySQL 8.0 performance tuning tips - Implementing best practices will get you the scalability you need 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 ...

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.

The Birth of SQL & the Relational Database Links:- The Asianometry Newsletter: https://www.asianometry.com- Patreon: https://www.patreon.com/Asianometry- Threads: https://www.threads.net/-...

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.

Automating Postgres Indexing using Dexter Tool 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 has completed, helping with throughput and latency. Shadab M. gives an overview of how to install and use PgBouncer.

Enhancing OCI PostgreSQL Performance with 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, showing how tuning them can improve latency 10-20% and vacuum performance 12.5%. OtterTune tunes many of these automatically.

PostgreSQL Configuration Chronicles: Memory Related Configurations 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, and provides examples.

Master “Normalization” in SQL 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, boolean, binary, array, JSON (and JSONB) and geometric types.

What are data types in Postgres? 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 operation and background writer. Several of the k***s mentioned OtterTune automatically optimizes.

Optimizing Postgres for high write workloads - Citus Con 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.

Understand SQL Window Functions Once and For All 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 solution to this problem and lessons learned, noting that query optimization is rarely linear.

Making a Postgres query 1,000 times faster 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 optimization techniques.

Advanced Query Techniques in MySQL Explore advanced query techniques to craft powerful, efficient SQL queries that tackle even your trickiest data challenges.