Rob Sargent <robjsarg...@gmail.com> writes: > Should I be? I would have thought the pk would have been chosen v. > function index?
If I'm reading this correctly, the PK index contains uuids while
the fpv index contains float4s, meaning the latter is probably half
the size. So scanning it is a lot cheaper, at least according to
the planner's cost model.
regards, tom lane
