From: Francisco Reyes <lists@stringsutils.com>
To: Greg Smith <gsmith@gregsmith.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: WALL on controller without battery?
Date: Wed, 11 Jul 2007 20:26:56 -0400
Message-ID: <cone.1184200016.541202.9511.5001@35st.simplicato.com> (raw)
References: <cone.1184165284.909164.90107.1000@zoraida.natserv.net>
<20070711153620.GP1241@phlogiston.dyndns.org>
<200707110847.44612@hal.medialogik.com>
<cone.1184182772.853257.9511.5001@35st.simplicato.com>
<46953359.5060404@commandprompt.com>
<cone.1184186086.804659.9511.5001@35st.simplicato.com>
<Pine.GSO.4.64.0707111844270.15084@westnet.com>
Greg Smith writes:
>> During peak operation there will be about 5 to 20 updates per second
>> with a handfull of reads.
>
> There really is no reason you need to be concerned about WAL from a
> performance perspective if this is your expected workload.
I was able to get the second controller with battery backup.
This machine is the backup so if the primary fails it would get higher
volumes.
It is also easier to throw more work at a good machine than to find myself
with an underperformer.
> both the database and the WAL on there, and don't even bother trying to
> separate out the WAL.
Thanks for the feedback.
I wish there was a place with hardware guide where people could get feedback
like the one you gave me. In particular actual numbers like x to y number of
transactions per second you don't need WAL no separate disk.. etc..
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: lists@stringsutils.com, gsmith@gregsmith.com
Subject: Re: WALL on controller without battery?
In-Reply-To: <cone.1184200016.541202.9511.5001@35st.simplicato.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