Andrew Atkinson
@andyatkinson.com
Author of High Performance PostgreSQL for Rails, Staff Engineer, Consultant, Speaker
andyatkinson.com/pgrailsbook
andyatkinson.com/pgrailsbook
Pinned
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!
Wale is great! Check this out. If you're looking for a Rails consultant get in touch with @wale-olaleye.bsky.social.
bsky.app/profile/indi...
bsky.app/profile/indi...
Episode 67 has a bit of a temperature! 🌡️ In this one, we sit down with @wale-olaleye.bsky.social, founder of Rails Fever, to chat about building a software consulting business, marketing and sales outreach, refining your messaging, and the value of being local and in-person.
www.indierails.com/67
www.indierails.com/67
IndieRails | Wale Olaleye - Helping Founders with Tech
Wale Olaleye of Rails Fever joins IndieRails to talk about what it really takes to build a consulting business. The conversation spans everything from refining your message and brand, “I help found...
www.indierails.com
November 13, 2025 at 1:44 PM
Wale is great! Check this out. If you're looking for a Rails consultant get in touch with @wale-olaleye.bsky.social.
bsky.app/profile/indi...
bsky.app/profile/indi...
Reposted by Andrew Atkinson
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...
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
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...
www.pgmustard.com/blog/what-do...
Reposted by Andrew Atkinson
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.
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
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.
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.
🎃 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!
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
🎃 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!
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!
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
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
🎉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
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
Reposted by Andrew Atkinson
I did Postgres dirty with this one
October 20, 2025 at 12:50 AM
I did Postgres dirty with this one
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/
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
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/
Thank you to @clairegiordano.bsky.social for the encouragement and help making that happen.
Check it out 👉
www.postgresql.org/docs/books/
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
#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
October 3, 2025 at 9:21 PM
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
#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:
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
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:
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
October 1, 2025 at 3:16 PM
❄️🥶 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
@pgconfnyc.bsky.social #postgresql
October 1, 2025 at 1:41 PM
Shane Borden presenting on my favorite database topics — index design and performance optimization
@pgconfnyc.bsky.social #postgresql
@pgconfnyc.bsky.social #postgresql
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:
I'll go first, my top-3 list:
PostgreSQL: Release Notes
www.postgresql.org
September 30, 2025 at 7:27 PM
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:
I'll go first, my top-3 list:
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
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
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
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
September 30, 2025 at 1:54 PM
Great to see Robert Treat honored as Volunteer of the Year at PG Conf NYC 2025. Well deserved! @pgconfnyc.bsky.social
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.
🏙️ Hard to beat the Central Park NYC skyline views.
September 29, 2025 at 7:02 PM
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.
🏙️ 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...
Slides: speakerdeck.com/andyatkinson...
SQL demos/GitHub Repo: github.com/andyatkinson...
September 29, 2025 at 6:39 PM
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...
Slides: speakerdeck.com/andyatkinson...
SQL demos/GitHub Repo: github.com/andyatkinson...
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/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
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/episodes/gad...
🍎 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
🍎 Heading to the big apple for 3 days of all-you-can-eat Postgres at @pgconfnyc.bsky.social
Reposted by Andrew Atkinson
Learn all about “Multitenancy Patterns in Community PostgreSQL” with Andrew Atkinson at PGConf NYC 2025!
postgresql.us/events/pgcon...
@PostgreSQL #postgres #conference
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
Learn all about “Multitenancy Patterns in Community PostgreSQL” with Andrew Atkinson at PGConf NYC 2025!
postgresql.us/events/pgcon...
@PostgreSQL #postgres #conference
postgresql.us/events/pgcon...
@PostgreSQL #postgres #conference
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!
@pragdave felt like stirring things up - he just put nearly every title on sale!
September 18, 2025 at 12:12 PM
48 hour FLASH! 45% off with code FLASHSALE
@pragdave felt like stirring things up - he just put nearly every title on sale!
@pragdave felt like stirring things up - he just put nearly every title on sale!
Reposted by Andrew Atkinson
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...
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
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...
If you're around, come see us to talk about your #RubyOnRails app's performances.
www.rorvswild.com/blog/2025/pe...
Reposted by Andrew Atkinson
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.
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
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.
pragprog.com
Programming Ruby 3.3 definitely included.
Reposted by Andrew Atkinson
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.
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
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.
My book SQL Antipatterns, Volume 1 is among those on sale. Both print and digital edition.
Use promo code "flashsale" for the 40% discount.
> 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-...
August 30, 2025 @pragprog.com #pgrailsbook #postgresql
www.amazon.com/gp/customer-...
September 11, 2025 at 10:25 PM
> 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-...
August 30, 2025 @pragprog.com #pgrailsbook #postgresql
www.amazon.com/gp/customer-...