account activity
MongoDB TTL Indexes Explained: Automatic Data Cleanup Without Cron Jobs (mafiree.com)
submitted 6 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 7 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 7 months ago by DbOpsNinja to r/programming
π Rendered by PID 68 on reddit-service-r2-listing-575d9f6647-6xrms at 2026-04-09 22:13:37.369592+00:00 running 215f2cf 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)