pgstat: delayed write of stats file

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема pgstat: delayed write of stats file
Дата
Msg-id 6BCB9D8A16AC4241919521715F4D8BCEA3524E@algol.sollentuna.se
обсуждение исходный текст
Ответы Re: pgstat: delayed write of stats file  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: pgstat: delayed write of stats file  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: pgstat: delayed write of stats file  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-patches
Per some earlier discussion, here is an attempt at implementing a
"delayed write" of the pgstats file, to decrease the write activity on
that file.

It changes so the file is only written once every 5 minutes (changeable
of course, I just picked something) instead of once every half second.
It's still written when the stats collector shuts down, just as before.
And it is now also written on backend request. A backend requests a
rewrite by simply sending a special stats message. It operates on the
assumption that the backends aren't actually going to read the
statistics file very often, compared to how frequent it's written today.


//Magnus

Вложения

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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: WIP: splitting BLCKSZ
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: pgstat: delayed write of stats file