Re: [PATCHES] pgstat: delayed write of stats file

2006-04-05 Thread Magnus Hagander
> > 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.

Re: [PATCHES] pgstat: delayed write of stats file

2006-04-05 Thread Tom Lane
"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

Re: [PATCHES] pgstat: delayed write of stats file

2006-04-05 Thread Magnus Hagander
> > 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

Re: [PATCHES] pgstat: delayed write of stats file

2006-04-05 Thread Alvaro Herrera
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

[PATCHES] pgstat: delayed write of stats file

2006-04-05 Thread Magnus Hagander
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

Re: [PATCHES] WIP: splitting BLCKSZ

2006-04-05 Thread Simon Riggs
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

Re: [PATCHES] WIP: splitting BLCKSZ

2006-04-05 Thread Simon Riggs
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) ...