Re: spatial query don't use index!

by yishh :: Rate this Message:

Some parts of this message have been removed. Learn more about Nabble's security policy.

Thanks.

This table size is 1200000 rows.

I create index originally:

CREATE INDEX user_idx_gin

ON mapfriends."user"

USING gist

((geometry));

now I replace with:

CREATE INDEX user_idx_gin

ON mapfriends."user"

USING gist

((geometry::box));

And query can use spatial index now.

Who can explain this?

2009-06-18

yishh.lee

发件人： Guillaume Lelarge

发送时间： 2009-06-18 15:40:32

收件人： PostGIS Users Discussion

抄送：

主题： Re: [postgis-users] spatial query don't use index!

Suhr, Ralf a écrit :

> Your cost begin at value 0.00. The index is in use.

The startup cost never shows if the index is in use or no. This is a

sequential scan, and no index is in use.

What is the size of the user table?

Guillaume.

http://www.postgresqlfr.org

http://dalibo.com

_______________________________________________

postgis-users mailing list

http://postgis.refractions.net/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users