SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-18-2008, 12:33 AM
| ||||
| ||||
 Re: pgstat: delayed write of stats file 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 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 Content-Description: pgstat_delay.patch [ Attachment, skipping... ] > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster -- Bruce Momjian http://candle.pha.pa.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq      |
|
04-18-2008, 12:33 AM
| |||
| |||
| Re: pgstat: delayed write of stats file 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" doesn't sound to me like Magnus thought it was ready for prime time, and my recollection of the thread is that there were objections. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster |
|
04-18-2008, 12:33 AM
| ||||
| ||||
| Re: pgstat: delayed write of stats file 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 applied, was it? "An attempt" doesn't sound > to me like Magnus thought it was ready for prime time, and my > recollection of the thread is that there were objections. I don't remember any objection. Magnus, Tom, revert? -- Bruce Momjian http://candle.pha.pa.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly |
Linear Mode
