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
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
