Re: pg_migrator progress - Mailing list pgsql-hackers

From Gregory Stark
Subject Re: pg_migrator progress
Date
Msg-id 878wo321r5.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: pg_migrator progress  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_migrator progress  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> writes:

> No, but this would just be the same situation that prevails after
> OID-counter wraparound, so I don't see a compelling need for us to
> change the OID counter in the new DB.  If the user has done the Proper
> Things (ie, made unique indexes on his OIDs) then it won't matter.
> If he didn't, his old DB was a time bomb anyway.

Well it was a time bomb but it wasn't necessarily about to go off... He may
very well know how close or far he is from oid wraparound and have contingency
plans in place. 

Also I wonder about the performance of skipping over thousands or even
millions of OIDs for something like a toast table.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication
support!


pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: SIMILAR TO bug?
Next
From: Alvaro Herrera
Date:
Subject: Re: SIMILAR TO bug?