If you use Hacker News and found this post on the Aura Frame Postgres scaling retrospective interesting, I'd appreciate an upvote! Thanks for considering it. news.ycombinator.com/item?id=4857...

Take a look at how we successfully expanded our Postgres architecture to handle millions of customers setting up hundreds of thousands of new Aura digital photo frames on Christmas Day 2025. #postgresql #databases #scaling andyatkinson.com/postgresql-r...

Take a look at how we successfully expanded our Postgres architecture to handle millions of customers setting up hundreds of thousands of new Aura digital photo frames on Christmas Day 2025. #postgresql #databases #scaling andyatkinson.com/postgresql-r...

🎙️ New #TalkingPostgres podcast Ep40 is out! Jeremy Schneider talked user groups & co-organizing the Seattle Postgres User Group. Also: Happiness Hints, Oracle to Postgres transitions, & why "it’s like I was born to be here" 🎧 talkingpostgres.com/episodes/how... 📺 www.youtube.com/watch?v=sRod...

Back in 2022, Jason and I discussed the use of NOT VALID for Check and FK constraint types in Postgres. Jason asked why they're not available for NOT NULL around 43:30? Episode #160 @jasonswett.bsky.social 3.5 years later we got 'em! www.codewithjason.com/podcast/1122... bsky.app/profile/andy...

Missed this in PG 18! #postgres We can now add "not null" constraints gradually by using "not valid" initially, which was previously limited to being used for check and foreign key constraint types. Nice. medium.com/@amaan2000mo...

Hey backend devs that use Postgres: get after it! Beta Testing PostgreSQL With Docker andyatkinson.com/postgresql-b...

Sale - The Human Side Times are wildly unpredictable right now. Supporting your human side is critical to your ability to adapt. 50% off these titles (and all previous week's titles) with code Spring2026. (AudioBook versions included) Links below

Gave a talk today at #PGData2026 on #Postgres plan management and monitoring. Some exciting changes coming to Postgres 19, and pg_stat_plans (plan statistics) now supports the new release. Full slides from the talk: resources.pganalyze.com/pganalyze_PG...

Thanks to yosifkit and Docker: up and running with Postgres 19 Beta 1. Ready to do some tests. github.com/docker-libra... #pgdata #pgdata2026

Must-reads for Postgres performance enthusiasts! Very comprehensive Radim 👏 @boringsql.com

Humanizing Keynote from Robert Haas at PG Data 2026. It’s about the people. They’re doing hard work. It’s a huge global community. Still need more contributors! Good messages. #pgdata2026 #postgres

“A query that runs in 1ms 99% of the time and 2 seconds the other 1% has a mean_exec_time around 21ms, a number that matches none of its real executions and hides the p99 that's paging your on-call.” @boringsql.com boringsql.com/posts/pg-sta...

And when I’m back in Chicago, I feel it. #pgdata #pgdata2026

Participants are going to set up PGSS on their Docker Postgres instances and we will get into some of its features and limitations! #pgdata2026 #workshops Nice expansion on both by @boringsql.com bsky.app/profile/bori...

Hope to see you at PG DATA 2026 in Chicago this Thursday! We'll go through a workshop in 3 parts covering Postgres query performance, index design, schema management, working with multiple databases, and more! Late registration? Code "ATKINSON50" takes 50% off 2026.pg-data.org

Thanks for the shout out @jessehanley.bsky.social and the heads up about it @jesper.dev! Really enjoyed listening to the trials and tribulations of the Bento (bentonow.com) database migration! cc @aaronfrancis.com bsky.app/profile/most...

Nobody Cracks Open a Programming Book Anymore unix.foo/posts/nobody...

Spring Bank Holiday, Memorial Day, Whit Monday - whatever holiday is happening around you today, take advantage of our annual SPRING SALE! Hand-picked books for right now - 50% off with code Spring2026 Details - see our most recent newsletters: pragprog.com/news/in...

@benediktdeicke.com congrats on the Rails PR 🎉 github.com/rails/rails/...

I’ve got a couple of big blog posts and a book discount code dropping soon, exclusively for newsletter subscribers! Don’t miss it. Subscribe here: pgrailsbook.com

"A roadmap to scaling Postgres" by Kaarel Moppel kmoppel.github.io/2025-04-10-p...

Rubyists! I am reviving Ruby Inside after 12 years of hiatus. I have too many Ruby things I want to blog about :-) So far I've got the archive up and running at rubyinside.com/archives/ - it's a bit of a Ruby time capsule..

I wrote a new book that has been in the works for years. It is called Root Cause, and it is for those who enjoy the art of backend engineering. amzn.to/4cKfZhe

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!

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

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

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

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

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