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

2007-02-08 Thread Bruce Momjian
I assume we no longer need this stats patch from May of 2006. --- Bruce Momjian wrote: Tom Lane wrote: Bruce Momjian pgman@candle.pha.pa.us writes: Have we seen any such failures since the first day they appeared?

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

2006-05-29 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian pgman@candle.pha.pa.us writes: Have we seen any such failures since the first day they appeared? agouti blew up about the same time you typed that, so yes it's still a problem. http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=agoutidt=2006-05-08%2003:15:01

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

2006-05-07 Thread Bruce Momjian
Magnus Hagander wrote: This was not ready to be applied, was it? I don't recall any specific objections that weren't answered. How about the fact that it's already caused one buildfarm failure? http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=waspdt=2006 -04-30%2003:05:01

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

2006-05-07 Thread Tom Lane
Bruce Momjian pgman@candle.pha.pa.us writes: Was this fixed somehow? I don't see any more buildfarm failures, but I didn't see a fix go in either. It is very possible the pgport fix I did yesterday is related, but I have not applied it yet. It's an intermittent failure; the fact you don't

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

2006-05-07 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian pgman@candle.pha.pa.us writes: Was this fixed somehow? I don't see any more buildfarm failures, but I didn't see a fix go in either. It is very possible the pgport fix I did yesterday is related, but I have not applied it yet. It's an intermittent failure;

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

2006-05-07 Thread Tom Lane
Bruce Momjian pgman@candle.pha.pa.us writes: Have we seen any such failures since the first day they appeared? agouti blew up about the same time you typed that, so yes it's still a problem. http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=agoutidt=2006-05-08%2003:15:01

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

2006-04-30 Thread Tom Lane
Magnus Hagander [EMAIL PROTECTED] writes: This was not ready to be applied, was it? I don't recall any specific objections that weren't answered. How about the fact that it's already caused one buildfarm failure? http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=waspdt=2006-04-30%2003:05:01

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

2006-04-30 Thread Magnus Hagander
This was not ready to be applied, was it? I don't recall any specific objections that weren't answered. How about the fact that it's already caused one buildfarm failure? http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=waspdt=2006 -04-30%2003:05:01 Well, that objection certainly

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

2006-04-27 Thread Magnus Hagander
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. This was not ready to be applied, was it? An attempt doesn't sound to me like Magnus thought it was

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

2006-04-26 Thread Bruce Momjian
Patch applied. Thanks. --- 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

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

2006-04-26 Thread Tom Lane
Bruce Momjian pgman@candle.pha.pa.us writes: Patch applied. Thanks. 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. This was not ready to be applied, was it? An attempt

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

2006-04-26 Thread Bruce Momjian
Tom Lane wrote: Bruce Momjian pgman@candle.pha.pa.us writes: Patch applied. Thanks. 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. This was not ready to be

[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

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 of

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 once every

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
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