Re: BUG #12071: Stat collector went crasy (50MB/s constant writes)

On Wed, Nov 26, 2014 at 9:08 PM, Maxim Boguk <maxim.boguk@gmail.com> wrote:

>
> On one of my servers stat collector went crasy on idle system.
>> It constantly write around 50MB/s on idle database (no activity at all).
>>
>
OK there are results of some low-level gdb kung-fu:

problem point is:
            /*
             * Write the stats file if a new request has arrived that is not
             * satisfied by existing file.
             */
            if (last_statwrite < last_statrequest)
                pgstat_write_statsfile(false);

on some loop iteration difference between last_statrequest and
last_statwrite is around 23000-29000 (e.g. 20-30ms).

Hm may be there some clock drift between CPU cores?

Kind Regards,
Maksym





--
Maxim Boguk
Senior Postgresql DBA
http://www.postgresql-consulting.ru/ <http://www.postgresql-consulting.com/>