Re: Consecutive Query Executions with Increasing Execution Time

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: Shijia Wei <shijiawei(at)utexas(dot)edu>
Cc: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Consecutive Query Executions with Increasing Execution Time
Date: 2019-12-16 20:39:10
Message-ID: CAH2-WzneCi_hM5_JGoPvGqKJr_Qd5hXcQzABz9-tQVndw9vwpw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Dec 16, 2019 at 9:28 AM Shijia Wei <shijiawei(at)utexas(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2019-12-16 20:50:17 Re: Consecutive Query Executions with Increasing Execution Time
Previous Message Pavel Stehule 2019-12-16 17:29:12 Re: performance degredation after upgrade from 9.6 to 12