News for hackers. Stuff that matters.
Re:Speeding Up PostgreSQL with Partial Indexes by drob on Wednesday December 10, 2014 @02:31PM (#8731159)
In this example, a relational schema would work fine, and might have been easier to read. We use HSTORE at heap (until JSONB ships!) because we're processing event blobs with thousands of different fields, of which most are irrelevant for most events.

The added flexibility benefit is also nice. The ability to add a new property without migrating a schema has saved a lot of work.

There are no comments on this comment yet.