[rt-devel] [BUG] Email bounces when subject > 200 bytes

Florian Weimer fw at deneb.enyo.de
Wed Feb 18 14:47:05 EST 2004


Jesse Vincent wrote:

> On Wed, Feb 18, 2004 at 02:49:54PM +0100, Kouprie, Robbert wrote:
> > Hi Florian,
> > 
> > Thanks for the explanation.
> > Someone from the RT dev team might want to fix the shipped Postgres database
> > schema?
> 
> I'm more tempted to go for a truncation solution, unless someone can
> explain to me what varchars without specified lengths do to index
> performance ;)

There's no index on tickets.subject. 8-)  But I see your point,
users.name is such a case.

Last time I looked at the PostgreSQL code, VARCHAR was implemented as
TEXT plus length checking.  Shall I recheck?

(Unfortunately, I don't have an RT3 instance sufficiently large for
benchmarking.)



More information about the Rt-devel mailing list