Re: Disallow unique index on system columns - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Disallow unique index on system columns
Date
Msg-id 10338.1460685373@sss.pgh.pa.us
Whole thread Raw
In response to Re: Disallow unique index on system columns  (David Rowley <david.rowley@2ndquadrant.com>)
Responses Re: Disallow unique index on system columns  (David Rowley <david.rowley@2ndquadrant.com>)
List pgsql-hackers
David Rowley <david.rowley@2ndquadrant.com> writes:
> On 15 April 2016 at 13:30, Andres Freund <andres@anarazel.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



pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: Disallow unique index on system columns
Next
From: Andres Freund
Date:
Subject: Re: [COMMITTERS] pgsql: Allow Pin/UnpinBuffer to operate in a lockfree manner.