Re: [pgsql-advocacy] PGUpgrade WAS: Audio interview - Mailing list pgsql-hackers

From Hannu Krosing
Subject Re: [pgsql-advocacy] PGUpgrade WAS: Audio interview
Date
Msg-id 1139432334.3646.2.camel@localhost.localdomain
Whole thread Raw
In response to Re: [pgsql-advocacy] PGUpgrade WAS: Audio interview  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Ühel kenal päeval, K, 2006-02-08 kell 15:51, kirjutas Tom Lane:
> Josh Berkus <josh@agliodbs.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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [pgsql-advocacy] PGUpgrade WAS: Audio interview
Next
From: Josh Berkus
Date:
Subject: Re: [pgsql-advocacy] PGUpgrade WAS: Audio interview