Re: remove pg_class.relhaspkey - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: remove pg_class.relhaspkey
Date
Msg-id 20180314054738.GC16179@paquier.xyz
Whole thread Raw
In response to Re: remove pg_class.relhaspkey  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Responses Re: remove pg_class.relhaspkey  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List 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

Attachment

pgsql-hackers by date:

Previous
From: Pavan Deolasee
Date:
Subject: Re: Faster inserts with mostly-monotonically increasing values
Next
From: Amit Langote
Date:
Subject: Re: inserts into partitioned table may cause crash