Обсуждение: r-tree indexed searches

Поиск
Список
Период
Сортировка

r-tree indexed searches

От
Geordie Hobart
Дата:
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