Postgres Pro
Downloads
Home   >   mailing lists

Re: <= Index. - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: <= Index.
Date
Msg-id Pine.LNX.4.30.0203310206100.683-100000@peter.localdomain
Whole thread Raw
In response to <= Index.  ("Greg Sikorski" <gte@atomicrevs.demon.co.uk>)
List pgsql-admin
Tree view 
Greg Sikorski writes:

> How come this Index isn't being used in the situation below?

There's no point in using an index if you're retrieving nearly the entire
table.

--
Peter Eisentraut   peter_e@gmx.net

pgsql-admin by date:

Previous
From: "Greg Sikorski"
Date:
Subject: <= Index.
Next
From: "Greg Sikorski"
Date:
Subject: Re: <= Index.