Postgres Pro
Downloads
Home   >   mailing lists

Re: index scan with index cond on first column doesn't - Mailing list pgsql-general

From Stephan Szabo
Subject Re: index scan with index cond on first column doesn't
Date
Msg-id 20030213113156.T47380-100000@megazone23.bigpanda.com
Whole thread Raw
In response to index scan with index cond on first column doesn't recognize sort order of second column  (Greg Stark <gsstark@mit.edu>)
Responses Re: index scan with index cond on first column doesn't recognize sort order of second column  (Greg Stark <gsstark@mit.edu>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Emmanuel Charpentier
Date:
Subject: Aggregates with non-commutative transition functions
Next
From: Egyud Csaba
Date:
Subject: Fw: set returning functions in v7.3