pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Matt Clark <matt@ymogen.net>
To: Tom Fischer <tom.fischer@ebuz.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: OS desicion
Date: Wed, 20 Oct 2004 14:23:21 +0100
Message-ID: <417666C9.80008@ymogen.net> (raw)
In-Reply-To: <20041020151015.766bb00c@nixe>
References: <20041020151015.766bb00c@nixe>

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@postgresql.org so that your
>      message can get through to the mailing list cleanly
>  
>



view thread (5+ messages)  latest in thread

Message-ID: <417666C9.80008@ymogen.net>
Permalink:  ../417666C9.80008@ymogen.net/
Also on:    postgresql.org/message-id/417666C9.80008@ymogen.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: matt@ymogen.net, tom.fischer@ebuz.de
  Subject: Re: OS desicion
  In-Reply-To: <417666C9.80008@ymogen.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox