Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Thu, 08 Jun 2006 15:20:55 -0400
"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
- Follow-Ups:
- Re: Why date index is not used
- From: Andrus
- Re: Why date index is not used
- From: Jim C. Nasby
- Re: Why date index is not used
- References:
- Why date index is not used
- From: Andrus
- Why date index is not used
- Prev by Date: Re: Why date index is not used
- Next by Date: Re: Why date index is not used
- Previous by thread: Re: Why date index is not used
- Next by thread: Re: Why date index is not used
- Indexes: