On Tue, May 19, 2020 at 12:17 AM Tory M Blue <tmb...@gmail.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
