Re: remove pg_class.relhaspkey

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: remove pg_class.relhaspkey
Дата
Msg-id 20180314054738.GC16179@paquier.xyz
обсуждение исходный текст
Ответ на Re: remove pg_class.relhaspkey  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Ответы Re: remove pg_class.relhaspkey  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Список pgsql-hackers
On Sat, Mar 10, 2018 at 01:52:56PM +0100, Tomas Vondra wrote:
> I agree with this sentiment - I don't think those flags are particularly
> helpful for client applications, and would vote +1 for removal.

OK, so I can see that we are moving to a consensus here.

> For the other flags we would probably need to test what impact would it
> have (e.g. table with no indexes, many indexes on other tables, and
> something calling get_relation_info a lot). But this patch proposes to
> remove only relhaspkey.

Yes, you are right here.  Peter, would you do that within this commit
fest or not?  As we are half-way through the commit fest, we could also
cut the apple in half and just remove relhaspkey for now as that's a
no-brainer.  So I would suggest to just do the latter and consider this
patch as done.

Attached is a rebased patch, there were some conflicts in pg_class.h by
the way.
--
Michael

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Pavan Deolasee
Дата:
Сообщение: Re: Faster inserts with mostly-monotonically increasing values
Следующее
От: Amit Langote
Дата:
Сообщение: Re: inserts into partitioned table may cause crash