OIDS and its limitations
От | Amir Khawaja |
---|---|
Тема | OIDS and its limitations |
Дата | |
Msg-id | N0ILb.56099$m83.27524@fed1read01 обсуждение исходный текст |
Ответы |
Re: OIDS and its limitations
Re: OIDS and its limitations |
Список | 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
В списке pgsql-general по дате отправления: