"Kevin Grittner" <kevin.gritt...@wicourts.gov> wrote: > Bruce Momjian <br...@momjian.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
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
