Re: Why is time with timezone 12 bytes?

> 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