RE: Re: 4 billion record limit?

Andrew Snow <als@fl.net.au>

From: "Andrew Snow" <als@fl.net.au>
To: "Pgsql-General@Postgresql. Org" <pgsql-general@postgresql.org>
Date: 2000-07-29T04:25:59Z
Lists: pgsql-general, pgsql-novice
> > That's an excellent point, especially considering that *sequences* use
> > an integer to hold their max_value, which is by default 2,147,483,647.
> > You cannot go larger than that, either.  I guess it's constrained to be
> > positive.  So OIDs give you more potential unique values than sequences,
> > far as I can tell.

What about postgres' int8 type which holds up to +/- 9 billion billion or
something.


- Andrew