Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

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.



You're right, I think most OSM databases extract the most commonly used keys into dedicated, potentially indexed columns.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: