Re: stats collector spins my disk up every 500ms (8.2.3) - Mailing list pgsql-general

From Ron Mayer
Subject Re: stats collector spins my disk up every 500ms (8.2.3)
Date
Msg-id 464B4EBC.7010406@cheapcomplexdevices.com
Whole thread Raw
In response to Re: stats collector spins my disk up every 500ms (8.2.3)  (Alvaro Herrera <alvherre@commandprompt.com>)
List 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 by date:

Previous
From: Richard Huxton
Date:
Subject: Re: to_number behavior change between 8.1 and 8.2
Next
From: Tom Lane
Date:
Subject: Re: stats collector spins my disk up every 500ms (8.2.3)