Hacker News new | ask | show | jobs
by angelbob 5334 days ago
Not indexably. But you can do a hideous many-tables-per-real-table thing where each field gets a tall thin table in PostGRES or MySQL, do a lot of joins to get your data, and index the fields in that.

It's not as awful as it sounds, performance-wise. It is as awful as it sounds in terms of maintainability, of course.

1 comments

You can index hstore fields in PostgreSQL.