On 2019-Aug-06, Tom Lane wrote:
> My estimate is that in any one development
> cycle we'll commit order-of-a-couple-dozen patches that consume new OIDs.
> In that context you'd be just unlucky to get an OID suggestion that
> doesn't have dozens to hundreds of free OIDs after it. (If the rate
> of manually-assigned-OID consumption were any faster than that, we'd
> have filled up the 1-10K space long since.)
If we ever get to a point where this is a real problem in one cycle, we
can just run the renumber_oids script before the end of the cycle.
So IMO what we have now is more than sufficient for the time being.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services