Bruce Momjian <bruce(at)momjian(dot)us> writes:
> Copying the statistics from the old server is on the pg_upgrade TODO
> list.  I have avoided it because it will add an additional requirement
> that will make pg_upgrade more fragile in case of major version changes.

> Does anyone have a sense of how often we change the statistics data
> between major versions?

I don't think pg_statistic is inherently any more stable than any other
system catalog.  We've whacked it around significantly just last week,
which might color my perception a bit, but there are other changes on
the to-do list.  (For one example, see nearby complaints about
estimating TOAST-related costs, which we could not fix without adding
more stats data.)

			regards, tom lane

In response to

• Re: pg_upgrade and statistics at 2012-03-13 03:10:37 from Bruce Momjian

Responses

• Re: pg_upgrade and statistics at 2012-03-13 07:35:14 from Daniel Farina
• Re: pg_upgrade and statistics at 2012-03-13 14:10:25 from Bruce Momjian

pgsql-hackers by date

Next:	From: Fujii Masao	Date: 2012-03-13 04:55:32
	Subject: Re: Scaling XLog insertion (was Re: Moving more work outside WALInsertLock)
Previous:	From: Jeff Davis	Date: 2012-03-13 03:49:40
	Subject: Re: initdb and fsync