Bryce Nesbitt <bry...@obviously.com> writes:
>> Correct. Autovacuum might fix them eventually, but usually it's
>> worth forcing the issue once you've completed your data loading.
>> (This might involve multiple steps, which is why pg_restore
>> doesn't try to force it for you.)</pre>
> Hmm. It seems like pg_restore would already know 90% of what it needs
> to in this case.<br>
But of course pg_restore doesn't know what else you might want to do.
> Of course I'm just trying to cut down on the 4+ hour VACUUM ANALYZE.
You could try just ANALYZE without the VACUUM.
regards, tom lane
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
