Re: Impact of multixact "members" limit exceeded

2018-06-14 Thread Lawrence Jones
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 ;

Re: About "Cost-based Vacuum Delay"

2018-06-15 Thread Lawrence Jones
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