On Mon, May 23, 2011 at 05:31:04PM +0530, Nick Raj wrote: > Hi, > I have build an index. When, i execute the query, it gives the result by > sequential scan, not by using my index. > For that, i have set enable_seqscan=off in postgresql.conf. But it still > going through sequential scan. It sounds like your index can't actually be used to satisfy your query. Without seeing the table definition, index definition, and query, however, it's pretty hard to give you a real answer. A -- Andrew Sullivan ajs@xxxxxxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
