ordering op for WHERE

From: yamt(at)mwd(dot)biglobe(dot)ne(dot)jp (YAMAMOTO Takashi)
To: pgsql-hackers(at)postgresql(dot)org
Subject: ordering op for WHERE
Date: 2011-12-28 03:48:02
Message-ID: 20111228034802.B866914A2C8@mail.netbsd.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Brar Piening 2011-12-28 04:09:15 Re: Review of VS 2010 support patches
Previous Message Simon Riggs 2011-12-28 02:54:02 Re: 16-bit page checksums for 9.2