pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedBackground 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