Postgres Pro
Downloads
Home   >   mailing lists

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

From Peter Geoghegan
Subject Re: Consecutive Query Executions with Increasing Execution Time
Date
Msg-id CAH2-WzneCi_hM5_JGoPvGqKJr_Qd5hXcQzABz9-tQVndw9vwpw@mail.gmail.com
Whole thread Raw
In response to Re: Consecutive Query Executions with Increasing Execution Time  (Shijia Wei <shijiawei@utexas.edu>)
Responses Re: Consecutive Query Executions with Increasing Execution Time  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: performance degredation after upgrade from 9.6 to 12
Next
From: Tom Lane
Date:
Subject: Re: Consecutive Query Executions with Increasing Execution Time