Re: Disallow unique index on system columns

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Disallow unique index on system columns
Дата
Msg-id 10338.1460685373@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Disallow unique index on system columns  (David Rowley <david.rowley@2ndquadrant.com>)
Ответы Re: Disallow unique index on system columns  (David Rowley <david.rowley@2ndquadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: Disallow unique index on system columns
Следующее
От: Andres Freund
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Allow Pin/UnpinBuffer to operate in a lockfree manner.