From: Decibel! <decibel@decibel.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Greg Smith <gsmith@gregsmith.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: DRBD and Postgres: how to improve the perfomance?
Date: Tue, 11 Sep 2007 16:20:15 -0500
Message-ID: <20070911212015.GC38801@decibel.org> (raw)
In-Reply-To: <17162.1189400077@sss.pgh.pa.us>
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>
<Pine.GSO.4.64.0709092339330.8403@westnet.com>
<17162.1189400077@sss.pgh.pa.us>
On Mon, Sep 10, 2007 at 12:54:37AM -0400, Tom Lane wrote:
> Greg Smith <gsmith@gregsmith.com> writes:
> > 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.
>
> Yeah. I've lost half a dozen modems of varying generations, a server
> motherboard, a TiVo, a couple of VCRs, and miscellaneous other equipment
> from strikes near my house --- none closer than a couple blocks away.
> I don't really care to think about what would still work after a direct
> hit, despite the whole-house surge suppressor at the meter and the local
> suppressor on each circuit and the allegedly surge-proof UPSes powering
> all the valuable stuff. I've also moved heavily into wireless local
<dons EE hat>
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).
> 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.
> 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. :)
--
Decibel!, aka Jim Nasby decibel@decibel.org
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
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: decibel@decibel.org, tgl@sss.pgh.pa.us, gsmith@gregsmith.com
Subject: Re: DRBD and Postgres: how to improve the perfomance?
In-Reply-To: <20070911212015.GC38801@decibel.org>
* 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