"Kevin Grittner" <Kevin.Grittner@xxxxxxxxxxxx> writes: > Tom Lane <tgl@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
