Andrew Atkinson

Celebrating 2 years of High Performance PostgreSQL for Rails being published. Let's review results about PostgreSQL from the 2026 Ruby on Rails Community Survey and give away some books.

PostgreSQL Ruby on Rails Databases Ruby

Discussing database scaling work, technical books, and using AI with co-hosts Brendan and Ryan on the Rails Business Podcast

PostgreSQL Databases

Let's see how switching to PostgreSQL 18’s native UUIDv7 time-ordered UUIDs affected locality and performance compared with v1 and v4 primary key values.

PostgreSQL Databases

How Aura Frames refactored Active Record code in Ruby on Rails, splitting from one primary database to eight, handling 41 million requests per hour and reaching #1 in the App Store.

Ruby on Rails Ruby PostgreSQL Performance

How Aura Frames scaled Postgres from one primary database to eight, sustaining more than 100K TPS through Christmas Day and reaching #1 in the App Store.

PostgreSQL Databases SQL Performance

The Postgres community releases Beta versions, and with Docker it’s been easier than ever to configure pre-release versions to use and test.

PostgreSQL Databases

In this post we’ll cover two types of Postgres internals.

PostgreSQL Databases

Introduction Over the last decade, when working on databases with UUID Version 41 as the primary key data type, these databases have usually had bad performance and excessive IO. https://datatracker.ietf.org/doc/html/rfc4122#section-4.4 ↩

PostgreSQL Databases Ruby on Rails

Introduction In this post, we’ll cover some database design principles and package them up into a catchy mnemonic acronym.

PostgreSQL Databases

Introduction Much of the time taken processing HTTP requests in web apps is SQL queries. To minimize that, we want to avoid unnecessary and duplicate queries, and generally perform as few queries as possible.

Ruby on Rails PostgreSQL