On Tue, 2009-12-15 at 18:06 -0600, decibel wrote: > Now that varlena's don't have an enormous fixed overhead, perhaps it's > worth looking at using them. Obviously some operations would be > slower, but for your stated examples of auditing and history, I > suspect that you're not going to notice the overhead that much.
For most varvarlena types, you only get stuck with the full alignment burden if you get unlucky. In this case, we're moving from 16 bytes to 17, which really means 24 bytes with alignment. Try creating two tables: create table foo(i int8, t1 timestamp, t2 timestamp); create table bar(i int8, c "char", t1 timestamp, t2 timestamp); That extra byte there costs you 8 bytes, every time (on my machine, anyway). We're at serious risk of people saying "Ah, this temporal thing is bloated. I'll try to get by with a single timestamp and save 16 bytes per record". Or maybe "Why waste the bytes? I'll just store two timestamps". Regards, Jeff Davis -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers