pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedVacuum not working
2+ messages / 2 participants
[nested] [flat]
* Vacuum not working
@ 2020-10-08 17:32 Domen Šetar <domen.setar@izum.si>
2020-10-08 18:25 ` Re: Vacuum not working Ron <ronljohnsonjr@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Domen Šetar @ 2020-10-08 17:32 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
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) download
view image
* Re: Vacuum not working
2020-10-08 17:32 Vacuum not working Domen Šetar <domen.setar@izum.si>
@ 2020-10-08 18:25 ` Ron <ronljohnsonjr@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Ron @ 2020-10-08 18:25 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2020-10-08 18:25 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-10-08 17:32 Vacuum not working Domen Šetar <domen.setar@izum.si>
2020-10-08 18:25 ` Ron <ronljohnsonjr@gmail.com>
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