On Wed, 2007-10-17 at 18:13 +0100, Heikki Linnakangas wrote:
> > The test script you
> > showed cheats six-ways-from-Sunday to cause an OID collision that would
> > never happen in practice. The only case where it would really happen
> > is if a table that has existed for a long time (~ 2^32 OID creations)
> > gets dropped and then you're unlucky enough to recycle that exact OID
> > before the next checkpoint --- and then crash before the checkpoint.
>
> Yeah, it's unlikely to happen, but the consequences are horrible.
When is this going to happen?
We'd need to insert 2^32 toast chunks, which is >4 TB of data, or insert
2^32 large objects, or create 2^32 tables, or any combination of the
above all within one checkpoint duration *and* exactly hit the exact
same relation.
That's a weird and huge application, a very fast server and an unlucky
DBA to hit the exact OID to be reused and then have the server crash so
we'll ever notice.
-- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com