Horton

Re: Consecutive Query Executions with Increasing Execution Time

Peter Geoghegan <pg@bowt.ie>

View thread View on postgr.es
From: Peter Geoghegan <pg@bowt.ie>
To: Shijia Wei <shijiawei@utexas.edu>
Cc: Laurenz Albe <laurenz.albe@cybertec.at>, pgsql-performance@lists.postgresql.org
Date: 2019-12-16T20:39:10Z
Lists: pgsql-performance 
On Mon, Dec 16, 2019 at 9:28 AM Shijia Wei <shijiawei@utexas.edu> wrote:
> 1st Query:

>                      Buffers: shared hit=17074 read=16388

> 20th Query:

>                      Buffers: shared hit=17037 read=16390

Why do the first and the twentieth executions of the query have almost
identical "buffers shared/read" numbers? That seems odd.

-- 
Peter Geoghegan