Re: [GENERAL] postgres -- monitor and suggestions
Hello Sim, as Grzegorz already mentioned, you have to gather the info from the logs. Therefore I would suggest the tool pgfouine. There's an option to visualize the log of a VACUUM run. You should give it a try... regardsGERD... Sim Zacks schrieb: 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 -- /===\ | Gerd König | - Infrastruktur - | | TRANSPOREON GmbH | Pfarrer-Weiss-Weg 12 | DE - 89077 Ulm | | | Tel: +49 [0]731 16906 16 | Fax: +49 [0]731 16906 99 | Web: www.transporeon.com | \===/ Bleiben Sie auf dem Laufenden. Jetzt den Transporeon Newsletter abonnieren! http://www.transporeon.com/unternehmen_newsletter.shtml TRANSPOREON GmbH, Amtsgericht Ulm, HRB 722056 Geschäftsf.: Axel Busch, Peter Förster, Roland Hötzl, Marc-Oliver Simon -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] postgres -- monitor and suggestions
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 -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] postgres -- monitor and suggestions
2009/6/18 Sim Zacks s...@compulab.co.il: 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general