Tom Lane wrote:
Gavin Love writes:
I seem to be unable to get postgres to use a gist index we have on a
circle data type.
SELECT id FROM tradesmen_profiles WHERE tradesmen_profiles.work_area
@> point(0.0548691728419,51.5404384172);
So far as I can see, the member operators of gist circle_
Gavin Love writes:
> I seem to be unable to get postgres to use a gist index we have on a
> circle data type.
> SELECT id FROM tradesmen_profiles WHERE tradesmen_profiles.work_area
> @> point(0.0548691728419,51.5404384172);
So far as I can see, the member operators of gist circle_ops are
g
On Mon, 24 Aug 2009, Gavin Love wrote:
I seem to be unable to get postgres to use a gist index we have on a circle
data type.
QUERY PLAN
---
Seq Scan on tradesmen_profiles (cos
Hey,
I seem to be unable to get postgres to use a gist index we have on a
circle data type.
Table "public.tradesmen_profiles"
Column |Type | Modifiers
---+-+---
id
