Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id E10419F9F3E for ; Mon, 10 Sep 2007 01:06:43 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 46770-08 for ; Mon, 10 Sep 2007 01:06:39 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from westnet.com (westnet.com [216.187.52.2]) by postgresql.org (Postfix) with ESMTP id 696FF9F9E83 for ; Mon, 10 Sep 2007 01:06:40 -0300 (ADT) Received: from westnet.com (localhost [127.0.0.1]) by westnet.com (8.14.0/8.14.0) with ESMTP id l8A46fQR012410 for ; Mon, 10 Sep 2007 00:06:41 -0400 (EDT) Received: from localhost (gsmith@localhost) by westnet.com (8.14.0/8.13.2/Submit) with ESMTP id l8A46fkI012407 for ; Mon, 10 Sep 2007 00:06:41 -0400 (EDT) X-Authentication-Warning: westnet.com: gsmith owned process doing -bs Date: Mon, 10 Sep 2007 00:06:40 -0400 (EDT) From: Greg Smith X-X-Sender: gsmith@westnet.com To: pgsql-performance@postgresql.org Subject: Re: DRBD and Postgres: how to improve the perfomance? In-Reply-To: <46E2D5A9.3060304@commandprompt.com> Message-ID: References: <2C070D1C3970467FF64F6B6A@imhotep.credativ.de> <1189232904.4281.19.camel@ebony.site> <87k5r1zd52.fsf@oxford.xeocode.com> <46E2CAAF.50205@commandprompt.com> <87642lyuey.fsf@oxford.xeocode.com> <46E2D5A9.3060304@commandprompt.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/156 X-Sequence-Number: 26701 On Sat, 8 Sep 2007, Joshua D. Drake wrote: > You would have to have lightning handed by God to your server to have a > total power failure without proper shutdown in the above scenario. Do you live somewhere without thunderstorms? This is a regular event in this part of the world during the summer. It happened to me once this year and once last; lost count for previous ones. In both of the recent cases it's believed the servers were burned from the Ethernet side because somewhere in the network was a poor switch that wasn't isolated well enough from the grid when the building was hit. Lightning is tricky that way; cable TV and satellite wiring are also weak links that way. I didn't feel too bad about last year's because the building next door burned to the ground after being hit within a few seconds of mine, so the fact that I had some server repair didn't seem like too much of a hardship in comparison. The system was down until the fire department had put out the blaze and I was allowed back into the building though. Good thing my cell phone works in the server room; that phone call asking "are you aware the building is being evacuated?" is always a fun one. I'm not saying God hates you as much as me, because the fact that you've made this statement says it's clearly not the case, just that a plan presuming he's your buddy is a bad one. The way you're characterizing this risk reminds me of when people quote the odds that they'll lose two disks within seconds of one another in a disk array as if it's impossible, something else which of course has also happened to me many times during my career. -- * Greg "Lucky" Smith gsmith@gregsmith.com Baltimore, MD