Postgres Pro
Downloads
Home   >   mailing lists

pg_restore followed by immediate VACUUM ANALYZE - Mailing list pgsql-sql

From Bryce Nesbitt
Subject pg_restore followed by immediate VACUUM ANALYZE
Date
Msg-id 4B1491A3.6080602@obviously.com
Whole thread Raw
Responses Re: pg_restore followed by immediate VACUUM ANALYZE  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
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?

pgsql-sql by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: How to start the "auto_explain" module
Next
From: Tom Lane
Date:
Subject: Re: pg_restore followed by immediate VACUUM ANALYZE