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

your old should be using > costing metrics as well so not sure why it would switch between now. > > Hope that helps, > Regina > http://www.postgis.us > > -Original Message- > From: postgis-users-boun...@postgis.refractions.net > [mailto:postgis-users-boun...@postgis.r

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

Hello, With postgis 1.3.3 on postgresql 8.3.14, the following select uses the indexes: EXPLAIN SELECT 1 FROM grid_pk25, grid_geocover WHERE st_overlaps(st_buffer(grid_geocover.the_geom, -1), grid_pk25.the_geom); QUERY PLAN -