From: Joseph Marlin <jmarlin@saucontech.com>
To: pgsql-performance@postgresql.org
Subject: Increasing WAL usage followed by sudden drop
Date: Fri, 10 Aug 2012 13:35:16 -0400 (EDT)
Message-ID: <385621813.89890122.1344620116156.JavaMail.root@email> (raw)
In-Reply-To: <533006730.89877629.1344618806676.JavaMail.root@email>
http://i.imgur.com/sva4H.png
In the image above, please find the traffic we have seen from our main postgresql node to our cloud backup.
A few notes on that image:
a) We're only interested in looking at the blue - outbound - traffic
b) In general, this pipe is almost exclusively for WAL usage only.
Hopefully you can see how generalized WAL traffic increases, until it cuts off sharply, only to begin increasing again.
http://i.imgur.com/2V8XY.png
In that image, you can see the traffic just after a cutoff - slowly ramping up again. You can also see our mysterious sawtooth pattern - spikes of WAL traffic that occur on the hour, quarter-hour, half-hour, and three-quarter-hour marks. We don't see any corresponding spikes in database activity at those times, so we're also mystified as to why these spikes are occurring.
Any ideas on any of this? Why the sawteeth? Why the rise-then-drop?
Thanks so much!
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: jmarlin@saucontech.com
Subject: Re: Increasing WAL usage followed by sudden drop
In-Reply-To: <385621813.89890122.1344620116156.JavaMail.root@email>
* 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