Re: pgstat: delayed write of stats file - Mailing list pgsql-patches

From Tom Lane
Subject Re: pgstat: delayed write of stats file
Date
Msg-id 320.1144248930@sss.pgh.pa.us
Whole thread Raw
In response to pgstat: delayed write of stats file  ("Magnus Hagander" <mha@sollentuna.net>)
List pgsql-patches
"Magnus Hagander" <mha@sollentuna.net> writes:
> 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.

While that would be better under low load, seems like it would be
markedly worse under high load (ie, if someone actually is watching the
stats constantly).

            regards, tom lane

pgsql-patches by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: pgstat: delayed write of stats file
Next
From: "Magnus Hagander"
Date:
Subject: Re: pgstat: delayed write of stats file