Re: Solving the OID-collision problem

From: Andrew - Supernews <andrew+nonews(at)supernews(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Solving the OID-collision problem
Date: 2005-08-10 18:59:47
Message-ID: slrndfkjl3.bj3.andrew+nonews@trinity.supernews.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 2005-08-10, Greg Stark <gsstark(at)mit(dot)edu> wrote:
> But with no OIDs on user tables it must take a really long time for this to
> happen. I mean, even if you have thousands of tables you would have to go
> through thousands (many thousands even) of dump/reload cycles before you push
> oid to 4 billion.

Don't forget TOAST tables, they use oids too.

--
Andrew, Supernews
http://www.supernews.com - individual and corporate NNTP services

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Matt Miller 2005-08-10 19:17:16 Re: [GENERAL] Testing of MVCC
Previous Message Greg Stark 2005-08-10 18:42:16 Re: Solving the OID-collision problem