Re: GPS positions - Mailing list pgsql-novice

From Frank Bax
Subject Re: GPS positions
Date
Msg-id BLU0-SMTP430959C0EA1E3DA3A612A1ACE70@phx.gbl
Whole thread Raw
In response to Re: GPS positions  (Nathaniel Trellice <naptrel@yahoo.co.uk>)
List pgsql-novice
Nathaniel Trellice wrote:
> Hi Frank,
>
> It all depends on how much data you'll be storing,
> what kind of distances you'll be querying for, and
> how accurate you need to be.


Thanks Nathaniel for the in-depth explanations.  When I started working
on calculations; I soon realized why storing points in radians makes
more sense!

Database tables will start with hundreds of rows; might grow to thousands.

Frank

pgsql-novice by date:

Previous
From: Sean Davis
Date:
Subject: Re: Sphinx indexing problem
Next
From: "Machiel Richards"
Date:
Subject: Adding of indexes, best practises