Andrew Atkinson
LightNews LightNews
banner
andyatkinson.com
Andrew Atkinson
@andyatkinson.com
2.2K followers 130 following 310 posts
Author of High Performance PostgreSQL for Rails, Staff Engineer, Consultant, Speaker

andyatkinson.com/pgrailsbook
Posts Replies Media Videos
Pinned
andyatkinson.com
Andrew Atkinson @andyatkinson.com · Oct 1
#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!
Book page on Amazon screenshot Book page rankings by category on Amazon
Reposted by Andrew Atkinson
pgmustard.com
Thanks again for the idea Andy, blog post published, let us know if it could be clearer or more useful — Michael
www.pgmustard.com/blog/what-do...
What do the new Index Searches lines in EXPLAIN mean? - pgMustard
In Postgres 18 you’ll now see “Index Searches” lines in EXPLAIN ANALYZE output. If like me you were wondering what those mean exactly, you’re in the right place.
www.pgmustard.com
November 10, 2025 at 1:43 PM
Reposted by Andrew Atkinson
jorinvo.bsky.social
Learn Bash and SQL.

I have used so many programming languages and even more frameworks over the years.
But basically every project used Postgres and Linux.
Learning shell scripting and SQL is probably the best tech investment I made.
November 7, 2025 at 7:42 AM
andyatkinson.com
🎃 What’s spookier than deploying a high risk change, months of work, 100s of commits, on a Halloween Friday?

Doing that without the rounds of unit tests, load tests, canary releases, and dozens of PRs/deploys this had. Fortunately the release today was buttery smooth!

🍬 Now let’s eat candy!
October 31, 2025 at 8:08 PM
Reposted by Andrew Atkinson
pg-data.bsky.social
🎉Early Bird Registration is NOW OPEN for PG DATA 2026!

Early Bird Tickets: Just $30 (first 100 registrations)
Student Early Bird Tickets: Only $20 (first 50 students)

🔗Register now: www.eventzilla.net/e/pg-data-20...

#PGDATA2026 #PostgreSQL #EarlyBird #TechConference
PG DATA 2026 - Powered by Eventzilla
www.eventzilla.net
October 24, 2025 at 5:49 PM
Reposted by Andrew Atkinson
tylerhillery.com
I did Postgres dirty with this one
October 20, 2025 at 12:50 AM
andyatkinson.com
So cool to see "High Performance PostgreSQL for Rails" listed on the official PostgreSQL books wiki page.

Thank you to @clairegiordano.bsky.social for the encouragement and help making that happen.

Check it out 👉
www.postgresql.org/docs/books/
PostgreSQL: Books
www.postgresql.org
October 15, 2025 at 4:51 PM
andyatkinson.com
Wow, High Performance PostgreSQL for Rails has the best ranking ever on Amazon right now.

#1 Ruby "Best Seller" badge
#3 Database Storage & Design
#56 Databases & Big Data
#71,948 All books

Maybe it's the PostgreSQL 18 release or @pgconfnyc.bsky.social driving it? Fun!

a.co/d/bkVZPeo
Amazon ranking positions for book High Performance PostgreSQL for Rails
October 3, 2025 at 9:21 PM
Reposted by Andrew Atkinson
lucianghinda.com
Whenever I create a new table or column in a web app, I aim for clarity so that anyone connecting directly to the database can easily understand it.

This approach involves trade-offs; performance is often one of them. Be aware.

Let me give some examples:
October 3, 2025 at 7:45 AM
andyatkinson.com
❄️🥶 Melanie Plageman presenting on advancements in vacuum freeze in Postgres 18 @pgconfnyc.bsky.social #postgresql
Melanie Plageman presenting what’s new in vacuum freeze in Postgres 18
October 1, 2025 at 3:16 PM
andyatkinson.com
Shane Borden presenting on my favorite database topics — index design and performance optimization

@pgconfnyc.bsky.social #postgresql
Shane Borden Pg Conf NYC 2025
October 1, 2025 at 1:41 PM
Reposted by Andrew Atkinson
samokhvalov.bsky.social
What do you like most in Postgres 18? Look at www.postgresql.org/docs/release... and tell me.

I'll go first, my top-3 list:
PostgreSQL: Release Notes
www.postgresql.org
September 30, 2025 at 7:27 PM
andyatkinson.com
Andres Freund sharing some very exciting performance gains being worked on with Async IO infrastructure now in place in 18.

Future Postgres versions will benefit from this for index scans, backwards scans, bgwriter, checkpointer, copy, vacuum and much more. @pgconfnyc.bsky.social
September 30, 2025 at 4:03 PM
andyatkinson.com
Great to see Robert Treat honored as Volunteer of the Year at PG Conf NYC 2025. Well deserved! @pgconfnyc.bsky.social
Robert Treat on stage winning volunteer of the year PG Conf NYC
September 30, 2025 at 1:54 PM
andyatkinson.com
First time finding a local Pickleball open play while traveling. Found a City Pickle Wollman Rink slot this morning before the conference.

🏙️ Hard to beat the Central Park NYC skyline views.
Andrew City Pickle Central Park Wollman Rink
September 29, 2025 at 7:02 PM
andyatkinson.com
Had a great time presenting Multitenancy Patterns at PGConf NYC 2025 @pgconfnyc.bsky.social

Slides: speakerdeck.com/andyatkinson...

SQL demos/GitHub Repo: github.com/andyatkinson...
September 29, 2025 at 6:39 PM
andyatkinson.com
2 million indexes! You’ve gotta listen to this in context of this Gadget episode with Harry — but that’s a wild figure! 😳

postgres.fm/episodes/gad...
Postgres FM | Gadget's use of Postgres
Nik and Michael are joined by Harry Brundage from Gadget to talk about their recent zero-downtime major version upgrade, how they use Postgres more generally, their dream database, and some challen...
postgres.fm
September 28, 2025 at 7:18 PM
andyatkinson.com
🍎 Heading to the big apple for 3 days of all-you-can-eat Postgres at @pgconfnyc.bsky.social
September 28, 2025 at 6:08 PM
andyatkinson.com
What are SLRUs and MultiXacts in Postgres? What can go wrong?

andyatkinson.com/postgresql-s...
What are SLRUs and MultiXacts in Postgres? What can go wrong?
In this post we’ll cover two types of Postgres internals.
andyatkinson.com
September 25, 2025 at 4:37 PM
Reposted by Andrew Atkinson
pgconfnyc.bsky.social
Learn all about “Multitenancy Patterns in Community PostgreSQL” with Andrew Atkinson at PGConf NYC 2025!

postgresql.us/events/pgcon...

@PostgreSQL #postgres #conference
PGConf NYC 2025 | PostgreSQL Conference
PGConf NYC 2025 will be held from on September 29th - October 1st in New York City, NY at Convene 117 West 46th Street.
postgresql.us
September 5, 2025 at 4:53 PM
Reposted by Andrew Atkinson
pragprog.com
48 hour FLASH! 45% off with code FLASHSALE
@pragdave felt like stirring things up - he just put nearly every title on sale!
September 18, 2025 at 12:12 PM
Reposted by Andrew Atkinson
rorvswild.com
Just landed in Porto for #Euruko.
If you're around, come see us to talk about your #RubyOnRails app's performances.

www.rorvswild.com/blog/2025/pe...
Personalized application performance discussion - RorVsWild
Let's talk about your application during Euruko!
www.rorvswild.com
September 17, 2025 at 2:33 PM
Reposted by Andrew Atkinson
noelrappin.com
The Pragmatic Bookshelf is running a 48-hour flash sale. Get 45% off almost everything with promo code "flashsale".
pragprog.com

Programming Ruby 3.3 definitely included.
Pragmatic Bookshelf: By Developers, For Developers
We improve the lives of professional developers. We create timely, practical books on classic and cutting-edge topics to help you learn and practice your craft, and accelerate your career. Come learn ...
pragprog.com
September 17, 2025 at 6:42 PM
Reposted by Andrew Atkinson
billkarwin.geek.org
Pragmatic Bookshelf publishes great books on technology, and this week (Sept 18-20) they're having a 48-hour flash sale.

My book SQL Antipatterns, Volume 1 is among those on sale. Both print and digital edition.

Use promo code "flashsale" for the 40% discount.
SQL Antipatterns, Volume 1
SQL Antipatterns is a short-cut to wisdom, showing you how to avoid easy solutions that don't work, and be a better database developer in any language.
pragprog.com
September 17, 2025 at 7:03 PM
andyatkinson.com
> This was a great book, diving deep into what every software engineer will eventually have to face: Tuning, scaling, maintenance, and some recommended tools to do those things.

August 30, 2025 @pragprog.com #pgrailsbook #postgresql

www.amazon.com/gp/customer-...
September 11, 2025 at 10:25 PM
Reposted by Andrew Atkinson
audthecodewitch.dev
Finally restarting "High Performance PostgreSQL for Rails" by @andyatkinson.com. All my notes were on my work computer, so I'm starting fresh! I'm excited to be back in "Learning Mode." #WomenInTech #WomenWhoCode #PostgreSQL
pragprog.com/titles/aapsq...
High Performance PostgreSQL for Rails
Build fast, scalable PostgreSQL and Rails apps. Solve data growth, quality, and reliability challenges, for workloads from consumer Internet to enterprise SaaS.
pragprog.com
September 9, 2025 at 4:55 PM