> > 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 Hagander" <[EMAIL PROTECTED]> 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
> > 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
Magnus Hagander wrote:
> 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
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 st
On Tue, 2006-04-04 at 15:26 -0400, Tom Lane wrote:
> Simon Riggs <[EMAIL PROTECTED]> writes:
> > An additional patch enclosed that adds xlog blcksz onto the xlog long
> > header at the start of each xlog file, so we can cross-check between
> > file and system, as we do with xlog seg size.
>
> That
On Tue, 2006-04-04 at 18:41 -0400, Tom Lane wrote:
> Simon Riggs <[EMAIL PROTECTED]> writes:
> > On Tue, 2006-04-04 at 11:13 -0400, Tom Lane wrote:
> >> Hm. The entire point of having a BLCKSZ-sized control file is to have
> >> it *not* change in size across format revisions (see the comments) ...