Re: [HACKERS] PGUpgrade WAS: Audio interview

From: Hannu Krosing <hannu(at)skype(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, David Fetter <david(at)fetter(dot)org>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, PostgreSQL advocacy <pgsql-advocacy(at)postgresql(dot)org>
Subject: Re: [HACKERS] PGUpgrade WAS: Audio interview
Date: 2006-02-08 20:58:53
Message-ID: 1139432334.3646.2.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-hackers

Ühel kenal päeval, K, 2006-02-08 kell 15:51, kirjutas Tom Lane:
> Josh Berkus <josh(at)agliodbs(dot)com> writes:
> >> This would be a very fine project for someone to pick up (maybe one of
> >> the corporate supporters could sponsor someone to work on it?)
>
> > We looked at it for Greenplum but just couldn't justify putting it near
> > the top of the priority list. The work/payoff ratio is terrible.
>
> I agree that doing pgupgrade in full generality is probably not worth
> the investment required. However, handling the restricted case where
> no changes are needed in user tables or indexes would be considerably
> easier, and I think it would be worth doing.

How hard would it be to modify postgres so that it can handle multiple
heap page formats ?

This could come handy for pgupgrade, but my real interest would be to
have several task-specific formats supported even in non-upgrade
situations, such as a more compact heap page format for read-only
archive/analysis tables.

--------------
Hannu

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Bruce Momjian 2006-02-09 03:53:44 Re: Audio interview
Previous Message Josh Berkus 2006-02-08 20:57:07 Re: [HACKERS] PGUpgrade WAS: Audio interview

Browse pgsql-hackers by date

  From Date Subject
Next Message Gustavo Tonini 2006-02-08 23:29:46 Re: Situation with delphi7 x postgresql 8.1.2
Previous Message Josh Berkus 2006-02-08 20:57:07 Re: [HACKERS] PGUpgrade WAS: Audio interview