On Tue, May 19, 2020 at 12:17 AM Tory M Blue <tmblue(at)gmail(dot)com> wrote:
>
> The db is only 2TB, these tables are about 50% of the DB.
>
>
> Just wondering what I can boost to give me some elevated temp performance
> for what I would think would be a fairly quick operation.
>
> Give this query more work_mem? Mine are set pretty low, based on previous
> performance notes, this is a 9.5 server.
>
> Thanks
> Tory
>
The command i'm using is
ALTER TABLE tablename SET WITHOUT OIDS;
Would a drop column oid be better?
Tory