Discussion:
Removing OIDs
(too old to reply)
Sam Barnett-Cormack
2004-02-03 11:55:41 UTC
Permalink
Is there any way to remove OIDs from an existing table, or even a whole
database? I never use the damn things and my database is big, so I'd
like to do anything I can to shrink it.

Also, are there any performance implications to this?

I'm currently using 7.3.4, but will shortly be moving to 7.4
--
Sam Barnett-Cormack
Software Developer | Student of Physics & Maths
UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
Marek Lewczuk
2004-02-03 13:06:41 UTC
Permalink
Post by Sam Barnett-Cormack
Is there any way to remove OIDs from an existing table, or even a whole
database? I never use the damn things and my database is big, so I'd
like to do anything I can to shrink it.
Also, are there any performance implications to this?
I'm currently using 7.3.4, but will shortly be moving to 7.4
ALTER TABLE [ ONLY ] name [ * ] SET WITHOUT OIDS

ML.



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly

Loading...