Re: Perplexing, regular decline in performance

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Perplexing, regular decline in performance
Дата
Msg-id 20190717175551.GA24085@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: Perplexing, regular decline in performance  (Justin Pryzby <pryzby@telsasoft.com>)
Ответы Re: Perplexing, regular decline in performance  (Andres Freund <andres@anarazel.de>)
Список pgsql-performance
On 2019-Jun-26, Justin Pryzby wrote:

> > Also, Should pg_buffercache perhaps be run at the beginning and end of the
> > week, to see if there is a significant difference?
> 
> Yes; buffercache can be pretty volatile, so I'd save it numerous times each at
> beginning and end of week.

Be careful with pg_buffercache though, as it can cause a hiccup in
operation.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



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

Предыдущее
От: Hugh Ranalli
Дата:
Сообщение: Re: Perplexing, regular decline in performance
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Perplexing, regular decline in performance