[SQL] pg_restore followed by immediate VACUUM ANALYZE

Mon, 30 Nov 2009 19:47:01 -0800

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?

--
Sent via pgsql-sql mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply via email to