Following up a couple questions from the presentation at PSU on January 8, 2009

markwkm's picture

A couple of questions were asked during the presentation that aren't really covered in the slides, which I'll answer here:

-----

What do I use to chart systems statistics from sar, iostat, vmstat, etc.?

There a couple of perl modules that I try to maintain, Test-Parser and Test-Presenter. They can be downloaded from CPAN and the source is in subversion at:

svn co https://svn.sourceforge.net/svnroot/crucible/Test-Parser Test-Parser
svn co https://svn.sourceforge.net/svnroot/crucible/Test-Presenter Test-Presenter

-----

What is 'iopp'?

It's a custom tool to go through the Linux process table to get i/o statistics per process. It is open source and can be downloaded from:

http://git.postgresql.org/?p=~markwkm/iopp.git;a=summary

-----

Will there be a mailing list for these presentations?

Not likely. Since we'll be discussing PostgreSQL performance, I believe it will be best to use the community mailing list for reaching out to a wider audience for performance discussions. Mailing list details are here:

http://www.postgresql.org/mailpref/pgsql-performance

For other meeting related topics, I think we can use the PDXPUG mailing list:

http://www.postgresql.org/mailpref/pdxpug

Hopefully this will meet our needs.

----

Back to top