From: | Matt Clark <matt(at)ymogen(dot)net> |
---|---|
To: | Tom Fischer <tom(dot)fischer(at)ebuz(dot)de> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: OS desicion |
Date: | 2004-10-20 13:23:21 |
Message-ID: | 417666C9.80008@ymogen.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
You are asking the wrong question. The best OS is the OS you (and/or
the customer) knows and can administer competently. The real
performance differences between unices are so small as to be ignorable
in this context. 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).
M
Tom Fischer wrote:
>Hi List,
>
>I have a Dual-Xeon 3Ghz System with with GB RAM and an Adaptec 212ß SCSI
>RAID with 4 SCA Harddiscs. Our customer wants to have the Machine tuned
>for best Database performance. Which OS should we used? We are tending
>between Linux 2.6 or FreeBSD. The Database Size is 5GB and ascending.
>Most SQL-Queries are Selects, the Tablesizes are beetween 300k and up to
>10 MB. I've read the Hardware Performance Guide and the result was to
>take FreeBSD in the Decision too :)
>
>And what is on this Context Switiching Bug i have read in the Archive?
>
>Hope you can help me
>
>Regards
>
>Tom
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Close | 2004-10-20 13:36:49 | Re: how much mem to give postgres? |
Previous Message | Aaron Mulder | 2004-10-20 13:11:25 | Re: Free PostgreSQL Training, Philadelphia, Oct 30 |