[rt-users] performance problem - RT3.0.3 on Postgresql 7.3.3

[Sophie Rockhsar]

Hi all,

Just upgraded to RT 3.0.3, on PostgreSql 7.3.3 (FreeBSD 4.8 box). The database 
had already existed (and had RT 3.0.2 running on it), so I just got the 
upgrade through the ports collection, and left the existing database intact. 
I restarted the postgres server and apache, and that was all...

The performance of the database server is extremely bad when any 
Reply/Resolve/Comment is issued on a ticket. Any suggestions?

Thanks much,
Sophie