Обсуждение: Memory monitoring tool

От:
Jean-Michel Pouré
Дата:

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

От:
Josh Berkus
Дата:

> 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