Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

select * from events where error && box ra_max,dec_max, ra_min,dec_min
A column error has been added to the table. It is of type box and stores ra+dg, dec+dg, ra-dg, dec dg with dg = 1.°. The operator && means overlaps.
The response time is around 0.9 second.

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