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!
|
Attachment:
smime.p7s
Description: S/MIME cryptographic signature