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 Media Videos Starter Packs
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
2 2 12
andyatkinson.com
Andrew Atkinson @andyatkinson.com · 6h
Nice work Cody!
1
Reposted by Andrew Atkinson
pg-data.bsky.social
pg-data.bsky.social @pg-data.bsky.social · 4d
🎉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
2 2
Reposted by Andrew Atkinson
tylerhillery.com
Tyler Hillery @tylerhillery.com · 8d
I did Postgres dirty with this one
2 1 36
andyatkinson.com
Andrew Atkinson @andyatkinson.com · 12d
Appreciate it! If you feel motivated to do so, positive reviews & ratings on your platform of choice really help. Thanks for considering it.
1
andyatkinson.com
Andrew Atkinson @andyatkinson.com · 13d
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
1 2 12
andyatkinson.com
Andrew Atkinson @andyatkinson.com · 21d
Just ran across this tool for fast local Postgres snapshots

bsky.app/profile/chri...
1
andyatkinson.com
Andrew Atkinson @andyatkinson.com · 25d
Thanks Bill.
andyatkinson.com
Andrew Atkinson @andyatkinson.com · 25d
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
1 14
Reposted by Andrew Atkinson
lucianghinda.com
Lucian Ghinda @lucianghinda.com · 25d
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:
2 1 5
andyatkinson.com
Andrew Atkinson @andyatkinson.com · 27d
❄️🥶 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
2
andyatkinson.com
Andrew Atkinson @andyatkinson.com · 27d
Shane Borden presenting on my favorite database topics — index design and performance optimization

@pgconfnyc.bsky.social #postgresql
Shane Borden Pg Conf NYC 2025
2
andyatkinson.com
Andrew Atkinson @andyatkinson.com · 28d
Can we expect a pgMustard blog post on these? I see an Index Searches output example on the EXPLAIN documentation page here but would be curious to learn more. www.postgresql.org/docs/current...
EXPLAIN
EXPLAIN EXPLAIN — show the execution plan of a statement Synopsis EXPLAIN [ ( option [, ...] ) ] statement …
www.postgresql.org
1 1
Reposted by Andrew Atkinson
samokhvalov.bsky.social
Nik Samokhvalov @samokhvalov.bsky.social · 28d
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
1 1 3
andyatkinson.com
Andrew Atkinson @andyatkinson.com · 28d
Slides link added to conference session page: postgresql.us/events/pgcon...
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
2
andyatkinson.com
Andrew Atkinson @andyatkinson.com · 28d
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
1 3
andyatkinson.com
Andrew Atkinson @andyatkinson.com · 28d
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
1
andyatkinson.com
Andrew Atkinson @andyatkinson.com · 29d
Hey Phil, would love to meet in person!
1 2
andyatkinson.com
Andrew Atkinson @andyatkinson.com · 29d
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
1 9
andyatkinson.com
Andrew Atkinson @andyatkinson.com · 29d
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...
1 1 12
andyatkinson.com
Andrew Atkinson @andyatkinson.com · Sep 28
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
1 3
andyatkinson.com
Andrew Atkinson @andyatkinson.com · Sep 28
🍎 Heading to the big apple for 3 days of all-you-can-eat Postgres at @pgconfnyc.bsky.social
5
andyatkinson.com
Andrew Atkinson @andyatkinson.com · Sep 25
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
4
andyatkinson.com
Andrew Atkinson @andyatkinson.com · Sep 20
Would love to check out the slides! Was the presentation recorded?
Reposted by Andrew Atkinson
pgconfnyc.bsky.social
@pgconfnyc @pgconfnyc.bsky.social · Sep 5
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
3 6
Reposted by Andrew Atkinson
pragprog.com
The Pragmatic Bookshelf ✅ @pragprog.com · Sep 18
48 hour FLASH! 45% off with code FLASHSALE
@pragdave felt like stirring things up - he just put nearly every title on sale!
2 12 10