Page History

...

A R-tree index has been built using the error bounding box.
The response time is 0.01 seconds.

using the postgis module

PostGIS adds support for geographic objects to PostgreSQL.
It implements some of the OpenGIS specifications.
The events table has been modified to comply with the OpenGIS standard. The following statement has been sent to the database :
select * from events where error &&
GeomFromText('POLYGON((ra_max dec_max, ra_max dec_min, ra_min dec_min, ra_min dec_max, ra_max dec_max)', -1)

The response time is 3.7 seconds.