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

From Robert Haas
Subject Re: Why is time with timezone 12 bytes?
Date
Msg-id AANLkTi=kmhmcLj-bmsAUS7=BVbk9Qb1xG1VCWoPupdbN@mail.gmail.com
Whole thread Raw
In response to Re: Why is time with timezone 12 bytes?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Why is time with timezone 12 bytes?
pg_upgrade pain; was Re: Why is time with timezone 12 bytes?
Re: Why is time with timezone 12 bytes?
List pgsql-hackers
On Thu, Sep 23, 2010 at 1:46 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Robert Haas <robertmhaas@gmail.com> writes:
>> On Thu, Sep 23, 2010 at 1:29 PM, Bruce Momjian <bruce@momjian.us> wrote:
>>> Josh Berkus wrote:
>>>> It would be a good project to add to the list of "easy TODOs to get
>>>> started with."
>
>>> Except for the pg_upgrade issue.
>
>> Which is a big "except".
>
> Yeah.  That constraint is what leads me to think that the return on
> effort is just not worth it.  Maybe we should file this in the category
> of "things to look at next time we break on-disk compatibility".

I'm worried about how we're going to manage that.  First, as
pg_upgrade becomes more mature, the penalty for breaking on-disk
compatibility gets a LOT bigger.  I'd like to think that "the next
time we break on-disk compatibility" means approximately "never", or
at least "not for a very long time".  Second, if we do decide to break
it, how and when will we make that decision?  Are we just going to
decide to break it when we run into a feature that we really want that
can't be had any other way?  If we want to make breaking on-disk
compatibility something that only happens every 5 years or so, we had
better give people - I don't know, a year's notice - so that we can
really knock out everything people have any interest in fixing in one
release.

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


pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: wip: functions median and percentile
Next
From: Robert Haas
Date:
Subject: Re: security label support, revised