[rt-users] RT 2.0.12 + postgres

Vivek Khera khera at kcilink.com
Thu Apr 11 10:28:57 EDT 2002


>>>>> "BT" == Bas Toonk <B.Toonk at zx.nl> writes:

BT> Since i updated RT 2.0.7 to 2.0.12 people are complaining that RT is very
BT> slow.
BT> The first page and the search page is normal.  But display a ticket and
BT> update an tickets pages
BT> are realy slow.

Compare the database schemas from what you have to what comes with
2.0.12 and add the missing indices.  Also, make sure you "VACUUM
ANALYZE" your rt database every so often, to keep Postgres' statistics
accurate.  I do this nightly.

Make sure your Perl module dependencies are up-to-date.

Postgres works great with RT.




More information about the rt-users mailing list