[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.



Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
t: +44 870 608 0063

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

More information about the postgis-users mailing list