Re: Performance after restart/reboot pre-Analyze

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Performance after restart/reboot pre-Analyze
Дата
Msg-id CAKFQuwZEcn9512o=Zgh_SsWnO0VcYU7-t4SZypJTY=AqtVwk9w@mail.gmail.com
обсуждение исходный текст
Ответ на [MASSMAIL]Performance after restart/reboot pre-Analyze  (David Fogarty <dfogarty@icsusa.com>)
Список pgsql-novice
On Thu, Mar 28, 2024 at 8:44 AM David Fogarty <dfogarty@icsusa.com> wrote:

It seems like whenever I restart my database server performance is quite bad until an Analyze has been performed. I expect this is due to the query planner needing new stats,

Nope, statistics are WAL logged.
 
but that leads me to three questions:

1. Is there a way to have Analyze stats/query planner "plans" persist through a restart?

Plans are session-scoped.

What you are observing is the shared buffers being empty.  There is a contrib library, pg_prewarm, designed to help alleviate this problem.


David J.

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

Предыдущее
От: David Fogarty
Дата:
Сообщение: [MASSMAIL]Performance after restart/reboot pre-Analyze
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Performance after restart/reboot pre-Analyze