Re: [SQL] pg_restore followed by immediate VACUUM ANALYZE

[Bryce Nesbitt]

Tom Lane wrote: Does pg_restore not update the query planner statistics? 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.) Hmm.  It seems like pg_restore would already know 90% of what it needs to in this case. Of course I'm just trying to cut down on the 4+ hour VACUUM ANALYZE.  But thanks for the note, I'll look elsewhere for speed improvements.