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 2268.1149805181@sss.pgh.pa.us
Whole thread Raw
In response to Re: Why date index is not used  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-performance
"Jim C. Nasby" <jnasby@pervasive.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

pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Why date index is not used
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: Regarding pg_dump utility