| From: | Robert Creager <robertc(at)spectralogic(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, Justin Pryzby <pryzby(at)telsasoft(dot)com>, "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Need help identifying a periodic performance issue. |
| Date: | 2021-11-18 22:30:39 |
| Message-ID: | 3C5B1E23-79DE-46C7-B745-E134B6BD4610@spectralogic.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
> On Nov 18, 2021, at 2:42 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Creager | 2021-11-19 18:47:45 | Re: Need help identifying a periodic performance issue. |
| Previous Message | Robert Creager | 2021-11-18 22:28:38 | Re: Need help identifying a periodic performance issue. |