[TriLUG] Ticketing system for Linux?

[Ben Pitzer]

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