From: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
---|---|
To: | Nick Bower <nick(at)nickbower(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Two billion records ok? |
Date: | 2006-09-05 05:58:02 |
Message-ID: | Pine.GSO.4.63.0609050956100.16344@ra.sai.msu.su |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, 5 Sep 2006, Nick Bower wrote:
> Thanks - but what do you call big?
Several billions of stars. You can try our Cone Search service at
http://vo.astronet.ru/cas/conesearch.php
Oleg
>
> My application is satellite data btw so the reference could be useful.
>
> On Tue, 5 Sep 2006 01:40 pm, Oleg Bartunov wrote:
>> Nick,
>>
>> if you need very fast spatial queries (spherical) you may use our
>> Q3C module for POstgreSQL (q3c.sf.net) We use it for providing access
>> to very big astronomical catalogs.
>>
>>
>> Oleg
>>
>> On Tue, 5 Sep 2006, Nick Bower wrote:
>>> We're considering using Postgresql for storing gridded metadata - each
>>> point of our grids has a variety of metadata attached to it (including
>>> lat/lon, measurements, etc) and would constitute a record in
>>> Postgresql+Postgis.
>>>
>>> Size-wise, grids are about 4000x700 and are collected twice daily over
>>> say 10 years. As mentioned, each record would have up to 50 metadata
>>> attributes (columns) including geom, floats, varchars etc.
>>>
>>> So given 4000x700x2x365x10 > 2 billion, is this going to be a problem if
>>> we will be wanting to query on datetimes, Postgis lat/lon, and
>>> integer-based metadata flags?
>>>
>>> If however I'm forced to sub-sample the grid, what rule of thumb should I
>>> be looking to be constrained by?
>>>
>>> Thanks for any pointers, Nick
>>>
>>> PS - Feel free to throw in any other ideas of grid-suitable databases :)
>>>
>>> ---------------------------(end of broadcast)---------------------------
>>> TIP 4: Have you searched our list archives?
>>>
>>> http://archives.postgresql.org
>>
>> Regards,
>> Oleg
>> _____________________________________________________________
>> Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru)
>> Sternberg Astronomical Institute, Moscow University, Russia
>> Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
>> phone: +007(495)939-16-83, +007(495)939-23-83
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru)
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Allen | 2006-09-05 05:58:03 | Re: Two billion records ok? |
Previous Message | Nick Bower | 2006-09-05 05:53:08 | Re: Two billion records ok? |