Re: Are there tuning parameters that don't take effect immediately?

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Are there tuning parameters that don't take effect immediately?
Дата
Msg-id CAKFQuwZMX10xq2HVhim1rgrrFLwdc+NN1ko4GTXY5VkCpZsLMA@mail.gmail.com
обсуждение исходный текст
Ответ на Are there tuning parameters that don't take effect immediately?  (Michael Nolan <htfoot@gmail.com>)
Ответы Re: Are there tuning parameters that don't take effect immediately?  (Michael Nolan <htfoot@gmail.com>)
Список pgsql-performance
Дерево обсуждения
On Fri, Jun 12, 2015 at 4:37 PM, Michael Nolan <htfoot@gmail.com> wrote:
The only thing I can come up that's happened since last night was that we ran the nightly vacuum analyze on that database, but I did not change the statistics target.  


​The answer to your question is no, parameters changes are worse would take effect after a reboot - though most are used on the very next query that runs.

The vacuum would indeed likely account for the gains - there being significantly fewer ​dead/invisible rows to have to scan over and discard while retrieving the live rows that fulfill your query.

David J.

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

Предыдущее
От: Michael Nolan
Дата:
Сообщение: Are there tuning parameters that don't take effect immediately?
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Are there tuning parameters that don't take effect immediately?