Forcing GiST index to be used

Поиск
Список
Период
Сортировка
От Dave Blasby
Тема Forcing GiST index to be used
Дата
Msg-id 3B795D59.A1A4C7F7@refractions.net
обсуждение исходный текст
Ответы Re: Forcing GiST index to be used  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: int8 sequences --- small implementation problem
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: int8 sequences --- small implementation problem