Postgres Pro
Downloads
Home   >   mailing lists

Re: Huge tables, trying to delete OID's taking 6+hours per table - Mailing list pgsql-general

From Tory M Blue
Subject Re: Huge tables, trying to delete OID's taking 6+hours per table
Date
Msg-id CAEaSS0Yzm0F9w+tWPOX5OHWRq44-s1Tn0kKsEV0hjniYeWDC_A@mail.gmail.com
Whole thread Raw
In response to Huge tables, trying to delete OID's taking 6+hours per table  (Tory M Blue <tmblue@gmail.com>)
Responses Re: Huge tables, trying to delete OID's taking 6+hours per table  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view


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

pgsql-general by date:

Previous
From: Anders Bøgh Bruun
Date:
Subject: Logical replication troubles
Next
From: "Andrus"
Date:
Subject: Re: Hot and PITR backups in same server