Re: pg_migrator to /contrib in a later 9.0 beta

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: Jesper Krogh <jesper(at)krogh(dot)cc>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, Robert Haas <robertmhaas(at)gmail(dot)com>, Dimitri Fontaine <dfontaine(at)hi-media(dot)com>, Andrew Dunstan <andrew(at)dunslane(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Magnus Hagander <magnus(at)hagander(dot)net>, Peter Eisentraut <peter_e(at)gmx(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pg_migrator to /contrib in a later 9.0 beta
Date: 2010-05-06 13:06:26
Message-ID: 201005061306.o46D6Qh29357@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruce Momjian wrote:
> > The database (of a reasonable size) is useless until statistics is
> > available.
> >
> > I guess it is because pg_dump/restore doesn't do it either.
>
> 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 now
> pg_migrator is immune from any system table changes, and I would like to
> keep it that way.
>
> And if pg_migrator ran analyze itself, it would greatly increase its
> great migration times!

Forgot the :-).

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2010-05-06 13:38:42 Re: LD_LIBRARY_PATH versus rpath
Previous Message Bruce Momjian 2010-05-06 13:04:13 Re: pg_migrator to /contrib in a later 9.0 beta