Forcing GiST index to be used

From: Dave Blasby <dblasby(at)refractions(dot)net>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Forcing GiST index to be used
Date: 2001-08-14 17:18:17
Message-ID: 3B795D59.A1A4C7F7@refractions.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I have a custom datatype (the PostGIS geometry type), which I have
indexed using a GiST index.

The problem is, its difficult to get PostgreSQL to actually use the GiST
index. The only way I can get it to be used is by 'set enable_seqscan =
off', which seems a bit cheezy. What am I missing? Do I have to make
some sort of amcostestimate() function or something?

thanks,
dave

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-08-14 17:39:10 Re: RFC: Inserting multiple values via INSERT ... VALUES ...
Previous Message Neil Padgett 2001-08-14 17:12:26 Re: int8 sequences --- small implementation problem