> 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