On Sun, Dec 14, 2008 at 4:15 PM, David Rowley <dgrow...@gmail.com> wrote: > The index does not know if the row is dead or alive to the current > transaction. This is only known by the heap. So for your example query > to execute, it may be possible to scan the index but the heap will > need to be checked to see if the row is alive or dead.
There are some plans to use the new visibility map feature (coming in 8.4) to allow index only lookups under certain conditions. That wouldn't happen until 8.5 at the earliest however. merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
