From: Domen Šetar <domen.setar@izum.si>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Vacuum not working
Date: Thu, 8 Oct 2020 17:32:05 +0000
Message-ID: <1e53e269f55345a387ed6030285a0f30@izum.si> (raw)
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.setar@izum.si> domen.setar@izum.si
Attachments:image001.png (image/png, 1.3K) downloadview image
smime.p7s (application/pkcs7-signature, 4.9K) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: domen.setar@izum.si, pgsql-admin@lists.postgresql.org
Subject: Re: Vacuum not working
In-Reply-To: <1e53e269f55345a387ed6030285a0f30@izum.si>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox