Skip site navigation (1) Skip section navigation (2)

Re: OS desicion

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: Matt Clark <matt(at)ymogen(dot)net>, Tom Fischer <tom(dot)fischer(at)ebuz(dot)de>
Subject: Re: OS desicion
Date: 2004-10-20 16:38:51
Message-ID: 200410200938.51391.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-performance
Tom,

> You are asking the wrong question.  The best OS is the OS you (and/or
> the customer)  knows and can administer competently.  

I'll have to 2nd this.

> The real 
> performance differences between unices are so small as to be ignorable
> in this context. 

Well, at least the difference between Linux and BSD.   There are substantial 
tradeoffs should you chose to use Solaris or UnixWare.

> The context switching bug is not OS-dependent, but 
> varys in severity across machine architectures (I understand it to be
> mostly P4/Athlon related, but don't take my word for it).

The bug is at its apparent worst on multi-processor HT Xeons and weak 
northbridges running Linux 2.4.  However, it has been demonstrated (with 
lesser impact) on Solaris/Sparc, PentiumIII, and Athalon.   Primarily it 
seems to affect data warehousing applications.   Your choice of OS is not 
affected by this bug.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

pgsql-performance by date

Next:From: Robert CreagerDate: 2004-10-20 16:45:27
Subject: Re: Insert performance, what should I expect?
Previous:From: Thomas F.O'ConnellDate: 2004-10-20 16:13:49
Subject: Re: Index not used in query. Why?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group