[postgis-users] GIST index speed

[Peck, Brian]

Hey all,

 

I currently am working on a PostGIS database (Postgres 8.3) and the
requests are going slower than expected.

 

The table I'm querying off of has ~42000 entries in it, and the geometry
field I'm using has a gist index on it. The query however is taking ~6
seconds to return me the entries.

 

I am making the query 

 

SELECT * FROM asdfs_track_point where
within(the_geom,GeometryFromText('POLYGON((-180.0 -90.0,-180.0
90.0,180.0 90.0,180.0 -90.0,-180.0 -90.0))',4326));

 

This is a test case and so I am doing the entire world to find out how
long things should take, but I'm told that with only 42000 rows in the
table it should be faster than 6 seconds.

 

Anyone have any idea why it might be going slow, or a way to speed up
the query?

 

Thanks,

 

- Brian Peck

- 858-795-1398

- Software Engineer

- Lockheed Martin

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20080604/26c743ef/attachment.html>