Bryce Nesbitt <bryce2@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