Re: understanding postgres issues/bottlenecks

From: "M(dot) Edward (Ed) Borasky" <znmeb(at)cesmail(dot)net>
To: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: understanding postgres issues/bottlenecks
Date: 2009-01-12 02:43:42
Message-ID: 496AAE5E.6010100@cesmail.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Luke Lonergan wrote:
> Not to mention the #1 cause of server faults in my experience: OS kernel bug causes a crash. Battery backup doesn't help you much there.

Well now ... that very much depends on where you *got* the server OS and
how you administer it. If you're talking a correctly-maintained Windows
2003 Server installation, or a correctly-maintained Red Hat Enterprise
Linux installation, or any other "branded" OS from Novell, Sun, HP,
etc., I'm guessing such crashes are much rarer than what you've
experienced.

And you're probably in pretty good shape with Debian stable and the RHEL
respins like CentOS. I can't comment on Ubuntu server or any of the BSD
family -- I've never worked with them. But you should be able to keep a
"branded" server up for months, with the exception of applying security
patches that require a reboot. And *those* can be *planned* outages!

Where you *will* have some major OS risk is with testing-level software
or "bleeding edge" Linux distros like Fedora. Quite frankly, I don't
know why people run Fedora servers -- if it's Red Hat compatibility you
want, there's CentOS.

--
M. Edward (Ed) Borasky, FBG, AB, PTA, PGS, MS, MNLP, NST, ACMC(P), WOM

I've never met a happy clam. In fact, most of them were pretty steamed.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Robert Haas 2009-01-12 03:08:54 Re: understanding postgres issues/bottlenecks
Previous Message Scott Marlowe 2009-01-11 23:44:53 Re: understanding postgres issues/bottlenecks