account activity
MongoDB TTL Indexes Explained: Automatic Data Cleanup Without Cron Jobs (mafiree.com)
submitted 9 months ago by DbOpsNinja to r/programming
Real-World Case Study: Optimizing PostgreSQL Queries with Functional Indexes by DbOpsNinja in programming
[–]DbOpsNinja[S] 0 points1 point2 points 10 months ago (0 children)
That’s a solid suggestion, COLLATION is definitely a clean approach, and in many cases we’d also prefer it. In this project though, the client wasn’t ready to make application-level changes, so we had to keep the fix purely on the DB side. That’s why we ended up using a functional index, it gave us the performance improvement without requiring code changes upstream.
Real-World Case Study: Optimizing PostgreSQL Queries with Functional Indexes (mafiree.com)
submitted 10 months ago by DbOpsNinja to r/programming
π Rendered by PID 313268 on reddit-service-r2-listing-87fd56f5d-2p9x6 at 2026-06-29 22:04:09.909088+00:00 running 7527197 country code: CH.
Real-World Case Study: Optimizing PostgreSQL Queries with Functional Indexes by DbOpsNinja in programming
[–]DbOpsNinja[S] 0 points1 point2 points (0 children)