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