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

From Andrew Snow
Subject RE: Re: 4 billion record limit?
Date
Msg-id NHEALMDKDACEIPBNOOOCGEPHCIAA.als@fl.net.au
Whole thread Raw
In response to Re: Re: 4 billion record limit?  ("Ross J. Reedstrom" <reedstrm@rice.edu>)
List pgsql-general
> > 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



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Hopefully simple date conversion question
Next
From: Tom Lane
Date:
Subject: Hmm ... shouldn't path_distance be MIN distance not MAX distance?