Re: understanding postgres issues/bottlenecks

Поиск
Список
Период
Сортировка
От M. Edward (Ed) Borasky
Тема Re: understanding postgres issues/bottlenecks
Дата
Msg-id 496AAE5E.6010100@cesmail.net
обсуждение исходный текст
Ответ на Re: understanding postgres issues/bottlenecks  (Luke Lonergan <LLonergan@greenplum.com>)
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: understanding postgres issues/bottlenecks
Следующее
От: "Robert Haas"
Дата:
Сообщение: Re: understanding postgres issues/bottlenecks