From: Alvaro Herrera <alvherre@2ndquadrant.com>
To: Justin Pryzby <pryzby@telsasoft.com>
Cc: Hugh Ranalli <hugh@whtc.ca>
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: Perplexing, regular decline in performance
Date: Wed, 17 Jul 2019 13:55:51 -0400
Message-ID: <20190717175551.GA24085@alvherre.pgsql> (raw)
In-Reply-To: <20190627002442.GQ18602@telsasoft.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: alvherre@2ndquadrant.com, pryzby@telsasoft.com, hugh@whtc.ca, pgsql-performance@lists.postgresql.org
Subject: Re: Perplexing, regular decline in performance
In-Reply-To: <20190717175551.GA24085@alvherre.pgsql>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox