[postgis-users] Indexes used in 1.3.3 but not in 1.5.3

[Mark Cave-Ayland]

On 20/10/11 16:31, Frederic Junod wrote:

> The database was imported with postgis_restore.pl. I've also tried to
> reindex the database.
>
> Note that on both instances, if the st_buffer is removed the indexes are used.
>
> What's happening ?

Hi Frederic,

You'll have to post the EXPLAIN ANALYZE output if you want more help 
with this one. Also note that just because an index is there, it may not 
always be used because sequential scans can be used in a lot of cases.


HTH,

Mark.

-- 
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063

Sirius Labs: http://www.siriusit.co.uk/labs