pg_restore followed by immediate VACUUM ANALYZE

From: Bryce Nesbitt <bryce2(at)obviously(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: pg_restore followed by immediate VACUUM ANALYZE
Date: 2009-12-01 03:46:43
Message-ID: 4B1491A3.6080602@obviously.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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?

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2009-12-01 03:55:12 Re: pg_restore followed by immediate VACUUM ANALYZE
Previous Message Jaime Casanova 2009-11-30 22:24:47 Re: How to start the "auto_explain" module