Re: Consecutive Query Executions with Increasing Execution Time - Mailing list pgsql-performance

From Laurenz Albe
Subject Re: Consecutive Query Executions with Increasing Execution Time
Date
Msg-id e7acf6bcdf5f267d8195377e74bd12005ce5949d.camel@cybertec.at
Whole thread Raw
In response to Re: Consecutive Query Executions with Increasing Execution Time  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Consecutive Query Executions with Increasing Execution Time  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-performance
On Mon, 2019-12-16 at 15:50 -0500, Tom Lane wrote:
> 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.

Really?  Shouldn't the blocks be in shared buffers after a couple
of executions?

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com




pgsql-performance by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: weird long time query
Next
From: Jeff Janes
Date:
Subject: Re: Consecutive Query Executions with Increasing Execution Time