🎓 Trainings are included with your PG DATA 2026 ticket — at no extra cost! Explore the available sessions: 2026.pg-data.org/sessions/ Reserve your spot: forms.gle/bijKRFF8bc4n... #PGData #PGData2026 #PostgreSQL 🐘

Five PostgreSQL Anti-Patterns By Shey Sewani shey.ca/2025/09/12/f...

You can play the original SkiFree game from the Windows 3.1 days in your browser - this is not a drill! retrotick.com

I'm excited to have met @billkarwin.geek.org virtually and to get started reading "More SQL Antipatterns," a modernized version of the 2010 classic “SQL Antipatterns.” The new book uses Postgres, Python, and is in Beta now. Take a look! pragprog.com/titles/bksap...

High Performance PostgreSQL for Rails picked up a new 5-star review and is back to #1 in the Ruby Programming category on Amazon. Thank you readers! 💙 @pragprog.com a.co/d/0e61DsQX

Tomorrow's Postgres Meetup for All is about scaling Postgres ... but without boiling the ocean. Should be a great discussion. Join us! www.meetup.com/postgres-mee...

Re: commenting on indexes, I like the ideas to track creation time and last reindex timestamps as comments. Could use comma separated key:value for a format. Using a shared script on a team, it could perform the operation then annotate it. @samokhvalov.bsky.social @michristofides.com

Re: query comments in Rails @samokhvalov.bsky.social @michristofides.com besides Marginalia, there’s also Query Logs built into Rails, which is also based on the SQLCommenter standard. Also, I always recommend enabling source code line level info. andyatkinson.com/source-code-...

Can confirm 🥶

New in Beta - All new with advanced queries like relational division, efficient pagination, and pivoting. Explore optimization tradeoffs, including denormalization, JSON, and choosing SQL versus NoSQL. Scaling out with sharded databases. pragprog.com/titles/...

📚✨ 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