Postgres 18: Skip Scan - Breaking Free from the Left-Most Index Limitation www.pgedge.com/blog/postgre...

Did you know High Performance PostgreSQL for Rails has a forum with 30 threads? devtalk.com/books/high-p...

Did you know the Rideshare, the Rails app for the book, continues to be updated with newer versions of Postgres?

Learn more 👉 andyatkinson.com/pgrailsbook

Thanks for taking a look!

Partying so hard got an infection? Is that amoxycillin? Or Pepto? 😂 Love the HP Inkjet too, sign of the times.

The best writing habit experienced developers can build is every time you spend an expectedly long time figuring something out, don't move on! Write about it. If it was interesting & confusing to you, others will find it interesting & valuable too.

Boost your PostgreSQL skills with Andrew Atkinson at PG DATA 2026!

Reserve your spot: forms.gle/bijKRFF8bc4n...

#PGData #PGData2026 #PostgreSQL 🐘 #SQLPerformance #ORM #DatabaseScaling #DBATraining #TechLearning #OpenSource #HandsOnTraining #DevCommunity

Definitely, I would have been surprised to see any issues. In fact, I don't recall ever seeing "same code, new DB version" issues in the last 5-10y, although I still subscribe to the practice of independently upgrading client/server components.

Gem updates via Dependabot by andyatkinson · Pull Request #248 · andyatkinson/rideshare Security related updates

Updated gem versions based on Dependabot security issues. I also ran Rideshare with Postgres 18 and app tests passed, looking good.

Originally Rideshare used Postgres 16. I'd planned to keep it updated for at least several years along with the book (published in 2024). github.com/andyatkinson...

Feature list of features missing in Aurora Postgres 18.1 Preview on AWS with feature #10 being empty

What could the mysterious missing feature #10 be in the Aurora Postgres 18.1 Preview?! 😂 docs.aws.amazon.com/AmazonRDS/la...

7.5. Sorting Rows (ORDER BY) 7.5. Sorting Rows (ORDER BY) # After a query has produced an output table (after the select list has been processed) …

TIL "order by" in Postgres can filter rows w/ an expression, e.g.

create table foo (c text);
insert into foo (c) values ('bar'), ('baz'), (null);
select * from foo order by c = 'baz' desc nulls last;
c
-----
baz
bar

(3 rows)

Weird to me, but valid!
www.postgresql.org/docs/current...

🎓 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

"0.5% selectivity for equality. 33% for ranges. Good luck." Could make a good snarky Postgres t-shirt to wear at Postgres conferences. 😂

Were the answers or commits successful (i.e. eliminating the non-determinism)? As you know this is a common problem plaguing a lot of codebases.

More SQL Antipatterns Level up your SQL skills to develop optimized and scalable SQL applications, avoiding the mistakes most developers make.

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

Book sales page for High Performance PostgreSQL for Rails on Amazon showing the book in the #1 position for the Ruby programming category

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

Scaling Postgres without Boiling the Ocean, Wed, Feb 18, 2026, 12:00 PM | Meetup Shayon Mukherjee is a Principal Engineer at Tines, the intelligent workflow platform that helps security and IT teams securely scale AI and automation. Shayon has deep expe

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

Source code locations for database queries in Rails with Marginalia and Query Logs Intro Back in 2022, we covered how to log database query generation information from a web app using pg_stat_statements for Postgres. https://andyatkinson.com/blog/2022/10/07/pgsqlphriday-2-truths-lie

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

Nice, we haven't yet become a Crunch Labs household, but there's certainly interest!

Nice shirt and you're rockin' those shades! Have a great trip.

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

What kind of robot?

Thrilled to see the book selected by the group. Let me know how I can help.

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

Awesome looking forward to the episode.

Did they use FFI?

📢 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