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