Hey Daniel,
This may be entirely unrelated to your query, but we’ve previously experienced
issues with 9.4 and crazy multixact members growth.
After digging into the issue, we found the culprit was code that would perform
the following actions:
begin;
for query in many_queries:
savepoint ;
Hey Ilyeop,
> Q1. How can I know/check if the autovacuum is actually paused periodically
> according to autovacuum_vacuum_cost_limit and autovacuum_vacuum_cost_delay?
Vacuums that are triggered by the auto-vacuum process will be governed by the
autovacuum cost configuration variables. You won’t