Andrew Atkinson

#1 in Ruby programming, top 80 all databases books, top 80k of all books on Amazon among millions. Alright! Thank you very much to readers!

"High Performance PostgreSQL for Rails" is currently #1 in the Ruby Programming category on Amazon. Thank you readers! @pragprog.com #ruby #postgres #books a.co/d/0azDDVMq

🐘 PostgreSQL continues to dominate within Ruby on Rails 📚 High Performance PostgreSQL for Rails ranked #12 among recommended books in the 2026 Ruby on Rails Community Survey! 🎉 To celebrate, I'm giving away two signed copies of the book. Check the post for more. andyatkinson.com/2026-rails-c...

Wrote a thing about last week's Rails World. andycroll.com/ruby/look-a...

Here at Postgres Summit 2026. Let’s chat about Rails, Postgres, books, and digital photo frames! Excited to present on the work we did at @auraframes.bsky.social tomorrow morning at 10:30 AM. bsky.app/profile/pgsu...

🗽 Excited to be in New York this week to work with teammates at @auraframes.bsky.social and present at @pgsummitus.bsky.social on Thursday. Let‘s connect! bsky.app/profile/pgsu...

Let’s go Lynx! 🏀

Seems the URL I originally posted isn’t resolving, so here’s the correct one: www.railsbusiness.com/2435951/epis...

PgBouncer 1.26 is out with two pre-auth DoS fixes, so upgrade tonight if untrusted clients can reach it. The quieter change: search_path is tracked by default now, but only on PG 18+. On 17 and older, SET search_path in transaction pooling still leaks to whoever gets the connection next.

Couldn‘t take the heat so had to get out of the Austin. 😬 Back in sunny and 65F Minneapolis.

Ready for bats in a few hours. #Austin

Bringing 2 signed copies of High Performance PostgreSQL for Rails to give away at Rails World! #books #pgrailsbook

Every schema constraint you skip becomes an if statement in six places, and one of them will be missing. Put it in the database where it cannot be forgotten. #RubyOnRails #Rails #PostgreSQL

Interesting speedups from recent work switching to uuid v7 primary keys: www.reddit.com/r/PostgreSQL...

Take a look at “How Aura Frames Scaled RDS Postgres for Peak Christmas Traffic (#1 in App Store)” with Andrew Atkinson at Postgres Summit US 2026! postgresql.us/events/postg... #PostgreSQL #postgres #conference

I see users excited by REPACK in PostgreSQL 19 (currently in beta), because it looks like a simple command that reduces table bloat. But it's not that simple. You will need to think about FILLFACTOR twice. Example in a new blog post: dev.to/franckpachot...

Striking while the iron was hot, we took it to Postgres FM with Michael and Nik and nobody in that room can be accused of being a fanboy. postgres.fm/episodes/mvcc

Upgrade Rails immediately, kids, this is a big one. github.com/rails/rails/...

> "In other words, I am continually looking for the least complexity for the current requirements and constraints and nothing else." dannorth.net/blog/best-si...

PostgreSQL 18 introduced temporal keys. With the release of PostgreSQL 19 Beta 1, PostgreSQL continues to build on that foundation with even more temporal features. Wrote a blog about WITHOUT OVERLAPS, PERIOD, UPDATE/DELETE ... FOR PORTION OF and more on temporal databases: xata.io/blog/postgre...

Posted Part 2 of Scaling Rails at Aura Frames on Lobsters, and it's doing pretty well. If you're active there (or HMU for an invite), please take a look. Thanks! lobste.rs/s/zijb20/sca...

PostgreSQL 19 beta: you can start logical replication without a restart. wal_level=replica now suffices, effective_wal_level reports what is actually in effect, and sequence values finally replicate. www.postgresql.org/docs/19/rele... pgexperts.com

Here's Part 2 of the Aura Frames Christmas scaling story, focused on how we scaled Ruby on Rails from 1 to 8 databases to handle peak holiday load. #rubyonrails #databases #scaling #postgresql andyatkinson.com/how-aura-fra...

If you use Hacker News and found this post on the Aura Frame Postgres scaling retrospective interesting, I'd appreciate an upvote! Thanks for considering it. news.ycombinator.com/item?id=4857...

Take a look at how we successfully expanded our Postgres architecture to handle millions of customers setting up hundreds of thousands of new Aura digital photo frames on Christmas Day 2025. #postgresql #databases #scaling andyatkinson.com/postgresql-r...

Take a look at how we successfully expanded our Postgres architecture to handle millions of customers setting up hundreds of thousands of new Aura digital photo frames on Christmas Day 2025. #postgresql #databases #scaling andyatkinson.com/postgresql-r...

🎙️ New #TalkingPostgres podcast Ep40 is out! Jeremy Schneider talked user groups & co-organizing the Seattle Postgres User Group. Also: Happiness Hints, Oracle to Postgres transitions, & why "it’s like I was born to be here" 🎧 talkingpostgres.com/episodes/how... 📺 www.youtube.com/watch?v=sRod...

Back in 2022, Jason and I discussed the use of NOT VALID for Check and FK constraint types in Postgres. Jason asked why they're not available for NOT NULL around 43:30? Episode #160 @jasonswett.bsky.social 3.5 years later we got 'em! www.codewithjason.com/podcast/1122... bsky.app/profile/andy...

Missed this in PG 18! #postgres We can now add "not null" constraints gradually by using "not valid" initially, which was previously limited to being used for check and foreign key constraint types. Nice. medium.com/@amaan2000mo...

Hey backend devs that use Postgres: get after it! Beta Testing PostgreSQL With Docker andyatkinson.com/postgresql-b...

Sale - The Human Side Times are wildly unpredictable right now. Supporting your human side is critical to your ability to adapt. 50% off these titles (and all previous week's titles) with code Spring2026. (AudioBook versions included) Links below

Gave a talk today at #PGData2026 on #Postgres plan management and monitoring. Some exciting changes coming to Postgres 19, and pg_stat_plans (plan statistics) now supports the new release. Full slides from the talk: resources.pganalyze.com/pganalyze_PG...

Thanks to yosifkit and Docker: up and running with Postgres 19 Beta 1. Ready to do some tests. github.com/docker-libra... #pgdata #pgdata2026

Must-reads for Postgres performance enthusiasts! Very comprehensive Radim 👏 @boringsql.com

Humanizing Keynote from Robert Haas at PG Data 2026. It’s about the people. They’re doing hard work. It’s a huge global community. Still need more contributors! Good messages. #pgdata2026 #postgres

“A query that runs in 1ms 99% of the time and 2 seconds the other 1% has a mean_exec_time around 21ms, a number that matches none of its real executions and hides the p99 that's paging your on-call.” @boringsql.com boringsql.com/posts/pg-sta...

And when I’m back in Chicago, I feel it. #pgdata #pgdata2026

Participants are going to set up PGSS on their Docker Postgres instances and we will get into some of its features and limitations! #pgdata2026 #workshops Nice expansion on both by @boringsql.com bsky.app/profile/bori...

Hope to see you at PG DATA 2026 in Chicago this Thursday! We'll go through a workshop in 3 parts covering Postgres query performance, index design, schema management, working with multiple databases, and more! Late registration? Code "ATKINSON50" takes 50% off 2026.pg-data.org

Thanks for the shout out @jessehanley.bsky.social and the heads up about it @jesper.dev! Really enjoyed listening to the trials and tribulations of the Bento (bentonow.com) database migration! cc @aaronfrancis.com bsky.app/profile/most...

Nobody Cracks Open a Programming Book Anymore unix.foo/posts/nobody...

Spring Bank Holiday, Memorial Day, Whit Monday - whatever holiday is happening around you today, take advantage of our annual SPRING SALE! Hand-picked books for right now - 50% off with code Spring2026 Details - see our most recent newsletters: pragprog.com/news/in...

@benediktdeicke.com congrats on the Rails PR 🎉 github.com/rails/rails/...

I’ve got a couple of big blog posts and a book discount code dropping soon, exclusively for newsletter subscribers! Don’t miss it. Subscribe here: pgrailsbook.com

"A roadmap to scaling Postgres" by Kaarel Moppel kmoppel.github.io/2025-04-10-p...