> timestamptz stores GMT; it doesn't store timezone separately. > (If it did, we'd need more than 8 bytes...)
Oh, yeah. Duh. > Because we haven't lifted a finger to optimize it. Well, that's a direct answer. Ok, will put it in the list of "TODO next time we change the on-disk format". -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers