Thomas Kellerer <spam_eater@xxxxxxx> writes: > droberts schrieb am 06.10.2015 um 20:53: >> Okay, so is it safe to say I should use loosely use these guidelines when >> deciding whether to model an attribute as a dimension >> (type=[inbound,outbound]) vs. bundling with a measure (total_inbound) ? >> >> If you know the number of values for a dimension are fixed (e.g. boolean), >> then creating a measure will have benefits of: >> - reduced number of rows/storage >> - better performance since less indexing/vacuuming >> >> the drawbacks are: >> -rigid structure, not very extensible over time (e.g. later realize I need >> to also track 'internal' calls). >> >> In my case, I'm now needing to add another measure 'encrypted=true/false', >> so my table is starting to look like > > Have you considered using a hstore column to store the attributes you > don't know yet? > > Which makes this extensible, flexible and fast. Is there an advantage of hstore vs. json/jsonb? -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
