| From: | Domen Šetar <domen(dot)setar(at)izum(dot)si> |
|---|---|
| To: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Vacuum not working |
| Date: | 2020-10-08 17:32:05 |
| Message-ID: | 1e53e269f55345a387ed6030285a0f30@izum.si |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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!
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 | <http://www.izum.si/>
www.izum.si | <mailto:domen(dot)setar(at)izum(dot)si> domen(dot)setar(at)izum(dot)si
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron | 2020-10-08 18:25:14 | Re: Vacuum not working |
| Previous Message | Don Seiler | 2020-10-08 15:17:50 | terminating connection due to conflict with recovery |