postgres: Add indices to keep track of objects with a raw_manifest

They should be a rare occurence, so adding these indices allows us to count
and enumerate them without expensive full table scans.