Bruce Momjian <[email protected]> wrote: > I just received a sobering blog comment stating that pg_upgrade > took 5 minutes on a 0.5TB database, but analyze took over an hour: Yeah, we have had similar experiences. Even if this can't be done for every release or for every data type, bringing over statistics from the old release as a starting point would really help minimize downtime on large databases. Of course, release docs should indicate which statistics *won't* be coming across, and should probably recommend a database ANALYZE or VACUUM ANALYZE be done when possible. -Kevin
-- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
