On Wed, Jun 13, 2007 at 01:28:31PM -0400, Scott Gifford wrote: > Douglas Allan Tutty <[EMAIL PROTECTED]> writes: > > On Tue, Jun 12, 2007 at 06:05:08PM +0200, Arnau wrote: > > > >> In fact what I really want to do is > >> monitor how much memory PostgreSQL is using. > > > > What about top? If you need to, you can limit top to a list of PIDs > > top has the same issues as ps: you can't tell what memory is shared > between processes. >
I think I'm beginning to understand: e.g. 10 postgres processes, each saying its using e.g. 100 MB VIRT yet 1 GB is not being used. What is needed is something that does for VM as du does for diskspace. That would be a most useful tool, especially on boxes with low free memory. Doug. -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]