Re: postgres -- monitor and suggestions - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: postgres -- monitor and suggestions
Date
Msg-id 2f4958ff0906180718r1622ff1bo142b72b8b9095036@mail.gmail.com
Whole thread Raw
In response to postgres -- monitor and suggestions  (Sim Zacks <sim@compulab.co.il>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Sim Zacks
Date:
Subject: postgres -- monitor and suggestions
Next
From: Lennin Caro
Date:
Subject: Re: connecting to a remote pq always require a password