Обсуждение: Vacuum not working

Поиск
Список
Период
Сортировка

Vacuum not working

От
Domen Šetar
Дата:

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

 

 

Вложения

Re: Vacuum not working

От
Ron
Дата:
On 10/8/20 12:32 PM, Domen Šetar wrote:

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.


Is there an open transaction causing the vacuum to not free thee dead tuples?

--
Angular momentum makes the world go 'round.