Re: [pgsql-advocacy] PGUpgrade WAS: Audio interview

Ü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