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

2020-05-20 Thread Ron
On 5/20/20 11:22 AM, Tory M Blue wrote: On Tue, May 19, 2020 at 10:06 AM Ron > wrote: On 5/19/20 11:51 AM, Tory M Blue wrote: On Tue, May 19, 2020 at 6:40 AM Tom Lane mailto:t...@sss.pgh.pa.us>> wrote: Tory M Blue mailto:tmb...@gmail.com>> w

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

2020-05-20 Thread Tory M Blue
On Tue, May 19, 2020 at 10:06 AM Ron wrote: > On 5/19/20 11:51 AM, Tory M Blue wrote: > > > > On Tue, May 19, 2020 at 6:40 AM Tom Lane wrote: > >> Tory M Blue writes: >> > The command i'm using is >> > ALTER TABLE tablename SET WITHOUT OIDS; >> > Would a drop column oid be better? >> >> Unfortu

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

2020-05-19 Thread Ron
On 5/19/20 11:51 AM, Tory M Blue wrote: On Tue, May 19, 2020 at 6:40 AM Tom Lane > wrote: Tory M Blue mailto:tmb...@gmail.com>> writes: > The command i'm using is > ALTER TABLE tablename SET WITHOUT OIDS; > Would a drop column oid be better? Unf

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

2020-05-19 Thread Tory M Blue
On Tue, May 19, 2020 at 6:40 AM Tom Lane wrote: > Tory M Blue 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 i

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

2020-05-19 Thread Tom Lane
Tory M Blue 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'

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

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

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

2020-05-19 Thread Tory M Blue
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