4 billion record limit? - Mailing list pgsql-general

From Paul Caskey
Subject 4 billion record limit?
Date
Msg-id 397CC53F.FCC0533B@nmxs.com
Whole thread Raw
List pgsql-general
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?

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

--
Paul Caskey        paul@nmxs.com        Software Engineer
New Mexico Software    5041 Indian School NE    Albuquerque, NM 87110
--

pgsql-general by date:

Previous
From: "Jens P. Elsner"
Date:
Subject: Re: Migrating from Sybase
Next
From: Jesus Aneiros
Date:
Subject: RULES on PostgreSQL