[TriLUG] Ticketing system for Linux?

Ben Pitzer uncleben at mindspring.com
Mon Sep 2 13:17:29 EDT 2002


Actually, PostgreSQL fixed this in version 7.2.  They now support
unlimited length text fields, despite the fact that they are not part of
the SQL standard.  They did it as a response to that data type's
inclusion in competing RDBMSes.

See the documentation for more info:

http://www.postgresql.org/idocs/index.php?datatype-character.html

Regards,
Ben Pitzer

On Thu, 2002-08-29 at 08:56, Benjamin Reed wrote:
> On Thu, 2002-08-29 at 08:42, Thomas C. Meggs wrote:
> > 
> > Yeah... hands down one of the best OSS ticketing systems I've used. We 
> > actively use it at work to manage requests.
> 
> 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.
> 
> -- 
> Ben Reed a.k.a. Ranger Rick (ranger at befunk.com)
> http://defiance.dyndns.org/ / http://radio.scenespot.org/
> ...if humanoids eat chicken, then obviously they'd eat their own
> species.  Otherwise they'd just be picking on the chickens. -- Kryten
> 
> _______________________________________________
> TriLUG mailing list
>     http://www.trilug.org/mailman/listinfo/trilug
> TriLUG Organizational FAQ:
>     http://www.trilug.org/~lovelace/faq/TriLUG-faq.html





More information about the TriLUG mailing list