32bit OID wrap around concerns - Mailing list pgsql-hackers

From Qingqing Zhou
Subject 32bit OID wrap around concerns
Date
Msg-id CAJjS0u3mHZ-DekdkR5ETULQ3ZNNGTo_md=Q-DapR_+=b_Z+YCg@mail.gmail.com
Whole thread Raw
Responses Re: 32bit OID wrap around concerns
List pgsql-hackers
One scenario is to use an oid to identify a toast value. As the oid generation is mono increased within a database instance, it can gets wrap around after 2^32 generations. After that:
1. GetNewOidWithIndex() could gets unbounded performance as it needs to by pass already in use values of its own.  
2. These by-passed oids are actually usable by other toast indices, but are wasted. This can lead to further aggravated OID wrap around. 
 
Do we think above scenario is something we shall worry about? Especially for large databases. 
 
Thanks,
Qingqing
 

pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Bug in pg_dump
Next
From: Alvaro Herrera
Date:
Subject: Re: 32bit OID wrap around concerns