Re: Why is time with timezone 12 bytes? - Mailing list pgsql-hackers

> It's the same, because the limits are calendar based (particularly,
> the Julian-date functions) and not dependent on the representation.

Hmmm?  Just storing dates for the range described (until the year
294,000) takes 8bytes by my calculations.  And that's without the 3
bytes for the time zone.  Is my math off?

And, of course, this doesn't answer at all why time with time zone is so
huge.

--                                  -- Josh Berkus                                    PostgreSQL Experts Inc.
                        http://www.pgexperts.com