2009/6/18 Sim Zacks <sim@xxxxxxxxxxxxxx>: > 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.. No. There's pgtune, but that's for initial configuration. EVerytnig else you have to findout yourself from logs. -- GJ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
