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

[Vivek Khera]

>>>>> "JH" == Justin Hawkins <justin at internode.com.au> writes:

JH> (Users_5.EmailAddress = 'email at address.here') AND

JH> Changes the query time from several minutes (!) to less than a second.

JH> Obviously the query is not quite right then, since I am guessing we
JH> do care about case insensitivity. So perhaps:

Or create an index on lower(EmailAddress) on that table:

CREATE INDEX users5 ON users (lower(emailaddress));

see if that speeds it up, since PG will then be able to use the
index.  It sounds like the users5 index is unused, since the query is
not against a fixed string but on a function.

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
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/