On Thu, 2006-05-04 at 16:06, Jim C. Nasby wrote: > On Thu, May 04, 2006 at 10:58:24PM +0200, Leif B. Kristensen wrote: > > I know that there is one hard-wired limit due to the OID wrap-around > > problem, at 2^31 commands in one transaction. But the practical limit > > due to hardware resources is probably much lower. > > This has nothing to do with OIDs, and in fact I don't believe there's > any intrinsic reason why you couldn't insert more than 2B records in a > table with OIDs so long as you don't have a unique index defined on it. But there is a truth there. Most people are far more likely to be limited by their machine's hardware than by the database at this point. Of course, SOMEONE will find a way to hit the limit.
