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

From: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Subject: Re: stats collector spins my disk up every 500ms (8.2.3)
Date: 2007-05-16 18:34:36
Message-ID: 464B4EBC.7010406@cheapcomplexdevices.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-05-16 18:50:32 Re: stats collector spins my disk up every 500ms (8.2.3)
Previous Message Joshua D. Drake 2007-05-16 18:05:21 Re: to_number behavior change between 8.1 and 8.2