Re: Why is time with timezone 12 bytes?

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Why is time with timezone 12 bytes?
Date: 2010-09-23 01:06:51
Message-ID: AANLkTin6SJUnb198O=qe972Z+Wrp9NM89B0z7ghRTgmc@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Sep 22, 2010 at 9:00 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Robert Haas <robertmhaas(at)gmail(dot)com> writes:
>> Technically, there's no reason why we can't do this for 9.1.  What we
>> can do is change the name of the "time with timezone" type to
>> something like "oldtimetz", keeping the current OID.  And then we can
>> add a new type called "time with timezone".  [ with large amounts of
>> consequent work ]
>
> I think you missed the point of my response, which is that there are
> easily 10^6 more-pressing things to work on than the size of timetz.
> Do you know of any actual use cases for it?

Well, I wasn't responding to you - I was responding to Josh.
Regardless of the merits of redesigning this particular data type, I
think it's important for us to cultivate a mindset of figuring out how
we can make gradual improvements to the on-disk format without
earth-shattering consequences for pg_upgrade. Mind you, I don't
currently have the time to hack on this for, uh, more or less the
reason you state. But if my boss told me he double my pay if I got it
done, I wouldn't tell him it's technically impossible.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2010-09-23 01:08:01 Re: Easy way to verify gitignore files?
Previous Message Tom Lane 2010-09-23 01:00:19 Re: Why is time with timezone 12 bytes?