I was having problems with Postgres hanging -- specifically, the DB transactions on some pages were not being executed on the initial page load (reloading the pages caused the DB transactions to execute and the data to appear).
I resolved the issue by upgrading from Postgres 7.0 to 7.1 (for help upgrading, see http://pascal.scheffers.net/openacs/pgupdate/).