[HACKERS] how to shrink pg_attribute table?

Поиск
Список
Период
Сортировка
От xu jian
Тема [HACKERS] how to shrink pg_attribute table?
Дата
Msg-id MWHPR20MB15682463D716C9435EFFDE8EA1EC0@MWHPR20MB1568.namprd20.prod.outlook.com
обсуждение исходный текст
Список pgsql-hackers
Дерево обсуждения
Hello, 
            My application creates temp table frequently. Now I find pg_attribute  table is growing larger and larger, 90GB now. 
pgstattuple shows 82% free space, so I restored the db to dev env, and tried vacuum full to shrink it. 
However, the vacuum full run for 24 hours, and hang there. I can see a CPU is on 100% usage, no disk activity. 
looks like a bug of vacuum full. my pg version is 9.6.1. auto_vacuum uses default value.
Does anyone has this issue before? how to shrink the pg_attribute table? and what is the best configuration for auto_vacuum parameter? thanks

James

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Vaishnavi Prabakaran
Дата:
Сообщение: [HACKERS] Removal of plaintext password type references
Следующее
От: Amit Langote
Дата:
Сообщение: Re: [HACKERS] transition table behavior with inheritance appearsbroken (was: Declarative partitioning - another take)