📚✨ ICYMI — Book Club @ WNB.rb! Just getting started & you’re welcome to jump in 💜 High Performance PostgreSQL for Rails 🚀 🗓 Thu • 12:30 PM ET 💬 wnb-rb.dev #WNBrb #RubyOnRails #RubyCommunity #onlinemeetup

📢 PG DATA 2026 CFP — Deadline Extended! Holiday travel slowed things down, so we’ve extended the Call for Proposals. 🗓️ New deadline: Jan 7, 2026 👉 Submit: sessionize.com/pg-data-2026 🌐 Learn more: 2026.pg-data.org #PGDATA2026 #PostgreSQL#CallForProposals #PostgresCommunity #DataConference

**Reminder** PG DATA 2026 CFP is open! We’re looking for PostgreSQL talks Submit your proposal! sessionize.com/pg-data-2026 #PGData2026 #PostgreSQL #PostgresCommunity #CallForPapers #CFP #TechSpeakers #DataConference #MidwestTech #ChicagoTec

Thrilled to see my contributions to the custom DB sharding design help power the backend of the #1 ranked Apple App Store app over the weekend!

🎄🎁 Ruby 4.0.0 Released www.ruby-lang.org/en/news/2025...

If you update or delete often rows watching bloat tables and indexes is important. This article is a great explanation and I also recommend using the gem rails-pg-extras to watch bloat ratios: github.com/pawurb/rails...

☃️ This holiday season, give the gift of Postgres! 🐘🎁 ​Grab a copy of "PostgreSQL Mistakes and How to Avoid Them" to learn from the pros and optimize your database. 🏷️ ​Save 35% with code: au35ang ​Get it here: hubs.la/Q03Nc0hv0 ​#TechBooks #Books #PostgreSQL #Postgres #OpenSource #Database

Nice post! Via Creston Jamison / Scaling Postgres podcast VACUUM Is a Lie (About Your Indexes) boringsql.com/posts/vacuum...

🐘 Oh, that's nice: Postgres 19 is going to ship read-your-writes for standbys when using asynchronous replication, via a new command WAIT FOR LSN (similar to WAIT_FOR_EXECUTED_GTID_SET in MySQL). Very cool! www.postgresql.org/docs/devel/w...

We're in the final phase of prep for Postgres infrastructure: online maintenance work, ahead of expected big load next week. We're rebuilding all indexes for tables (concurrently) or individually for jumbo ones. Recent example reduced total index size (4) for a table by ~40%! (~50GB in this case).

Optimizing the index (micro optimization) supporting a query that runs at about 3100 QPS, expected to scale up further in the peak period. Added a custom covering index. Now it's an index only scan, no heap fetches, 4 shared buffer hits in total, 16 microseconds execution time. 👌

Scrolling HN this morning and saw my UUID v4 blog post was submitted and made it to the front page. news.ycombinator.com/item?id=4627...

Prod example today of game-changing alignment of query and targeted Postgres index. Added multicolumn index on an expression. 2.5m rows. Query duration avg 1200 ms. Slowest sample @pganalyze.bsky.social 2300 ms (2.3 seconds). With index exec now just 3 shared buffer hits, 1.2 ms. 99.99% faster!

A quick reminder that the PG DATA 2026 Call for Proposals is still open! Submit here: sessionize.com/pg-data-2026 #PGData2026 #PostgreSQL #PostgresCommunity #CallForPapers #CFP #TechSpeakers #DataConference #MidwestTech #ChicagoTech

Meet the PG Data 2026 CFP Committee! They’re shaping a program that highlights innovation, real-world Postgres expertise, and diverse voices. Inspiring talks that elevate the Midwest Postgres ecosystem! #PGData2026 #PostgreSQL #PostgresCommunity #PGConf #CFPCommittee

Thanks to buyers over the Thanksgiving holiday weekend, the save50 promo, and BFCM. Great to see High Performance PostgreSQL for Rails back in the best sellers list! @pragprog.com

PG DATA CfP is open! We’re building a new Postgres conference series focused on education, community, and collaboration. 👉 Submit your talk proposal here: sessionize.com/pg-data-2026 Join us in June! #PGData2026 #PostgreSQL #PostgresCommunity #MidwestTech #ChicagoTech

Newsletter issue sent to 1020 recipients! 50% off Prag Prog books. Conferences. Winding down 2025. — Issue #21 Subscribe here and ping me if you missed it and want to see it: pgrailsbook.com

I collected all Ruby Black Friday deals I could find & posted them in one spot. Highlights include: $130 off @beautifulruby.com Phlex on Rails course $81 off @gorails.com annual subscription +20% @joemasilotti.com Hotwire native content Lots of @pragprog.com deals Enjoy! 🦃🔥💰

Pragprog Early Black Friday sale 50% off with code Save50 Includes all Beta books pragprog.com/categor...

The job of a programmer is to manage exactly two things: uncertainty and complexity. Code is sometimes an asset and sometimes a liability, but itself has no meaning outside the context of those two factors.

If you're open to books, @andyatkinson.com 's "High Performance PostgreSQL for Rails" is on sale for 50% off. bsky.app/profile/andy...

I'm really enjoying working through this book, and it's on sale! #WomenInTech #WomenWhoCode #TechSky

Pragmatic Bookshelf has 50% off nearly every book including mine: pragprog.com/titles/aapsq... Use code "save50" to get the e-book for around $20. Please share in your backend engineering team chat. Check out quotes from past readers: andyatkinson.com/pgrailsbook Thanks for your support!

Big performance problems 🤝 tiny CS tricks Our latest blog breaks down how bloom filters helped us take an API from 5s to 0.3s - even with millions of alerts in play. If you’re fighting slow queries or Postgres under pressure, this one’s worth a look: go.incident.io/r9jgcI9

It's time for the big @pragprog.com Black Friday sale! This year, 50% off with code "save50" -- I think this is the biggest sale in Prag Bookshelf history! Ends December 1st. Go to media.pragprog.com/newsletters/... for more info.

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

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

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.

🎃 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!

🎉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

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/

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

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

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.