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

From Chris Bitmead
Subject Re: 4 billion record limit?
Date
Msg-id 397CE6FC.E86FD0D6@nimrod.itg.telecom.com.au
Whole thread Raw
In response to 4 billion record limit?  (Paul Caskey <paul@nmxs.com>)
Responses Re: 4 billion record limit?
List 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 by date:

Previous
From: Joseph Shraibman
Date:
Subject: Re: 4 billion record limit?
Next
From: Dave Burbidge
Date:
Subject: RE: PostgreSQL, ODBC, Access