Re: Consecutive Query Executions with Increasing Execution Time

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: Consecutive Query Executions with Increasing Execution Time
Дата
Msg-id CAH2-WzneCi_hM5_JGoPvGqKJr_Qd5hXcQzABz9-tQVndw9vwpw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Consecutive Query Executions with Increasing Execution Time  (Shijia Wei <shijiawei@utexas.edu>)
Ответы Re: Consecutive Query Executions with Increasing Execution Time  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: performance degredation after upgrade from 9.6 to 12
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Consecutive Query Executions with Increasing Execution Time