Re: Best suiting OS

Eric thanks. And its not 200 differnet server , its only single pg8.3
handling 200+ dbs.

Arvind S

"Many of lifes failure are people who did not realize how close they were to
success when they gave up."
-Thomas Edison

On Thu, Oct 1, 2009 at 8:26 PM, Haszlakiewicz, Eric
<EHASZLA(at)transunion(dot)com>wrote:

> >-----Original Message-----
> >From: pgsql-performance-owner(at)postgresql(dot)org [mailto:pgsql-performance-
> >
> >> 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??
> >
> >As others mention FreeBSD is somewhat different from the others. I
> >personally prefer FreeBSD because that it what I do best. If you don't
> >have any prior experiences with FreeBSD/Linux spent some time
> >installing them and install some ports/apps. Try to become aquainted
> >with the update tools using the command line interface, csup on
> >FreeBSD, apt on debian/ubuntu.
>
> I'm running Postgres on NetBSD and RHEL4. I haven't noticed any particular
> differences in Postgres performance due to the OS, but then again I haven't
> performed any kind of formal benchmarks, nor am I really stressing the
> database all that much (most of the time).
> My preference for OS to run is NetBSD, because I'm most familiar with it
> and there have been some fairly significant recent focus on performance
> improvements. If you're really worried about getting the best performance I
> think you're just going to have to try a few different OSes and see if you
> notice a difference.
>
> btw, do you mean 200+ databases in a single postgres server, or that many
> different postgres servers? Running 200 different servers sounds like it
> might be problematic on any OS due to the amount of shared memory that'll
> need to be allocated.
>
> eric
>