Re: PostgreSQL using the wrong Index - Mailing list pgsql-performance

From Wei Weng
Subject Re: PostgreSQL using the wrong Index
Date
Msg-id 42ADAA92.7000200@kencast.com
Whole thread Raw
In response to Re: PostgreSQL using the wrong Index  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tom Lane wrote:
>
>
> This was just covered in excruciating detail yesterday ...
>
> You need to write
>     order by symbol desc, time desc limit 1
> to get the planner to recognize the connection to the sort order
> of this index.  Since you're only selecting one value of symbol,
> the actual output doesn't change.
>
Is this the right behavior (not a bug)? Is postgresql planning on changing
this soon?


Thanks

Wei

pgsql-performance by date:

Previous
From: Alex Stapleton
Date:
Subject: Re: PostgreSQL using the wrong Index
Next
From: Bruno Wolff III
Date:
Subject: Re: Index ot being used