Re: cube operations slower than geo_distance() on production server

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: "Mark Stosberg" <mark@xxxxxxxxxxxxxxx>
Subject: Re: cube operations slower than geo_distance() on production server
From: "Merlin Moncure" <mmoncure@xxxxxxxxx>
Date: Mon, 12 Feb 2007 14:05:18 -0500
Cc: pgsql-performance@xxxxxxxxxxxxxx
In-reply-to: <b42b73150702121103l297b690w84dde8ef9ef8d2f1@xxxxxxxxxxxxxx>
References: <eqiht3$2fvu$1@xxxxxxxxxxxx> <b42b73150702091731x57996613hb50af0296007436c@xxxxxxxxxxxxxx> <eqq3k3$1mpu$1@xxxxxxxxxxxx> <b42b73150702121103l297b690w84dde8ef9ef8d2f1@xxxxxxxxxxxxxx>

On 2/12/07, Merlin Moncure <mmoncure@xxxxxxxxx> 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

References:
- cube operations slower than geo_distance() on production server
  - From: Mark Stosberg
- Re: cube operations slower than geo_distance() on production server
  - From: Merlin Moncure
- Re: cube operations slower than geo_distance() on production server
  - From: Mark Stosberg
- Re: cube operations slower than geo_distance() on production server
  - From: Merlin Moncure

Prev by Date: Re: cube operations slower than geo_distance() on production server
Next by Date: Re: cube operations slower than geo_distance() on production server
Previous by thread: Re: cube operations slower than geo_distance() on production server
Next by thread: Re: cube operations slower than geo_distance() on production server
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux