Re: 4 billion record limit?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 4 billion record limit?
Дата
Msg-id 28191.964666957@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: 4 billion record limit?  (Paul Caskey <paul@nmxs.com>)
Ответы Re: 4 billion record limit?  (Bradley Kieser <brad@kieser.net>)
Список 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 по дате отправления:

Предыдущее
От: Paul Caskey
Дата:
Сообщение: Re: 4 billion record limit?
Следующее
От: kumar1@home.com (Prasanth A. Kumar)
Дата:
Сообщение: Re: 4 billion record limit?