Re: Consecutive Query Executions with Increasing Execution Time

--00000000000070fa630599dbc236
Content-Type: text/plain; charset="UTF-8"

On Mon, Dec 16, 2019 at 2:48 PM Tom Lane <[email protected]> wrote:

> unless you suppose it actually
> throttled to below base freq, which surely shouldn't happen that fast.
> Might be worth watching the CPU frequency while doing the test though.
>

Wouldn't expect to see such linear progression if that were the case.
Steps, over a relatively long period of time, would be the likely pattern,
no?  Same goes for some other process fighting for resources.  Every
iteration requiring what appears to be a fairly constant increase in
execution time (2-5ms on every iteration) seems an unlikely pattern unless
the two processes are linked in some way, I would think.

--00000000000070fa630599dbc236
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote">=
<div dir=3D"ltr" class=3D"gmail_attr">On Mon, Dec 16, 2019 at 2:48 PM Tom L=
ane &lt;<a href=3D"mailto:[email protected]">[email protected]</a>&gt; wrot=
e:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0=
.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">unless you su=
ppose it actually<br>
throttled to below base freq, which surely shouldn&#39;t happen that fast.<=
br>
Might be worth watching the CPU frequency while doing the test though.<br><=
/blockquote><div><br></div><div>Wouldn&#39;t expect to see such linear prog=
ression if that were the case.=C2=A0 Steps, over a relatively long period o=
f time, would be the likely pattern, no?=C2=A0 Same goes for some other pro=
cess fighting for resources.=C2=A0 Every iteration requiring what appears t=
o be a fairly constant increase in execution time (2-5ms on every iteration=
) seems an unlikely=C2=A0pattern unless the two processes are linked in som=
e way, I would think.</div></div></div>

--00000000000070fa630599dbc236--