Five PostgreSQL Anti-Patterns
By Shey Sewani
shey.ca/2025/09/12/f...
28.02.2026 22:19
👍 5
🔁 0
💬 1
📌 0
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.
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
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-...
They've essentially killed @heroku.com. If Rails developers want something better, seriously check out @hatchbox.io. It's honestly amazing, and Chris is a super-nice guy. I use it for @pagecord.com and couldn't be happier.
www.heroku.com/blog/an-upda...
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
**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
Another win for Ruby on Rails and PostgreSQL (and a LOT of compute power)
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!
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...
Jimmy Angelakos holding up a copy of the book PostgreSQL Mistakes and How to Avoid Them
☃️ 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
Post from @boringsql.com (on Bluesky!)
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).
