http://www.redhat.com/docs/en-US/JBoss_ON/2.3/html/Installation_Guide/Installation_Guide-Prerequisites-Database.html#Installation_Guide-Database-Postgres_Preparation recommends that statement_timeout be set to 30s. I do not know where this recommendation comes from but as PostgreSQL recommends that this value be 0, I think we should honour that.
Furthermore, 30s does not seem to be adequate to handle data compression in large environments. This recommendation should be reviewed and the documentation should be corrected to reflect that this value should be evaluated and increased in situations that require it.
We should also change this from a global recommendation to a user setting recommendation:
ALTER USER rhqadmin SET statement_timeout=300000;
QA Verified... I think this documentation note looks good now.
Mass-closure of verified bugs against JON.