Re: Query Analysis

<typea@l-i-e.com> writes:
> 15,000 reocrds with a 'text' field named 'text'
> Average 'text' length about 10 K.
> Full text search using lower() and LIKE and even ~* sometimes on that
> field with a keyword.

Consider using a full-text-indexing method (there are a couple in
contrib, and OpenFTS has a website that was mentioned recently in
the mail lists).

            regards, tom lane