Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #5113: Postgres not scanning indexes - Mailing list pgsql-bugs

From Andrew Gierth
Subject Re: BUG #5113: Postgres not scanning indexes
Date
Msg-id 87hbu2zwek.fsf@news-spur.riddles.org.uk
Whole thread Raw
In response to BUG #5113: Postgres not scanning indexes  ("dan" <dan.boeriu@roost.com>)
List pgsql-bugs
Tree view 
>>>>> "dan" == "dan"  <dan.boeriu@roost.com> writes:

 dan> I expect the explain to say index scan; instead it says table scan.
 dan> The index has ALL the info I need

It may have all the info _you_ need, but what it doesn't have is all the
info that _postgres_ needs; specifically it doesn't contain enough row
visibility info for index-only scans to be possible without consulting
the table.

--
Andrew (irc:RhodiumToad)

pgsql-bugs by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: BUG #5113: Postgres not scanning indexes
Next
From: Heikki Linnakangas
Date:
Subject: Re: Kerberos authentication, Active Directory, and PostgreSQL