Yeah, it has to rebuild the indexes since the physical locations of everything change during a vacuum full. But doing that on the user table will not help - the oid stays the same and that is the only link (an indirect one at that) to the problem comment data. Doing it on the catalog might help…never tried myself, vacuum full or a independent reindex.