> Is there any tweaks to force pgsql to use index on description? Even if you could force it to use the index, it wouldn't make the query run faster. As others have pointed out, what you really need is a different kind of index... ...Robert -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance