3 ms·
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 ro
by stu432 9y ago
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.
- dbrgn 9y agoYou're right, I think most OSM databases extract the most commonly used keys into dedicated, potentially indexed columns.