Forum OpenACS Q&A: Re: Insert Performance Issues - PG 7.2.3/OpenACS 4.5/perl/dbi

This optimization stuff is good - enough detail to put into the docs.  Could someone take a minute to outline a few ways to test success of optimization?  Obviously if the database server crashes on startup you failed.  But what are some easy stress tests?  What instrumentation is needed to monitor variables?  And what values for the variables are good or bad?  (I.e., if I change config param X and run query Y, then while watching variable Z I should see it stay below W.)