| From: | Chris Bitmead <chrisb(at)nimrod(dot)itg(dot)telstra(dot)com(dot)au> |
|---|---|
| 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:01:48 |
| Message-ID: | 397CE6FC.E86FD0D6@nimrod.itg.telecom.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-novice |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joseph Shraibman | 2000-07-25 01:10:58 | Re: 4 billion record limit? |
| Previous Message | Scott Holmes | 2000-07-25 00:18:39 | Subscripts in select statements |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joseph Shraibman | 2000-07-25 01:10:58 | Re: 4 billion record limit? |
| Previous Message | Desmond Coughlan | 2000-07-24 22:44:20 | Re: Finding Tables |