Re: Need help identifying a periodic performance issue.

> On Nov 18, 2021, at 2:42 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> 
> This is all guesswork though, since we don't know quite what's
> happening on Robert's system.  It might be worth setting
> "log_autovacuum_min_duration = 0" (either globally, or as a
> reloption on the relevant tables), and seeing if there seems
> to be any correlation between autovacuum/autoanalyze activity
> and the occurrences of poor plan choices.

I’ve changed the log duration globally, and am also using the plan_cache_mode=force_custom_plan suggested by Justin.

Best,
Robert