Thread: Memory monitoring tool

Memory monitoring tool

From
Jean-Michel Pouré
Date:
Dear all,

I am migrating a large PhpBB forum to Drupal.

What memory monitoring tool would you recommend?
I never used one before in PostgreSQL.

The only figures I read are those from VACUUM VERBOSE ANALYSE to make
sure I have enough shared memory for indexes.

What more complex tools would you recommend to monitor memory usage?

Kind regards,
Jean-Michel

Attachment

Re: Memory monitoring tool

From
Josh Berkus
Date:
> What more complex tools would you recommend to monitor memory usage?

vmstat, and sar on Linux.  Dtrace on BSD or Solaris, if you're ready to
write some d-script.  pg_top for PG memory usage interactively.

See performance-whack-a-mole: www.pgcon.org/2009/schedule/events/188.en.html

--
Josh Berkus
PostgreSQL Experts Inc.
www.pgexperts.com