| From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
|---|---|
| To: | "Bruce Momjian" <bruce(at)momjian(dot)us>, "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
| Cc: | "Daniel Farina" <daniel(at)heroku(dot)com>,"Greg Stark" <stark(at)mit(dot)edu>, "pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: pg_upgrade and statistics |
| Date: | 2012-03-13 19:25:50 |
| Message-ID: | 4F5F58EE0200002500046246@gw.wicourts.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> wrote:
> Bruce Momjian <bruce(at)momjian(dot)us> wrote:
>> That is 2.5 minutes. How large is that database?
I dug around a little and found that we had turned on vacuum cost
limits on the central databases, because otherwise the web team
complained about performance during maintenance windows. On the
county database we generally don't have users working all night, so
we do maintenance during off hours, and run without cost-based
limits.
When the full run completes, I'll try analyze on that table again,
in a session with the limits off.
Maybe vacuumdb should have an option to disable the limits, and we
recommend that after pg_upgrade?
-Kevin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2012-03-13 19:27:28 | Re: Potential reference miscounts and segfaults in plpython.c |
| Previous Message | Robert Haas | 2012-03-13 19:24:11 | Re: LIST OWNED BY... |