Andrew Atkinson
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
#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!
Reposted by Andrew Atkinson
🎉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
Reposted by Andrew Atkinson
I did Postgres dirty with this one
Appreciate it! If you feel motivated to do so, positive reviews & ratings on your platform of choice really help. Thanks for considering it.
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
Just ran across this tool for fast local Postgres snapshots

bsky.app/profile/chri...
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
Reposted by Andrew Atkinson
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:
❄️🥶 Melanie Plageman presenting on advancements in vacuum freeze in Postgres 18 @pgconfnyc.bsky.social #postgresql
Shane Borden presenting on my favorite database topics — index design and performance optimization

@pgconfnyc.bsky.social #postgresql
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
Reposted by Andrew Atkinson
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
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
Great to see Robert Treat honored as Volunteer of the Year at PG Conf NYC 2025. Well deserved! @pgconfnyc.bsky.social
Hey Phil, would love to meet in person!
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.
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...
🍎 Heading to the big apple for 3 days of all-you-can-eat Postgres at @pgconfnyc.bsky.social
Would love to check out the slides! Was the presentation recorded?
Reposted by Andrew Atkinson
48 hour FLASH! 45% off with code FLASHSALE
@pragdave felt like stirring things up - he just put nearly every title on sale!