On Fri, Oct 30, 2009 at 8:11 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > But having said that, this particular test case is far from compelling. > 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. Well it would be nice if that wasn't necessary. There are plenty of applications where that isn't really an option. Consider searching for phrases like "The The" or "The Office". The sanity of doing this is purely a function of implementation quality and not of actual user interface design. -- greg -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance