David Rowley <david(dot)rowley(at)2ndquadrant(dot)com> writes:
> On 15 April 2016 at 13:30, Andres Freund <andres(at)anarazel(dot)de> wrote:
>> What'd be the point of indexing ctid, and why would it be correct?
>> Wouldn't, hm, HOT break it?
> I don't personally see the point.
An index on ctid is useless by definition: if you know the ctid of
a tuple, you can just go get it, never mind the index.
> Is it worth making some changes to pg_dump to skip such indexes?
No.
regards, tom lane