> On Nov 18, 2021, at 2:42 PM, Tom Lane <tgl@xxxxxxxxxxxxx> 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
