Postgres Pro
Downloads
Home   >   mailing lists

Removing OIDs - Mailing list pgsql-admin

From Sam Barnett-Cormack
Subject Removing OIDs
Date
Msg-id Pine.LNX.4.50.0402031152460.32086-100000@short.lancs.ac.uk
Whole thread Raw
Responses Re: Removing OIDs  (Marek Lewczuk <newsy@lewczuk.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: JM
Date:
Subject: OT: test
Next
From: Marek Lewczuk
Date:
Subject: Re: Removing OIDs