On Thu, 2012-03-22 at 16:26 -0400, Edward W. Rouse wrote: > I am currently using lower(column) = '' for matching case insensitive. I > know that there are ways to do this with regular expressions too. I recently > noticed that including even one lower causes severe performance issues (from > 290ms to over 80Kms). >
Probably because it cannot use the index anymore. Try creating an index on lower(column), and see if it helps. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
