Could it be that your CPUs is warming and throttling? You didn't mention the platform used, so I'm not sure whether
it'sa server or a laptop
Nicolas
Le 16 décembre 2019 21:50:17 GMT+01:00, Tom Lane <tgl@sss.pgh.pa.us> a écrit :
>Peter Geoghegan <pg@bowt.ie> writes:
>> Why do the first and the twentieth executions of the query have
>almost
>> identical "buffers shared/read" numbers? That seems odd.
>
>It's repeat execution of the same query, so that doesn't seem odd to
>me.
>
>This last set of numbers suggests that there's some issue with the
>parallel execution infrastructure in particular, though I don't see
>what
>it would be. Doesn't execParallel wait for the workers to exit before
>the leader finishes its query? If so, how is there any persistent
>state
>that would interfere with a later query?
>
> regards, tom lane
--
Envoyé de mon appareil Android avec Courriel K-9 Mail. Veuillez excuser ma brièveté.