Postgres Pro
Downloads
Home   >   mailing lists

Re: cube operations slower than geo_distance() on production server - Mailing list pgsql-performance

From Merlin Moncure
Subject Re: cube operations slower than geo_distance() on production server
Date
Msg-id b42b73150702121105y34aab219v3a58f068cb72b5c3@mail.gmail.com
Whole thread Raw
In response to Re: cube operations slower than geo_distance() on production server  ("Merlin Moncure" <mmoncure@gmail.com>)
List pgsql-performance
Tree view 
On 2/12/07, Merlin Moncure <mmoncure@gmail.com> wrote:
>  cube_distance(pets.earth_coords, earth_coords ) / 1609.344 AS RADIUS

this should read:
cube_distance(pets.earth_coords, zipcodes.earth_coords ) / 1609.344 AS RADIUS

merlin

pgsql-performance by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: cube operations slower than geo_distance() on production server
Next
From: Mark Stosberg
Date:
Subject: Re: cube operations slower than geo_distance() on production server