Re: Speeding up pg_upgrade - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Speeding up pg_upgrade
Date
Msg-id 8486.1512664928@sss.pgh.pa.us
Whole thread Raw
In response to Re: Speeding up pg_upgrade  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: Speeding up pg_upgrade
Re: Speeding up pg_upgrade
List pgsql-hackers
Alvaro Herrera <alvherre@alvh.no-ip.org> writes:
> It seems pretty clear to me that we should somehow transfer stats from
> the old server to the new one.  Shouldn't it just be a matter of
> serializing the MCV/histogram/ndistinct values, then have capabilities
> to load on the new server?

The reason pg_upgrade hasn't done that in the past is not wishing to
assume that the new version does stats identically to the old version.
Since we do in fact add stats or change stuff around from time to time,
that's not a negligible consideration.

            regards, tom lane


pgsql-hackers by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: Speeding up pg_upgrade
Next
From: Robert Haas
Date:
Subject: Re: Signals in a BGW