If there were lots of inserts, I would guess it would need to re-analyze the
tables to update its statistics on them, so the query optimizer can make good
choices.
--Wes
Philip Crotwell <crotwell%seis.sc.edu@interlock.lexmark.com> on 08/15/2001
01:08:19 PM
To: Joseph Shraibman <jks%selectacast.net@interlock.lexmark.com>
cc: pgsql-general%postgresql.org@interlock.lexmark.com (bcc: Wesley
Sheldahl/Lex/Lexmark)
Subject: Re: [GENERAL] LARGE db dump/restore for upgrade question
Hi
Just did a vacuum, took almost 4 hours. The interesting thing about this
is that there are only two small tables that have updates, everything else
has been just inserts. I would have thought that a vacuum of a database
shouldn't take very long if there aren't alot of "deleted" rows.