Re: Why date index is not used

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Andrus" <eetasoft(at)online(dot)ee>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Why date index is not used
Date: 2006-06-08 19:20:55
Message-ID: 196.1149794455@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Andrus" <eetasoft(at)online(dot)ee> writes:
> Why Postgres 8.1 does not use makse_kuupaev_idx index in the following query
> ?

Because it doesn't help --- the system still has to do the sort.
You'd need a two-column index on both of the ORDER BY columns to avoid
sorting.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Dave Dutcher 2006-06-08 20:07:42 Re: Why date index is not used
Previous Message Tomas Vondra 2006-06-08 19:20:21 Re: Why date index is not used