Hi Alan. For simple needs you can use Staplr, it's very easy to configure. There's also one - zabbix, pretty much. 2009/6/13 Alan McKay: > Hey folks, > > I'm new to performance monitoring and tuning of PG/Linux (have a fair > bit of experience in Windows, though those skills were last used about > 5 years ago) > > I finally have Munin set up in my production environment, and my > goodness it tracks a whole whack of stuff by default! > > I want to turn off the graphing of unimportant data, to unclutter the > graphs and focus on what's important. > > So, from the perspective of both Linux and PG, is there canonical list > of "here are the most important X things to track" ? > > On the PG side I currently have 1 graph for # connections, another for > DB size, and another for TPS. Then there are a few more graphs that > are really cluttered up, each with 8 or 9 things on them. > > On the Linux side, I clearly want to track HD usage, CPU, memory. But > not sure what aspects of each. There is also a default Munin graph > for IO Stat - not sure what I am looking for there (I know what it > does of course, just not sure what to look for in the numbers) > > I know some of this stuff was mentioned at PG Con so now I start going > back through all my notes and the videos. Already been reviewing. > > If there is not already a wiki page for this I'll write one. I see > this is a good general jump off point : > > http://wiki.postgresql.org/wiki/Performance_Optimization > > But jumping off from there (and searching on "Performance") does not > come up with anything like what I am talking about. > > Is there some good Linux performance monitoring and tuning reading > that you can recommend? > > thanks, > -Alan > > -- > “Mother Nature doesn’t do bailouts.” > - Glenn Prickett > > -- > Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance > -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
