pg_upgrade and statistics generation

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: PostgreSQL-general <pgsql-general(at)postgreSQL(dot)org>
Subject: pg_upgrade and statistics generation
Date: 2012-03-17 02:09:10
Message-ID: 20120317020910.GA17745@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have posted a blog entry about how to get pg_upgrade to generate
useful optimizer statistics more quickly once it finishes:

http://momjian.us/main/blogs/pgblog/2012.html#March_16_2012

I have also provided scripts that can be used with pg_upgrade 9.1 and
earlier, so feel free to try them out.

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

+ It's impossible for everything to be true. +

Browse pgsql-general by date

  From Date Subject
Next Message Aleksey Tsalolikhin 2012-03-17 03:21:42 Re: A 154 GB table swelled to 527 GB on the Slony slave. How to compact it?
Previous Message Adrian Klaver 2012-03-17 00:23:28 Re: Query