ordering op for WHERE
Started by Nonameabout 14 years ago2 messages
hi,
does it make sense to teach the planner (and the executor?) use an ordering op
to optimize queries like the following?
select * from t where a <-> 1000 < 10
YAMAMOTO Takashi
Re: ordering op for WHERE
On Tue, Dec 27, 2011 at 10:48 PM, YAMAMOTO Takashi
<yamt@mwd.biglobe.ne.jp> wrote:
does it make sense to teach the planner (and the executor?) use an ordering op
to optimize queries like the following?select * from t where a <-> 1000 < 10
Seems useful to me. I'm not sure how hard it is, though.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company