Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id C4A4B9FB486 for ; Wed, 11 Jul 2007 21:27:04 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 78361-03 for ; Wed, 11 Jul 2007 21:26:48 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from zoraida.natserv.net (p65-147.acedsl.com [66.114.65.147]) by postgresql.org (Postfix) with ESMTP id B0F839FB3D7 for ; Wed, 11 Jul 2007 21:27:00 -0300 (ADT) Received: from 35st.simplicato.com (static-71-249-233-130.nycmny.east.verizon.net [71.249.233.130]) by zoraida.natserv.net (Postfix) with ESMTP id 64B1C1702C; Wed, 11 Jul 2007 20:27:52 -0400 (EDT) References: <20070711153620.GP1241@phlogiston.dyndns.org> <200707110847.44612@hal.medialogik.com> <46953359.5060404@commandprompt.com> Message-ID: X-Mailer: http://www.courier-mta.org/cone/ From: Francisco Reyes To: Greg Smith Cc: pgsql-performance@postgresql.org Subject: Re: WALL on controller without battery? Date: Wed, 11 Jul 2007 20:26:56 -0400 Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="US-ASCII" Content-Disposition: inline Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.097 tagged_above=0 required=5 tests=AWL=0.282, BAYES_40=-0.185 X-Spam-Level: X-Archive-Number: 200707/129 X-Sequence-Number: 25813 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..