Vacuum not working

Поиск
Список
Период
Сортировка
От Domen Šetar
Тема Vacuum not working
Дата
Msg-id 1e53e269f55345a387ed6030285a0f30@izum.si
обсуждение исходный текст
Ответы Re: Vacuum not working  (Ron <ronljohnsonjr@gmail.com>)
Список pgsql-admin

Hi guys,

 

I have following problem: I use POWA to collect performance data from 20 postgresql servers. Vaccum doesn't clean the largest table after POWA database is growing large. Here are data taken at 19:27:

 

 

                  relname                   | last_vacuum | last_autovacuum  |     n_tup      |    dead_tup    |  av_threshold  | expect_av

--------------------------------------------+-------------+------------------+----------------+----------------+----------------+-----------

powa_all_relations_history_current         |             | 2020-10-08 18:24 |    162,254,592 |     82,045,219 |        162,280 | *

 

Can you please advise me how to tune poasgresql vacuum parameters to get this table cleaned? All other tables are vacummed as expected.

 

Best regards!

izum

Domen Šetar
Computer Systems Support
IZUM – Institute of Information Science | Prešernova ulica 17 | 2000 Maribor | Slovenia
T: +386 2 25 20 339 | M: +386 41 676 342 | www.izum.si | domen.setar@izum.si

 

 

Вложения

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

Предыдущее
От: Don Seiler
Дата:
Сообщение: terminating connection due to conflict with recovery
Следующее
От: Ron
Дата:
Сообщение: Re: Vacuum not working