From: | Amir Khawaja <amir(at)gorebels(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | OIDS and its limitations |
Date: | 2004-01-10 00:52:04 |
Message-ID: | N0ILb.56099$m83.27524@fed1read01 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Everyone,
I have a rather trivial (I hope) question about OID types and
PostgreSQL. Since PostgreSQL creates tables "WITH OIDS" by default, I'm
wondering if it is bad practice to allow the default behaviour. For
example, if I have a database with 60+ tables (all tables have their own
PK that is not of type OID) and all of them have an OID field created by
PostgreSQL by default, will this be problematic in the long run? For
example, if I have 30 tables with records greater than 500,000, will
PostgreSQL choke?
Thank you in advance for any information you can provide!
--
Amir Khawaja.
----------------------------------
Rules are written for those who lack the ability to truly reason, But
for those who can, the rules become nothing more than guidelines, And
live their lives governed not by rules but by reason.
- James McGuigan
From | Date | Subject | |
---|---|---|---|
Next Message | Kragen Sitaker | 2004-01-10 00:52:49 | Re: ERROR: Cannot insert a duplicate key into unique index pg_class_relname_nsp_index |
Previous Message | Tom Lane | 2004-01-10 00:50:00 | Re: Postgres planner bug in 7.3.x and 7.4.1 ? |