Re: WALL on controller without battery?

From: Francisco Reyes <lists(at)stringsutils(dot)com>
To: Greg Smith <gsmith(at)gregsmith(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: WALL on controller without battery?
Date: 2007-07-12 00:26:56
Message-ID: cone.1184200016.541202.9511.5001@35st.simplicato.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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..

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Smith 2007-07-12 03:10:36 Estimating WAL volume
Previous Message Greg Smith 2007-07-11 23:01:10 Re: WALL on controller without battery?