RE: R-tree indexing, RA wrap and LISTENing

[Tom Droege <tdroege2@earthlink.net>]

I was finished processing last nights data at about 2PM today.  We could 
process it at roughly the speed taken but that will need some 
software.  There were about 350,000 pairs.  Big, but not too big to send in 
under an hour.  So we could get new stuff to the data base within about 16 
hours.  This is good enough for the next evening's observations.    I can 
imagine getting data out in a couple of hours by running a batch 
operation.  I could write what it takes to do that.  So same night alerts 
are possible.

So we could alert for nova and close, fast moving asteroids.

Tom Droege

At 02:04 PM 6/6/03 -0600, Creager, Robert S wrote:

>PostgreSQL has NOTIFY/LISTEN, which is used for just this purpose.  A set of
>NOTIFY events would be created, and folks could sign up to receive e-mail of
>these events.  Then the LISTEN would query the dB to see who wanted
>notification, and then send e-mail.
>
> >
> > Cheers,
> > Doug
> >
>
>Later,
>Rob