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

[Vivek Khera]

>>>>> "JV" == Jesse Vincent <jesse at bestpractical.com> writes:

JV> Have a look at searchbuilder 0.93_01. This already does ILIKE instead of
JV> LIKE for postgres. Having read a bit more about ILIKE, I'm not convinced
JV> that it's actually going to be faster than apropriate functional
JV> indices. (We should probably continue this on rt-devel)


Well, ILIKE should use the existing index (I think), but a functional
index on lower(emailaddress) should be sufficient in its place with =
as the comparison.  I'm still waiting to see the explain outputs of
the different queries on a large db.  my RT3 DB has about 8 tickets so
far :-)

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.                Khera Communications, Inc.
Internet: khera at kciLink.com       Rockville, MD       +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/