Re: Why date index is not used

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

"Jim C. Nasby" <jnasby(at)pervasive(dot)com> writes:
> And even then you better have a pretty high correlation on the first
> column, otherwise you'll still get a seqscan.

Not with the LIMIT. (If he were fetching the whole table, very possibly
the sort would be the right plan anyway.)

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Christopher Kings-Lynne 2006-06-09 01:16:35 Re: Regarding pg_dump utility
Previous Message Jim C. Nasby 2006-06-08 21:57:45 Re: Why date index is not used