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

Mark Cave-Ayland mark.cave-ayland at siriusit.co.uk
Tue Oct 25 06:01:48 PDT 2011


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



More information about the postgis-users mailing list