Re: stats collector spins my disk up every 500ms (8.2.3)

Поиск
Список
Период
Сортировка
От Ron Mayer
Тема Re: stats collector spins my disk up every 500ms (8.2.3)
Дата
Msg-id 464B4EBC.7010406@cheapcomplexdevices.com
обсуждение исходный текст
Ответ на Re: stats collector spins my disk up every 500ms (8.2.3)  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-general
Alvaro Herrera wrote:
> Daniel Barlow wrote:
>> 1 battery life from my laptop, I noticed that one source of periodic disk
>> writes was the postgres stats collector process, which appears to
>> write to pgstat.tmp every 500ms)
>
> Hmm, I don't think we have an optimization to avoid writing it when the
> data hasn't changed.  This seems easy to do ... see attached patch
> (untested)

Any chance something like this can make it to the patch queues.
I had also earlier noticed disks not spinning down when running
demos on my laptop.

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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: to_number behavior change between 8.1 and 8.2
Следующее
От: Tom Lane
Дата:
Сообщение: Re: stats collector spins my disk up every 500ms (8.2.3)