Gavin Love <gavin@xxxxxxxxxxxxxx> 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 gist | circle_ops | <<(circle,circle) gist | circle_ops | &<(circle,circle) gist | circle_ops | &>(circle,circle) gist | circle_ops | >>(circle,circle) gist | circle_ops | <@(circle,circle) gist | circle_ops | @>(circle,circle) gist | circle_ops | ~=(circle,circle) gist | circle_ops | &&(circle,circle) gist | circle_ops | |>>(circle,circle) gist | circle_ops | <<|(circle,circle) gist | circle_ops | &<|(circle,circle) gist | circle_ops | |&>(circle,circle) gist | circle_ops | @(circle,circle) gist | circle_ops | ~(circle,circle) (this is extracted from the output of the query shown in 8.4 docs section 11.9). So, circle @> point is out of luck. Try using a zero- or small-radius circle on the right. regards, tom lane -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
