checking the trigger values for autovacuum tresholds

From: Dirk Krautschick <Dirk(dot)Krautschick(at)trivadis(dot)com>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: checking the trigger values for autovacuum tresholds
Date: 2022-05-24 22:16:39
Message-ID: ZRAP278MB02542738BDA433F6C80B873AE9D79@ZRAP278MB0254.CHEP278.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I am actually doing some test with pglogical and a trivial bi-directional replication setup (no BDR, just cross subscriptions, no conflicts because UUID a prim key).
During the tests I am stressing the autovacuum results to simulate a customer situation having trouble with files growing way different on two replica nodes.

I am checking for the count of dead tuples with pg_stat_user_tables or the extension pgstattuple and I am not sure if any is somehow accurate.

What is the most accurate way to check for this information except using pageinspect and/or freespacemap and count for myself and
what exact value is using by the autovacuum process related to the configured thresholds?

In another question few weeks ago I asked for the expected result using pglogical and autovacuum on both sides. It should be most likely the same
file sizes. But at the customers environment one site is always growing and there are just very small and short transactions.

Thanks and best regards

Dirk

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jeff Janes 2022-05-24 23:09:02 Re: checking the trigger values for autovacuum tresholds
Previous Message Tom Lane 2022-05-24 14:44:02 Re: Error setting lc_time