Re: Consecutive Query Executions with Increasing Execution Time

Peter Geoghegan <[email protected]> Mon, 16 Dec 2019 12:39:10 -0800

Newsgroups	gmane.comp.db.postgresql.performance
Message-ID	<CAH2-WzneCi_hM5_JGoPvGqKJr_Qd5hXcQzABz9-tQVndw9vwpw@mail.gmail.com>

On Mon, Dec 16, 2019 at 9:28 AM Shijia Wei <[email protected]> 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