"Kevin Grittner" <kevin.gritt...@wicourts.gov> writes: > Tom Lane <t...@sss.pgh.pa.us> wrote: >> Any sane text search application is going to try to filter out >> common words as stopwords; it's only the failure to do that that's >> making this run slow. > I'd rather have the index used for the selective test, and apply the > remaining tests to the rows retrieved from the heap.
Uh, that was exactly my point. Indexing common words is a waste. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance