Postgres Pro
Downloads
Home   >   mailing lists

Re: ordering op for WHERE - Mailing list pgsql-hackers

From Robert Haas
Subject Re: ordering op for WHERE
Date
Msg-id CA+TgmoYv7_4Trv=wJzJAu=NTomFo50G-K72JE6bH7n0u4YOcNA@mail.gmail.com
Whole thread Raw
In response to ordering op for WHERE  (yamt@mwd.biglobe.ne.jp (YAMAMOTO Takashi))
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Add SPI results constants available for PL/*
Next
From: Andrew Dunstan
Date:
Subject: Re: Re: [COMMITTERS] pgsql: pg_regress: Replace exit_nicely() with exit() plus atexit() hook