Postgres Pro
Downloads
Home   >   mailing lists

Re: Why date index is not used - Mailing list pgsql-performance

From Tom Lane
Subject Re: Why date index is not used
Date
Msg-id 196.1149794455@sss.pgh.pa.us
Whole thread Raw
In response to Why date index is not used  ("Andrus" <eetasoft@online.ee>)
Responses Re: Why date index is not used
List pgsql-performance
Tree view 
"Andrus" <eetasoft@online.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

pgsql-performance by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Why date index is not used
Next
From: "Dave Dutcher"
Date:
Subject: Re: Why date index is not used