[postgis-users] Indexes used in 1.3.3 but not in 1.5.3
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 ?
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