Thread: pg_restore followed by immediate VACUUM ANALYZE
I looking at a script that does a pg_restore followed by an immediate VACUUM ANALYZE (postgres 8.3). I'm told that without the VACUUM ANALYZE the database will run slow. Does this ring true? Does pg_restore not update the query planner statistics?
Bryce Nesbitt <bryce2@obviously.com> writes: > I looking at a script that does a pg_restore followed by an immediate > VACUUM ANALYZE (postgres 8.3). That's standard. > 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.) regards, tom lane
Tom Lane wrote:<br /><blockquote cite="mid:19189.1259639712@sss.pgh.pa.us" type="cite"><blockquote type="cite"><pre wrap="">Doespg_restore not update the query planner statistics? </pre></blockquote><pre wrap=""> 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></blockquote> Hmm. It seems like pg_restore would already know 90% of what it needsto in this case.<br /> Of course I'm just trying to cut down on the 4+ hour VACUUM ANALYZE. But thanks for<br /> thenote, I'll look elsewhere for speed improvements.<br />
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