[TriLUG] Ticketing system for Linux?

Michael Alan Dorman mdorman at debian.org
Thu Aug 29 09:27:48 EDT 2002


Benjamin Reed <ranger at befunk.com> writes:
> Yeah, we're using it too.  BE WARNED that although I love PostgreSQL
> it is very much *not* suited to RT, use MySQL instead.  PostgreSQL's
> biggest fault is in handling large text fields, which is what 98% of
> RT's database is.  We were seeing abysmal performance (ie,
> 10-seconds to open a web page to view an existing ticket!) until we
> switched it over to MySQL.
> 
> Once we switched over, everything's been peachy... RT is chugging
> along very nicely with 20 or 30 thousand tickets in the database.

Hum.  I've never had that problem.  Are you sure you were keeping up
to date?  Many things to speed postgresql support have gone in in the
last year.  Especially updates in DBIx::SearchBuilder, which RT
depends on heavily...

Mike.



More information about the TriLUG mailing list