Andrew G and I went in to look at the perf problems on openacs.org. Although we expect this simply to confirm that we have problems that will be fixed by upgrading to openacs 5, we are also documenting a technique that was missing for postgresql in our docs (
https://openacs.org/doc/openacs-5-1/maint-performance.html). After some messing around to figure out which version of postgresql was the right one, we isolated the necessary work to:
1) Edit /emacs /var/lib/pgsql/data/postgresql.conf
change
#stats_command_string = false
to
stats_command_string = true
2) stop openacs.org (svc -d /service/openacs.org)
3) restart the database (/etc/init.d/postgresql-7.2.4 restart)
4) start openacs.org (svc -u /service/openacs.org)
The result is that running queries can now be seen by querying the database:
psql -p 5724 openacs.org nsadmin
openacs.org=> select * from pg_stat_activity;
