>>>>> "dan" == "dan" <dan(dot)boeriu(at)roost(dot)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)