On 8/19/22 12:52 AM, Vido Vlahinic wrote:
> My goal here is to predict where multixact members are growing the
> fastest so I can perform manual VACUUM FREEZE only on those tables
>
> (typically with multi-billion row count) when system is relatively
> idle as opposed to just sit and wait for
On Fri, Aug 19, 2022 at 8:40 AM Vido Vlahinic
wrote:
> However it is not quite clear to me how I can interpret results from above
> and e.g. conclude: my_table accumulates x more multixact members since I
> measured last.
You can't. And not just because nobody got around to implementing it
yet
Hello everyone,
Is there a way to monitor multixact members growth per table ?
There is this query:
SELECT relname, relminmxid, mxid_age(relminmxid) AS age
FROM pg_class
WHERE relkind = 'r'
AND relnamespace::regnamespace::text = 'public'
ORDER BY 3 DESC
However it is not quite clear to me how
Hello everyone,
Is there a way to monitor multixact members growth per table ?
There is this query:
SELECT relname, relminmxid, mxid_age(relminmxid) AS age
FROM pg_class
WHERE relkind = 'r'
AND relnamespace::regnamespace::text = 'public'
ORDER BY 3 DESC
However it is not quite clear to me how
