[goldmab]

Fair enough, but you can also have a schemaless store by using JSON fields in PostgreSQL or MySQL.

[angelbob]

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.

[joevandyk]

You can index hstore fields in PostgreSQL.

[deoxxa]

That's not an unfair comparison at all - indexing the data in a JSON blob is entirely possible and practical.

[einhverfr]

What you want to index regarding a large text file and what indexes you can create and use may be different.