vacuum analyze after updating from CVS?

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема vacuum analyze after updating from CVS?
Дата
Msg-id 20030712151351.GA14215@wolff.to
обсуждение исходный текст
Ответы Re: vacuum analyze after updating from CVS?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Jeffrey Melloy
Дата:
Сообщение: Re: Am I using the SERIAL type properly?
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: PL/pgSQL CASE Support