| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | S Arvind <arvindwill(at)gmail(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Best suiting OS |
| Date: | 2009-10-01 19:46:16 |
| Message-ID: | dcc563d10910011246k715ceac3l39a76042bddf6dd7@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Thu, Oct 1, 2009 at 3:46 AM, S Arvind <arvindwill(at)gmail(dot)com> wrote:
> Hi everyone,
> What is the best Linux flavor for server which runs postgres alone.
> The postgres must handle greater number of database around 200+. Performance
> on speed is the vital factor.
> Is it FreeBSD, CentOS, Fedora, Redhat xxx??
You say you want speed, but I'm betting stability is more important
than speed, as a machine that crashes several times a month but is
lightening fast is usually a bad choice for a db server.
I run Centos 5.3 with an older kernel. There's a bug in the areca
drivers after the 2.6.18-92.el5 kernel that redhat has no apparent
interest in fixing. But with that kernel, I have a machine that's
pretty fast and stable:
uname -a
Linux db1 2.6.18-92.el5 #1 SMP Tue Jun 10 18:51:06 EDT 2008 x86_64
x86_64 x86_64 GNU/Linux
uptime
13:44:38 up 416 days, 28 min, 6 users, load average: 28.94, 31.93, 32.50
It's twin was the one I tested the newer kernel on and had the hangs
with. It now runs the same older kernel as well.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gerd König | 2009-10-02 05:44:12 | Re: long running insert statement |
| Previous Message | Denis Lussier | 2009-10-01 19:44:09 | Re: Best suiting OS |