Re: Consecutive Query Executions with Increasing Execution Time

Could it be that your CPUs is warming and throttling? You didn't mention t=
he platform used, so I'm not sure whether it's a server or a laptop

Nicolas

Le 16 d=C3=A9cembre 2019 21:50:17 GMT+01:00, Tom Lane <tgl@sss=2Epgh=2Epa=
=2Eus> a =C3=A9crit :
>Peter Geoghegan <pg@bowt=2Eie> writes:
>> Why do the first and the twentieth executions of the query have
>almost
>> identical "buffers shared/read" numbers? That seems odd=2E
>
>It's repeat execution of the same query, so that doesn't seem odd to
>me=2E
>
>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=2E  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

--=20
Envoy=C3=A9 de mon appareil Android avec Courriel K-9 Mail=2E Veuillez exc=
user ma bri=C3=A8vet=C3=A9=2E