Peter Eisentraut <[EMAIL PROTECTED]> 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
