r-tree indexed searches

From: Geordie Hobart <ghobart(at)refractions(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: r-tree indexed searches
Date: 2001-02-10 00:19:17
Message-ID: 3A848905.450948B1@refractions.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-novice by date

  From Date Subject
Next Message Dan B 2001-02-10 04:45:50 Trigger using function written in PL/PGSQL returns "Unrecognized language specified"
Previous Message Anthony E . Greene 2001-02-09 04:50:17 Re: Getting Started