News for hackers. Stuff that matters.
Re:We saved $50k/year with a Go microservice coded in a hack... by stu432 on Wednesday April 11, 2018 @05:05AM (#16809288)
I mean, not really, theres no magic in Postgres' implementation of the pattern. They even spell it out for you:

"can be useful in various scenarios, such as rows with many attributes that are rarely examined"

They are querying these quite heavily, they aren't just random attributes they need to retrieve.

Re:We saved $50k/year with a Go microservice coded in a hack... by dbrgn on Wednesday April 11, 2018 @06:10PM (#16816202)
You're right, I think most OSM databases extract the most commonly used keys into dedicated, potentially indexed columns.