Page History

Remarks

The tests were run on a PC running Slackware Linux with a kernel 2.6.9. The CPU was a P4 2.80GHz, the RAM was 512 Mb (which was too small).

Database parameters were set to their default values. No optimization was attempted.

Data are considered to be spread on a rectangular plane. The spherical geometry is not taken into account.

Posgresql

Postgresql, since a long time, has implemented geospatial features.

...

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 id, time, energy 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.1 seconds.
A GIST index has been built.
The response time is 2. seconds.

...

select id, time, energy rom events where ra_min < ra and ra < ra_max and dec_min < dec and dec < dec_max
The response time is around 0.3 second.

using the spatial module

The This statement has been used :
select id, time, energy from events where sdo_filter(error, sdo_geometry(2003, null, null, sdo_elem_info_array(1,1003,3), sdo_ordinate_array(ra_min, dec_min, ra_max, dec_max))) = true

For this command to work an index must be created.
The response time is around 0.8 second.