Russell Keane <Russell.Keane@xxxxxxxxxx> writes: > Running the following query takes 56+ ms as it does a seq scan of the whole table: > SELECT CODE FROM stuff > WHERE SEARCH_KEY LIKE 'AAAAAA%' Why don't you create an index on search_key, and forget all these other machinations? (If your locale isn't C you'll need to use a varchar_pattern_ops index.) regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
