pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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.. 



view thread (9+ messages)

Message-ID: <cone.1184200016.541202.9511.5001@35st.simplicato.com>
Permalink:  ../cone.1184200016.541202.9511.5001@35st.simplicato.com/
Also on:    postgresql.org/message-id/cone.1184200016.541202.9511.5001@35st.simplicato.com

 · 

reply

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