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

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

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

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