Ivan Voras < ivoras@xxxxxxxxxxx > wrote: > On 07/14/10 15:49, Stephen Frost wrote: >> Regarding the statistics, it's entirely possible that the index >> is *not* the fastest way to pull this data (it's nearly 10% of >> the table..) > > I think that what I'm asking here is: is it reasonable for > tsearch2 to extract 8,500 rows from an index of 90,000 rows in 118 > ms, given that the approximately same task can be done with an > unindexed "LIKE" operator in nearly the same time? The answer is "yes." When it's 10% of the table, a sequential scan can be more efficient than an index, as Stephen indicated. -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
