| From: | Joseph Shraibman <jks(at)selectacast(dot)net> |
|---|---|
| To: | Paul Caskey <paul(at)nmxs(dot)com> |
| Cc: | Postgres Users <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: 4 billion record limit? |
| Date: | 2000-07-25 01:10:58 |
| Message-ID: | 397CE922.D4C7045@selectacast.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-novice |
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(at)nmxs(dot)com Software Engineer
> New Mexico Software 5041 Indian School NE Albuquerque, NM 87110
> --
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Burbidge | 2000-07-25 01:24:59 | RE: PostgreSQL, ODBC, Access |
| Previous Message | Chris Bitmead | 2000-07-25 01:01:48 | Re: 4 billion record limit? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas SMETS | 2000-07-25 02:02:36 | [Fwd: inserting integer in Table] |
| Previous Message | Chris Bitmead | 2000-07-25 01:01:48 | Re: 4 billion record limit? |