pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Background writer memory bloat?
3+ messages / 2 participants
[nested] [flat]

* Background writer memory bloat?
@ 2006-08-04 14:41 Peter Eisentraut <peter_e@gmx.net>
  2006-08-04 15:00 ` Re: Background writer memory bloat? Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 3+ messages in thread

From: Peter Eisentraut @ 2006-08-04 14:41 UTC (permalink / raw)
  To: pgsql-admin

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/



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Background writer memory bloat?
  2006-08-04 14:41 Background writer memory bloat? Peter Eisentraut <peter_e@gmx.net>
@ 2006-08-04 15:00 ` Tom Lane <tgl@sss.pgh.pa.us>
  2006-08-04 16:07   ` Re: Background writer memory bloat? Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 1 reply; 3+ messages in thread

From: Tom Lane @ 2006-08-04 15:00 UTC (permalink / raw)
  To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Background writer memory bloat?
  2006-08-04 14:41 Background writer memory bloat? Peter Eisentraut <peter_e@gmx.net>
  2006-08-04 15:00 ` Re: Background writer memory bloat? Tom Lane <tgl@sss.pgh.pa.us>
@ 2006-08-04 16:07   ` Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 0 replies; 3+ messages in thread

From: Peter Eisentraut @ 2006-08-04 16:07 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin

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/



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2006-08-04 16:07 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-08-04 14:41 Background writer memory bloat? Peter Eisentraut <peter_e@gmx.net>
2006-08-04 15:00 ` Tom Lane <tgl@sss.pgh.pa.us>
2006-08-04 16:07   ` Peter Eisentraut <peter_e@gmx.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox