❄️🥶 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

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:

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

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...

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...

🍎 Heading to the big apple for 3 days of all-you-can-eat Postgres at @pgconfnyc.bsky.social

What are SLRUs and MultiXacts in Postgres? What can go wrong? andyatkinson.com/postgresql-s...

Learn all about “Multitenancy Patterns in Community PostgreSQL” with Andrew Atkinson at PGConf NYC 2025! postgresql.us/events/pgcon... @PostgreSQL #postgres #conference

48 hour FLASH! 45% off with code FLASHSALE @pragdave felt like stirring things up - he just put nearly every title on sale!

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...

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 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.

> 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-...

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...

Did you notice that we have all the important dates listed? 2026.pg-data.org Our CfP will be open on October 20, and we commit to sending acceptance notifications by February 1. And did you notice that the Early Bird tickets are already available?! Chicago is better in the summer!

🔥 New Changelog interview! changelog.fm/657

Excited to be a member of the awesome CFP committee assembled for this conference. Please reach out if I can help you develop your proposal or if you have questions.

Just released - 2nd printing of High Performance PostgreSQL for Rails! The amazing Andrew Atkinson has updated this title - and it's included in the RailsWorld2025 sale! Take 40% off with code RailsWorld2025 - only at Pragprog (pragprog.com/titles/...

Huge shoutout to our team for helping me turn the RailsConf talk and lots of thoughts into this post about the cycles that technologies and innovation go through, why Rails emerged after a big drop in visibility, glimpses of what the future holds–and our roles in it!

The #RailsConf 2025 recap is HERE! (I'm not crying, you're crying. 🥺😭) While this may have been the final RailsConf, we can't wait to see everyone again at RubyConf. 💙

It feels good to understand what goes on behind the scenes in the database. It boils down to the fundamentals that I compiled in this course. I get messages from people who passed interviews, got hired, promoted and improved their apps. Grab your copy databases.win

Two years ago today, @drbragg.dev of @codingcoders.bsky.social posted an interview with me. Really enjoyed our chat and connecting with Drew at conferences on occasion since then. Check it out! podcast.drbragg.dev/episodes/epi...

The upcoming Postgres 18 is set to include some nice improvements to EXPLAIN: * BUFFERS on by default with ANALYZE 🎉 * Fractional "actual rows" (huge in some cases) * Quite a few new fields (including the very cool Index Searches) We've now added support for all of them. 💛

Learn all about “Multitenancy Patterns in Community PostgreSQL” with Andrew Atkinson at PGConf NYC 2025! postgresql.us/events/pgcon... @PostgreSQL #postgres #conference

Yup. ActiveRecord validations will not help you. Every single project I've worked on that didn't have foreign key constraints had orphaned records, even with Rails' validations correctly modeling the relationships.

Added the "10 Costly Database Performance Mistakes" YouTube embed from @rubycentral.org to my landing page here 👉 Still hoping to write up RailsConf 2025 reflections, but I've been very busy since the conference. Stay tuned! andyatkinson.com/10-mistakes

Blog post soon. Preview: Worked with a test suite w/ an unknown amount of flaky test failures. To understand the scope, ran same build, "quarantined" all failures. Took 50x runs before it "ran green." Inspired by "Eradicating Non-Determinism in Tests" (2011) martinfowler.com/articles/non...

my love letter to relational databases postgres, pls be mine: check yes or no x86.wtf/why-i-love-r...

📚 In the last few weeks, 3 new Goodreads ratings for High Performance PostgreSQL for Rails. Thank you! ⭐️ 23 ratings / 6 reviews — 4.78 www.goodreads.com/en/book/show...

Big news -- @jremsikjr.bsky.social of Flagrant has officially announced XO Ruby! 💫 Taking place across six U.S. cities between September and October, XO Ruby is a series of traveling events that, for locals, won't require a plane ticket and hotel stay...

🎉 For the second year in a row, we're hosting a challenge to test PostgreSQL 18 pre-releases 🧪 Help improve Postgres by testing the beta versions. In return, you could win a free ticket to PgDay Lowlands and earn your spot on the legendary Wall of Testers Details: 2025.pgday.nl/testing-pg

I'm going to be speaking at @xoruby.com Atlanta on September 13th. XO Ruby is a brand-new (traveling) single-day Ruby conference. If you're a Rubyist in the southeastern US, you should check it out! (And if not, take a look at other 5 stops this fall.)

New small blog post "Measuring SELECT ... FOR UPDATE Latency in #PostgreSQL" > Are queries slow because they’re waiting to acquire locks, or because they’re taking a long time to find the actual rows? :) benoittgt.github.io/blog/postgre...

Honored to be presenting at PGConf NYC in a couple of months! Hope to see you there. #postgresql bsky.app/profile/pgco...

Come join our free gem walkthrough next Tuesday 👋 You'll see a new take on fixtures + factories + seeds, and gain a new perspective on your dev and test data. It's live over Zoom, so you can ask questions too. lu.ma/e9927y5m

RailsConf talks are live. Would love your feedback! Presentation page with more info and all the links: andyatkinson.com/10-mistakes RailsConf 2025 10 Costly Database Performance Mistakes (and How to Fix Them) by Andrew Atkinson www.youtube.com/watch?v=MJ8R...

I use ORMs when writing programs, raw SQL when doing analysis, debugging, or database admin. The problem with raw SQL queries in code is that a) they don't compose well, and b) I still need to convert rows into objects somehow.

I'm collecting links to public Postgres-related Postmortem write-ups! (aka RCAs, Incident Reviews) github.com/andyatkinson... Coincidentally, one of the write-ups is from the Metronome team, and they're being interviewed about it on the latest episode of postgres.fm! bsky.app/profile/samo...

How to influence query planning in Postgresql (note: it’s about Aurora’s Query Plan Management (QPM) not community Postgres) chriskiehl.com/article/quer...

Blogged! A recap of my experience giving my first conference talk at #RailsConf2025 in Philly! Thank you to @rubycentral.org and everyone I met last week! I couldn't have asked for a better first-time speaker experience than this! ❤️💎✨ www.chrisfung.dev/posts/speaki...

After years of using tmux and losing my session, windows, panes, etc. on restart, I'd finally got around to trying out github.com/tmux-plugins.... Works great! Very straightforward to use. prefix + Ctrl-s - save my config. Restart. Create new tmux session. prefix + Ctrl-r - restore

The team that writes the code needs to deploy it and be on-call for it. Full stop. Any other setup is going to lead to resentment, unfixed or slow to fix issues. But what about SRE? You aren't Google, so don't copy what they do. They had a specific problem to solve which you don't have.

Mini #RailsConf thread 🧵 on "10 Costly Database Performance Mistakes (And How to Fix Them)" I was really honored and grateful to present to a packed & overflowing room! What a way to go out!

A highlight of #RailsConf was meeting (and thanking) Douglass Huang in person, a highly active submitter of very detailed book errata! I'm happy to say that fixes for Douglass' issues are submitted to @pragprog.com and will hopefully land in a future release. forum.devtalk.com/tag/book-hig...

My brain is full of open source, blogging and growth ideas, thanks to #rubyfriends! Thanks @rubycentral.org @rosa.codes @codynorman.com @jeremysmith.co @manu-j.com @andyatkinson.com @adrianthedev.com @inazarova.bsky.social @jesper.dev @kaspth.com and so many others! Hope to see everyone again soon!

Anchors aweigh! Just pushed: anchor_migrations (0.1.0) New gem announced at #RailsConf. A bit niche, but might be useful for orgs that want to ship DDL changes faster, but have infrequent software releases. Safe, idempotent, stay in sync w/ Active Record Migrations. rubygems.org/gems/anchor_...

Mini #RailsConf thread 🧵 on "10 Costly Database Performance Mistakes (And How to Fix Them)" I was really honored and grateful to present to a packed & overflowing room! What a way to go out!