Forcing GiST index to be used - Mailing list pgsql-hackers

From Dave Blasby
Subject Forcing GiST index to be used
Date
Msg-id 3B795D59.A1A4C7F7@refractions.net
Whole thread Raw
Responses Re: Forcing GiST index to be used
List 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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: int8 sequences --- small implementation problem
Next
From: Stephan Szabo
Date:
Subject: Re: int8 sequences --- small implementation problem