Re: 4 billion record limit? - Mailing list pgsql-general

From Tom Lane
Subject Re: 4 billion record limit?
Date
Msg-id 28191.964666957@sss.pgh.pa.us
Whole thread Raw
In response to Re: 4 billion record limit?  (Paul Caskey <paul@nmxs.com>)
Responses Re: 4 billion record limit?  (Bradley Kieser <brad@kieser.net>)
List pgsql-general
Paul Caskey <paul@nmxs.com> writes:
>> No doubt about it, you're likely to get a few "duplicate key" errors and
>> stuff like that.  I'm just observing that it's not likely to be a
>> complete catastrophe, especially not if you don't rely on OIDs to be
>> unique in your user tables.

> I don't rely on OID uniqueness, but I assumed Postgres does!

Only in the system tables, and not even in all of them.  From the
system's point of view, there's no real need to assign OIDs to
user table rows at all --- so another possible answer is not to
do that, unless the user requests it.

            regards, tom lane

pgsql-general by date:

Previous
From: Paul Caskey
Date:
Subject: Re: 4 billion record limit?
Next
From: kumar1@home.com (Prasanth A. Kumar)
Date:
Subject: Re: 4 billion record limit?