Re: [GENERAL] postgres -- monitor and suggestions

2009-06-19 Thread Gerd König
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 post

Re: [GENERAL] postgres -- monitor and suggestions

2009-06-18 Thread Grzegorz Jaśkiewicz
2009/6/18 Sim Zacks : > 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

[GENERAL] postgres -- monitor and suggestions

2009-06-18 Thread Sim Zacks
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