SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-10-2008, 06:28 AM
| ||||
| ||||
 Background writer memory bloat? I'm seeing a background writer process in an 8.0.8 installation that uses 1.6 GB of main memory, and ps shows that it has used an unreasonable amount of CPU time so far. It seems that the machine was under heavy load just before I got to it; maybe that is cause? Has anyone seen this sort of memory bloat on the background writer process? -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend      |
|
04-10-2008, 06:28 AM
| |||
| |||
| Re: Background writer memory bloat? Peter Eisentraut <peter_e@gmx.net> writes: > I'm seeing a background writer process in an 8.0.8 installation that uses 1.6 > GB of main memory, and ps shows that it has used an unreasonable amount of > CPU time so far. It seems that the machine was under heavy load just before > I got to it; maybe that is cause? Has anyone seen this sort of memory bloat > on the background writer process? Are you sure it's bloat, and not just a reflection of the fact that it's touched every page of the shared buffers over its lifespan? Some OSes (you did not say what this is) report a process' memory size as including only those pages of shared memory it's touched. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match |
|
04-10-2008, 06:28 AM
| ||||
| ||||
| Re: Background writer memory bloat? Am Freitag, 4. August 2006 17:00 schrieb Tom Lane: > Are you sure it's bloat, and not just a reflection of the fact that it's > touched every page of the shared buffers over its lifespan? That seems to be the explanation. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend |
Linear Mode
