Re: Huge tables, trying to delete OID's taking 6+hours per table

[Tom Lane <tgl@xxxxxxxxxxxxx>]

Tory M Blue <tmblue@xxxxxxxxx> writes:
> The command i'm using is
> ALTER TABLE tablename SET WITHOUT OIDS;
> Would a drop column oid be better?

Unfortunately, you're kind of stuck.  OIDs are not like regular columns
(at least before v12) --- they are integrated into the tuple header in
a hackish way, and so there's no way to get rid of them without a table
rewrite.

			regards, tom lane