Vacuum not working - Mailing list pgsql-admin

From Domen Šetar
Subject Vacuum not working
Date
Msg-id 1e53e269f55345a387ed6030285a0f30@izum.si
Whole thread Raw
Responses Re: Vacuum not working
List 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

 

 

Attachment

pgsql-admin by date:

Previous
From: Don Seiler
Date:
Subject: terminating connection due to conflict with recovery
Next
From: Ron
Date:
Subject: Re: Vacuum not working