Re: Consecutive Query Executions with Increasing Execution Time

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Consecutive Query Executions with Increasing Execution Time
Дата
Msg-id e7acf6bcdf5f267d8195377e74bd12005ce5949d.camel@cybertec.at
обсуждение исходный текст
Ответ на Re: Consecutive Query Executions with Increasing Execution Time  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Consecutive Query Executions with Increasing Execution Time  (Jeff Janes <jeff.janes@gmail.com>)
Список pgsql-performance
Дерево обсуждения 
On Mon, 2019-12-16 at 15:50 -0500, Tom Lane wrote:
> Peter Geoghegan <pg@bowt.ie> writes:
> > Why do the first and the twentieth executions of the query have almost
> > identical "buffers shared/read" numbers? That seems odd.
> 
> It's repeat execution of the same query, so that doesn't seem odd to me.

Really?  Shouldn't the blocks be in shared buffers after a couple
of executions?

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com

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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: weird long time query
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: Consecutive Query Executions with Increasing Execution Time