Re: 4 billion record limit?

Поиск
Список
Период
Сортировка
От Chris Bitmead
Тема Re: 4 billion record limit?
Дата
Msg-id 397CE6FC.E86FD0D6@nimrod.itg.telecom.com.au
обсуждение исходный текст
Ответ на 4 billion record limit?  (Paul Caskey <paul@nmxs.com>)
Ответы Re: 4 billion record limit?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Paul Caskey wrote:
>
> PostgreSQL uses a hidden "oid" field to uniquely identify all records
> across all tables in all databases on a particular server.  On my
> platform, this number is an unsigned 32-bit integer, meaning 0 to about 4
> billion.
>
> 1. This implies a hard limit of 4 billion records on a server, right?

Basically, yes.

> 2. When I delete records, are those oids ever reused?

No.

The real solution is to support 64 bit oids, but that has not been done
yet.

В списке pgsql-general по дате отправления:

Предыдущее
От: Joseph Shraibman
Дата:
Сообщение: Re: 4 billion record limit?
Следующее
От: Dave Burbidge
Дата:
Сообщение: RE: PostgreSQL, ODBC, Access