Re: understanding postgres issues/bottlenecks - Mailing list pgsql-performance

From M. Edward (Ed) Borasky
Subject Re: understanding postgres issues/bottlenecks
Date
Msg-id 496AAE5E.6010100@cesmail.net
Whole thread Raw
In response to Re: understanding postgres issues/bottlenecks  (Luke Lonergan <LLonergan@greenplum.com>)
Responses Re: understanding postgres issues/bottlenecks  ("Robert Haas" <robertmhaas@gmail.com>)
Re: understanding postgres issues/bottlenecks  (Greg Smith <gsmith@gregsmith.com>)
Re: understanding postgres issues/bottlenecks  (Matthew Wakeling <matthew@flymine.org>)
Re: understanding postgres issues/bottlenecks  (Jeff <threshar@torgo.978.org>)
Re: understanding postgres issues/bottlenecks  (Jean-David Beyer <jeandavid8@verizon.net>)
List 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
helpyou 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.

pgsql-performance by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: understanding postgres issues/bottlenecks
Next
From: "Robert Haas"
Date:
Subject: Re: understanding postgres issues/bottlenecks