r-tree indexed searches - Mailing list pgsql-novice

From Geordie Hobart
Subject r-tree indexed searches
Date
Msg-id 3A848905.450948B1@refractions.net
Whole thread Raw
List pgsql-novice
I'm trying to use an r-tree indexed search on a box data type, but the
explain statement tells me that a sequence scan is being preformed
instead. The table has 130 000 tuples and I can't beleive the sequence
scan is faster. I tried to set enable_seqscan=off on the commmand line
but version 7.0.3 doesn't seem to support this option. Can you suggest
some alternates to force the r-tree indexed search? Thanks


pgsql-novice by date:

Previous
From:
Date:
Subject: re : Problem with UPDATE query
Next
From: John James
Date:
Subject: Mac OS X Beta Status?