Re: Why is time with timezone 12 bytes?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: Why is time with timezone 12 bytes?
Date: 2010-09-22 23:20:49
Message-ID: 4C9A8F51.6040907@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Marko Tiikkaja 2010-09-22 23:26:45 Re: WIP: Triggers on VIEWs
Previous Message Tom Lane 2010-09-22 23:19:11 Re: Why is time with timezone 12 bytes?