Re: index scan with index cond on first column doesn't

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: index scan with index cond on first column doesn't
Date: 2003-02-13 19:34:12
Message-ID: 20030213113156.T47380-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On 13 Feb 2003, Greg Stark wrote:

> Here's a corner case where the optimizer is doing a redundant sort. I'm not
> sure if I'm doing something wrong or if it's just something the optimizer
> doesn't notice.

I'm guessing that it doesn't realize that in this case the sort is
redundant since I think it's only necessarily redundant for = singlevalue
with no ors.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brandon Craig Rhodes 2003-02-13 19:50:27 Re: arrays and pl/pgsql?
Previous Message Emmanuel Charpentier 2003-02-13 19:32:36 Aggregates with non-commutative transition functions