smitty1110
Joined 10 years ago
Karma
676
Submissions
206
Member since
Apr 25
Joined 10 years ago
Lots of things in PGSQL benefit from thinking about how your use case is manipulating the underlying B-tree, if you work in performance sensitive stuff the devil is really in the details. And having to rebuild indexes that have decayed over time is painful.
Something is going to give, and I suspect that the optimistic open filling is going to get canceled.
It was a large cognitive load, I don't miss those days.
IANAL, opinions and views expressed here are my own.