Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
> > Jesper Krogh wrote:
> >> I should have written:
> >> Why isn't statistics copied over or why doesnt pg_migrator run analyze by
> >> itself?
>
> > Yeah, the statistics are part of the system tables, and system tables
> > are fully handled by pg_dumpall --schema-only (except for statistics).
> > There might be changes in the system table statistics format that would
> > break if pg_migrator tried to migrate the statistics.
>
> Right, it's not really practical for pg_migrator to just copy over the
> statistics without any intelligence. We might at some time choose to
> teach it which stats could be copied safely, but that hardly seems like
> something to do in version 1.0 --- and anyway it could not be a 100%
> solution.
It seems copying over pg_statistic would require preservation of
pg_class.oid. Right now we only preserve pg_class.relfilenode.
-- Bruce Momjian <bruce@momjian.us> http://momjian.us EnterpriseDB
http://enterprisedb.com