RE: Re: 4 billion record limit?

Поиск
Список
Период
Сортировка
От Andrew Snow
Тема RE: Re: 4 billion record limit?
Дата
Msg-id NHEALMDKDACEIPBNOOOCGEPHCIAA.als@fl.net.au
обсуждение исходный текст
Ответ на Re: Re: 4 billion record limit?  ("Ross J. Reedstrom" <reedstrm@rice.edu>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Hopefully simple date conversion question
Следующее
От: Tom Lane
Дата:
Сообщение: Hmm ... shouldn't path_distance be MIN distance not MAX distance?