[rt-users] postgres slowdowns? (pg 7.3.4, rt 3.0.4)

[Vivek Khera]

>>>>> "JR" == Jim Rowan <jim.rowan at starcore-dsp.com> writes:

JR> I'd suggest that you just force the emailaddress to be lowercased when
JR> it is entered or modified.  Pay the penalty once on entry, instead of
JR> thousands of times an hour...  I can't think of any reason that you WANT
JR> to preserve the case.

In my primary application, this is precisely what we do.  We also
force that to be unique, which I suspect should happen in RT as well,
but it may be difficult to retro-actively do that on a big DB if the
uniqueness is not already met.