Postgres Pro
Downloads
Home   >   mailing lists

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

From Tory M Blue
Subject Huge tables, trying to delete OID's taking 6+hours per table
Date
Msg-id CAEaSS0YMuvA_J8LOLWwxFaxVAFhgezekB3vQycywQdiiDud2Hg@mail.gmail.com
Whole thread Raw
Responses Re: Huge tables, trying to delete OID's taking 6+hours per table  (Tory M Blue <tmblue@gmail.com>)
List pgsql-general
Tree view

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

pgsql-general by date:

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