Analyze and vacuum, they are sort of mandatory....

Поиск
Список
Период
Сортировка
От Mark Woodward
Тема Analyze and vacuum, they are sort of mandatory....
Дата
Msg-id 16507.24.91.171.78.1139682819.squirrel@mail.mohawksoft.com
обсуждение исходный текст
Ответы Re: Analyze and vacuum, they are sort of mandatory....  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-hackers
I was think about how forgetting to run analyze while developing a table
loader program caused PostgreSQL to run away and use up all the memory.

Is there some way that postges or psql can know that it substantially
altered the database and run analyze?

I know this is a kind of stupid question, but postgresql does not behave
well when the system changes in a major way without at least an analyze.
There must be something that can be done to protect the casual user (or
busy sometimes absent minded developer) from these dangerous edge
conditions?




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Florian Weimer
Дата:
Сообщение: Re: Upcoming re-releases
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Analyze and vacuum, they are sort of mandatory....