>>>>> "dan" == "dan" <dan.boe...@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) -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
