Re: 4 billion record limit?

I'm not too familiar with the postgres internals, but the oid tells
postgres where the row is stored in the filesystem. So by the time
you've run out of oid's you've probably run out of space on your
filesystem.

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?
>
> 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
> --