Re: PostgreSQL using the wrong Index

From: Wei Weng <wweng(at)kencast(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Alex Stapleton <alexs(at)advfn(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: PostgreSQL using the wrong Index
Date: 2005-06-13 15:47:30
Message-ID: 42ADAA92.7000200@kencast.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Bruno Wolff III 2005-06-13 15:48:34 Re: Index ot being used
Previous Message Alex Stapleton 2005-06-13 15:20:19 Re: PostgreSQL using the wrong Index