Обсуждение: 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

2009/6/18 Sim Zacks <sim@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

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...

regards....GERD...

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