postgres -- monitor and suggestions

From: Sim Zacks <sim(at)compulab(dot)co(dot)il>
To: pgsql-general(at)postgresql(dot)org
Subject: postgres -- monitor and suggestions
Date: 2009-06-18 13:58:23
Message-ID: h1dh63$12dj$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is there a tool that can monitor my postgresql and recommend
configuration changes based on actual use?

For example, when I run VACUUM ANALYZE it tells me that I should
consider increasing the max_fsm_relations.

After monitoring for a period of time, I would like to know if my shared
buffers are set optimally (for example). Or if I need more RAM in the
machine to run better etc..

Thank you
Sim

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marcin Stępnicki 2009-06-18 14:01:58 Re: ruby connect
Previous Message John DeSoi 2009-06-18 13:32:33 Re: connecting to a remote pq always require a password