From: Greg Smith <gsmith@gregsmith.com>
To: pgsql-performance@postgresql.org
Subject: Estimating WAL volume
Date: Wed, 11 Jul 2007 23:10:36 -0400 (EDT)
Message-ID: <Pine.GSO.4.64.0707112254480.17954@westnet.com> (raw)
All this talk of WAL writing lately has me wondering something I haven't
spent enough time looking at the source to figure out myself this
week...any good rules of thumb out there for estimating WAL volume? I'm
used to just measuring it via benchmarking but it strikes me a formula
would be nice to have for pre-planning.
For example, if I have a table where a typical row is X bytes wide, and
I'm updating Y of those per second, what's the expected write rate of WAL
volume? Some % of those writes are going to be full pages; what's
typical? How much does the number and complexity of indexes factor into
things--just add the width of the index in bytes to the size of the
record, or is it worse than that?
--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
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: gsmith@gregsmith.com
Subject: Re: Estimating WAL volume
In-Reply-To: <Pine.GSO.4.64.0707112254480.17954@westnet.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