vacuum analyze after updating from CVS? - Mailing list pgsql-general

From Bruno Wolff III
Subject vacuum analyze after updating from CVS?
Date
Msg-id 20030712151351.GA14215@wolff.to
Whole thread Raw
Responses Re: vacuum analyze after updating from CVS?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I have found that at least one query I do gets a poor plan after I update
from CVS even if I don't need to do an initdb. Sometimes I have done an
initdb to clear things up; most recently a vacuum analyze did the trick.
This is a database used read only for web pages that I occasionally
reload (part of the reload process is to do a vacuum analyze).
Is this something I should expect? I would think since the stats were
stored in the database, they would continue to be valid after updating
the code (unless an initdb was forced).

pgsql-general by date:

Previous
From: Jeffrey Melloy
Date:
Subject: Re: Am I using the SERIAL type properly?
Next
From: "Jim C. Nasby"
Date:
Subject: Re: PL/pgSQL CASE Support