| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Creager | 2004-10-20 16:45:27 | Re: Insert performance, what should I expect? |
| Previous Message | Thomas F.O'Connell | 2004-10-20 16:13:49 | Re: Index not used in query. Why? |