Horton

Re: Consecutive Query Executions with Increasing Execution Time

Samuel Gendler <sgendler@ideasculptor.com>

View thread View on postgr.es
From: Sam Gendler <sgendler@ideasculptor.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Nicolas Charles <nicolas.charles@normation.com>, pgsql-performance@lists.postgresql.org, Peter Geoghegan <pg@bowt.ie>, Shijia Wei <shijiawei@utexas.edu>, Laurenz Albe <laurenz.albe@cybertec.at>
Date: 2019-12-17T00:53:31Z
Lists: pgsql-performance 
On Mon, Dec 16, 2019 at 2:48 PM Tom Lane <tgl@sss.pgh.pa.us> 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.