3 ms·
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 ev
by drob 12y ago
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.