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

Vivek Khera khera at kcilink.com
Thu Oct 16 10:04:34 EDT 2003


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

>> Or create an index on lower(EmailAddress) on that table:
>> 
>> CREATE INDEX users5 ON users (lower(emailaddress));
>> 

JH> Tried, but no dice. Are you interested in seeing the postgres
JH> EXPLAIN output's before and after the index?

yes, that would be helpful.  also, run 'vacuum analyze users' so that
the index has proper statistics on it.

JH> I tested the ILIKE solution and it does work. It reduces query
JH> time to less than one second. I expect this may not be suitable in
JH> terms of keeping this cross-database-platform compatible.

Well, if you only need to change the schema, then using a non
SQL-standard query would not be needed.  Or is ILIKE a standard?



More information about the rt-users mailing list