From: Josh Berkus <josh@agliodbs.com>
To: pgsql-performance@postgresql.org
Subject: Re: Increasing WAL usage followed by sudden drop
Date: Mon, 13 Aug 2012 18:09:23 -0700
Message-ID: <5029A543.4090503@agliodbs.com> (raw)
In-Reply-To: <385621813.89890122.1344620116156.JavaMail.root@email>
References: <385621813.89890122.1344620116156.JavaMail.root@email>
> Any ideas on any of this? Why the sawteeth? Why the rise-then-drop?
Well, my first thought on the sawteeth is that you have archive_timeout
set to 15 minutes. No?
As for the gradual buildup over days, that most likely corresponds to
either changes in application activity levels, or some kind of weekly
data purge cycle which shrinks your database every weekend. Since I
don't know anything about your admin or your application, that's a best
guess.
--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com
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: josh@agliodbs.com
Subject: Re: Increasing WAL usage followed by sudden drop
In-Reply-To: <5029A543.4090503@agliodbs.com>
* 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