4 billion record limit?
Paul Caskey <paul@nmxs.com>
From: Paul Caskey <paul@nmxs.com>
To: Postgres Users <pgsql-general@postgresql.org>
Date: 2000-07-24T22:37:51Z
Lists: pgsql-general, pgsql-novice
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 --