Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 107469FA2F3 for ; Tue, 11 Sep 2007 23:28:32 -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 83994-10 for ; Tue, 11 Sep 2007 23:28:20 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from vms048pub.verizon.net (vms048pub.verizon.net [206.46.252.48]) by postgresql.org (Postfix) with ESMTP id 638F29F9F52 for ; Tue, 11 Sep 2007 23:28:26 -0300 (ADT) Received: from [192.168.0.251] ([71.251.196.74]) by vms048.mailsrvcs.net (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPA id <0JO800I6AHITI0Q1@vms048.mailsrvcs.net> for pgsql-performance@postgresql.org; Tue, 11 Sep 2007 21:28:06 -0500 (CDT) Date: Tue, 11 Sep 2007 22:28:05 -0400 From: Jean-David Beyer Subject: Re: DRBD and Postgres: how to improve the perfomance? In-reply-to: <20070911212015.GC38801@decibel.org> Cc: pgsql-performance@postgresql.org Message-id: <46E74EB5.80003@verizon.net> Organization: Institute for Regimented Whimsey MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1 Content-transfer-encoding: 7bit X-Enigmail-Version: 0.94.0.0 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> <17162.1189400077@sss.pgh.pa.us> <20070911212015.GC38801@decibel.org> User-Agent: Thunderbird 1.5.0.9 (X11/20070317) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.197 tagged_above=0 required=5 tests=AWL=-0.910, BAYES_40=-0.185, MISSING_HEADERS=1.292 X-Spam-Level: X-Archive-Number: 200709/215 X-Sequence-Number: 26760 Decibel! wrote: > > Pretty much every surge supressor out there is a POS... 99.9% of them > just wire a varistor across the line; like a $0.02 part is going to stop > a 10,00+ amp discharge. > > The only use I have for those things is if they come with an equipment > guarantee, though I have to wonder how much those are still honored, > since as you mention it's very easy for equipment to be fried via other > means (ethernet, monitor, etc). My UPSs, from American Power Conversion, have one of those impressive guarantees. It specifies that all connections to my computer must be protected: power, modem, ethernet, etc. It further specifies that everything must be UL or CSA approved, and so on and so forth. Well, that is what I have. > >> net to eliminate any direct electrical connections between machines that >> are not on the same power circuit (the aforesaid burned motherboard >> taught me that particular lesson). And yet I still fear every time a >> thunderstorm passes over. > > Wired is safe as long as everything's on the same circuit. My house is > wired for ethernet with a single switch running what's going to every > room, but in each room I have a second switch on the same power as > whatever's in that room; so if there is a strike it's far more likely > that I'll lose switches and not hardware. My systems are all in the same room. The UPS for the main system has a single outlet on a circuit all its own all the way back to the power panel at the building entrance. The UPS for my other system also has a outlet on a circuit all its own all the way back to the power panel at the building entrance -- on the other side of my 240 volt service so they sorta-kinda balance out. The only other UPS is a little 620 VA one for the power to the Verizon FiOS leading into my house. That is fibre-optic all the way to the pole. I will probably get less lightning coming in that way than when I used to be on copper dial-up. ;-) > >> Then of course there are the *other* risks, such as the place burning to >> the ground, or getting drowned by a break in the city reservoir that's >> a couple hundred yards up the hill (but at least I needn't worry about > > Invest in sponges. Lots of them. :) -- .~. Jean-David Beyer Registered Linux User 85642. /V\ PGP-Key: 9A2FC99A Registered Machine 241939. /( )\ Shrewsbury, New Jersey http://counter.li.org ^^-^^ 22:00:01 up 34 days, 1:22, 5 users, load average: 4.05, 4.22, 4.25