ruth'
See the movie - 'Syriana'
--- On Sun, 7/12/09, Brent Wood wrote:
> From: Brent Wood
> Subject: Re: [GENERAL] indexes on float8 vs integer
> To: gear...@sbcglobal.net
> Date: Sunday, July 12, 2009, 9:10 PM
> You might look at UMN mapserver or
> Geoserver to p
store the first data.
Dennis Gearon
--- On Sun, 7/12/09, Brent Wood wrote:
> From: Brent Wood
> Subject: Re: [GENERAL] indexes on float8 vs integer
> To: gear...@sbcglobal.net
> Cc: pgsql-general@postgresql.org
> Date: Sunday, July 12, 2009, 1:52 PM
> Hi Dennis,
>
> Is t
Hi Dennis,
Is there any reason you are not using PostGIS to store the values as point
geometries & use a spatial (GIST) index on them? I have tables with hundreds of
millions of point features which work well. On disk data volume is not really
worth optimising for with such systems, i suggest f
On Sat, Jul 11, 2009 at 10:15 PM, Dennis Gearon wrote:
>
> Anyone got any insight or experience in the speed and size of indexes on
> Integer(4 byte) vs float (8byte). For a project that I'm on, I'm
> contemplating using an integer for:
>
> Latitude
> Longitude
>
> In a huge, publically s
Anyone got any insight or experience in the speed and size of indexes on
Integer(4 byte) vs float (8byte). For a project that I'm on, I'm contemplating
using an integer for:
Latitude
Longitude
In a huge, publically searchable table.
In the INSERTS, the representation would be equal