On Tue, May 19, 2020 at 6:40 AM Tom Lane <t...@sss.pgh.pa.us> wrote: > Tory M Blue <tmb...@gmail.com> 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 >
Poop :) kind of figured that, so it's just painful. But I guess if it's doing a table rewrite, is there any configuration params I could boost to help it? Shared_buffers, give it more, work mem, maintenance mem, temp buffers anything you can think of? Thanks again Tom Tory
