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

From Tom Lane
Subject Re: Why is time with timezone 12 bytes?
Date
Msg-id 4217.1285197551@sss.pgh.pa.us
Whole thread Raw
In response to Re: Why is time with timezone 12 bytes?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Why is time with timezone 12 bytes?
List pgsql-hackers
Josh Berkus <josh@agliodbs.com> writes:
>> 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?

timestamptz stores GMT; it doesn't store timezone separately.
(If it did, we'd need more than 8 bytes...)

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

Because we haven't lifted a finger to optimize it.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Serializable Snapshot Isolation
Next
From: Josh Berkus
Date:
Subject: Re: Why is time with timezone 12 bytes?