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

Поиск
Список
Период
Сортировка
От Tory M Blue
Тема Re: Huge tables, trying to delete OID's taking 6+hours per table
Дата
Msg-id CAEaSS0Yzm0F9w+tWPOX5OHWRq44-s1Tn0kKsEV0hjniYeWDC_A@mail.gmail.com
обсуждение исходный текст
Ответ на Huge tables, trying to delete OID's taking 6+hours per table  (Tory M Blue <tmblue@gmail.com>)
Ответы Re: Huge tables, trying to delete OID's taking 6+hours per table
Список pgsql-general
Дерево обсуждения


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 по дате отправления:

Предыдущее
От: Anders Bøgh Bruun
Дата:
Сообщение: Logical replication troubles
Следующее
От: "Andrus"
Дата:
Сообщение: Re: Hot and PITR backups in same server