Andrew Atkinson

PostgreSQL uses a complex system of locks to balance concurrent operations and data consistency, across many transactions. Those intricacies are beyond the scope of this post. Here we want to specifically look at queries that are waiting, whether on locks...

PostgreSQL

This post will look at the basics of PostgreSQL Savepoints within a Transaction.

PostgreSQL

In this talk attendees will learn how Ruby on Rails and PostgreSQL can be used to create scalable SaaS applications, focusing on schema and query design, and leveraging database capabilities.

PostgreSQL Ruby on Rails

Hey there! My book High Performance PostgreSQL for Rails just went into print last week!

Ruby on Rails Databases Books PostgreSQL

I loved joining Jeremy Smith and Jess Brown as a guest on the IndieRails podcast!

Podcasts PostgreSQL

At Sin City Ruby 2024 earlier this year, I presented a series of advanced PostgreSQL topics to Rails programmers. Afterwards, a number of people provided feedback on surprising or interesting things from the presentation.

PostgreSQL Ruby on Rails

Recently I joined Justin Garrison and Autumn Nash for episode “FROM guests SELECT Andrew” of Ship It!, a Changelog podcast.

Podcasts Open Source PostgreSQL

Andrew Atkinson. RailsConf 2024. Photo: Alice Heart Photography

Ruby on Rails Podcasts Conferences Open Source

This post looks at some interesting new capabilities managing Partitioned Tables coming in PostgreSQL 17, expected for release Fall 2024. The current major version is 16.

PostgreSQL Open Source

Recently I joined Ry Walker, CEO of Tembo, as a guest on the Hacking Postgres podcast.

Podcasts PostgreSQL Open Source Ruby on Rails