Re: A question about memory usage

2007-06-13 Thread David Fox
http://lwn.net/Articles/230975/ its not the article I was looking for (which actually shows you how to do the calculations...), but its pretty cool As I recall, there was a utility somewhat like vmstat(1) but unique in that it could crawl through the system and find out all the different r

Re: A question about memory usage

2007-06-13 Thread Andrew Sackville-West
On Wed, Jun 13, 2007 at 07:45:50PM -0400, Douglas Allan Tutty wrote: > 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

Re: A question about memory usage

2007-06-13 Thread Douglas Allan Tutty
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 y

Re: A question about memory usage

2007-06-13 Thread Scott Gifford
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

Re: A question about memory usage

2007-06-13 Thread Douglas Allan Tutty
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 Doug. -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscrib

Re: A question about memory usage

2007-06-12 Thread Scott Gifford
Andrew Sackville-West <[EMAIL PROTECTED]> writes: > On Tue, Jun 12, 2007 at 11:32:00AM -0400, Scott Gifford wrote: [...] >> Figuring out exactly how much memory a set of processes are using is a >> difficult problem. Looking in /proc/$pid/maps is a good place to >> start. >> > > probably the e

Re: A question about memory usage

2007-06-12 Thread Arnau
Andrew Sackville-West wrote: On Tue, Jun 12, 2007 at 11:32:00AM -0400, Scott Gifford wrote: Arnau <[EMAIL PROTECTED]> writes: Hi all, I have a server with 4GB of RAM and I wanted to know how much memory is being used by a PostgreSQL. To do so I have executed the following: ps -A -o rss

Re: A question about memory usage

2007-06-12 Thread Andrew Sackville-West
On Tue, Jun 12, 2007 at 11:32:00AM -0400, Scott Gifford wrote: > Arnau <[EMAIL PROTECTED]> writes: > > > Hi all, > > > >I have a server with 4GB of RAM and I wanted to know how much > > memory is being used by a PostgreSQL. To do so I have executed the > > following: > > > >ps -A -o rss,vs

Re: A question about memory usage

2007-06-12 Thread Scott Gifford
Arnau <[EMAIL PROTECTED]> writes: > Hi all, > >I have a server with 4GB of RAM and I wanted to know how much > memory is being used by a PostgreSQL. To do so I have executed the > following: > >ps -A -o rss,vsz,command|grep postgres | awk '{rss += $1; vsz += $2 > } END { print "Real: ",rss

A question about memory usage

2007-06-12 Thread Arnau
Hi all, I have a server with 4GB of RAM and I wanted to know how much memory is being used by a PostgreSQL. To do so I have executed the following: ps -A -o rss,vsz,command|grep postgres | awk '{rss += $1; vsz += $2 } END { print "Real: ",rss/1024"MB Virtual: ",vsz/1024"MB" }' And the r