[rt-users] RT 2.0.12 + postgres

[Vivek Khera]

>>>>> "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.