pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
OS desicion
5+ messages / 4 participants
[nested] [flat]

* OS desicion
@ 2004-10-20 13:10 Tom Fischer <tom.fischer@ebuz.de>
  2004-10-20 13:23 ` Re: OS desicion Matt Clark <matt@ymogen.net>
  0 siblings, 1 reply; 5+ messages in thread

From: Tom Fischer @ 2004-10-20 13:10 UTC (permalink / raw)
  To: pgsql-performance

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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: OS desicion
  2004-10-20 13:10 OS desicion Tom Fischer <tom.fischer@ebuz.de>
@ 2004-10-20 13:23 ` Matt Clark <matt@ymogen.net>
  2004-10-20 16:38   ` Re: OS desicion Josh Berkus <josh@agliodbs.com>
  0 siblings, 1 reply; 5+ messages in thread

From: Matt Clark @ 2004-10-20 13:23 UTC (permalink / raw)
  To: Tom Fischer <tom.fischer@ebuz.de>; +Cc: 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@postgresql.org so that your
>      message can get through to the mailing list cleanly
>  
>



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: OS desicion
  2004-10-20 13:10 OS desicion Tom Fischer <tom.fischer@ebuz.de>
  2004-10-20 13:23 ` Re: OS desicion Matt Clark <matt@ymogen.net>
@ 2004-10-20 16:38   ` Josh Berkus <josh@agliodbs.com>
  2004-10-20 17:12     ` Re: OS desicion Matt Clark <matt@ymogen.net>
  2004-10-21 22:14     ` Re: OS desicion Jim C. Nasby <decibel@decibel.org>
  0 siblings, 2 replies; 5+ messages in thread

From: Josh Berkus @ 2004-10-20 16:38 UTC (permalink / raw)
  To: pgsql-performance; +Cc: Matt Clark <matt@ymogen.net>; Tom Fischer <tom.fischer@ebuz.de>

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



^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: OS desicion
  2004-10-20 13:10 OS desicion Tom Fischer <tom.fischer@ebuz.de>
  2004-10-20 13:23 ` Re: OS desicion Matt Clark <matt@ymogen.net>
  2004-10-20 16:38   ` Re: OS desicion Josh Berkus <josh@agliodbs.com>
@ 2004-10-20 17:12     ` Matt Clark <matt@ymogen.net>
  1 sibling, 0 replies; 5+ messages in thread

From: Matt Clark @ 2004-10-20 17:12 UTC (permalink / raw)
  To: Josh Berkus <josh@agliodbs.com>; +Cc: pgsql-performance@postgresql.org, Tom Fischer <tom.fischer@ebuz.de>


>>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.

Yes, quite right, I should have said 'popular x86-based unices'. 

^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: OS desicion
  2004-10-20 13:10 OS desicion Tom Fischer <tom.fischer@ebuz.de>
  2004-10-20 13:23 ` Re: OS desicion Matt Clark <matt@ymogen.net>
  2004-10-20 16:38   ` Re: OS desicion Josh Berkus <josh@agliodbs.com>
@ 2004-10-21 22:14     ` Jim C. Nasby <decibel@decibel.org>
  1 sibling, 0 replies; 5+ messages in thread

From: Jim C. Nasby @ 2004-10-21 22:14 UTC (permalink / raw)
  To: Josh Berkus <josh@agliodbs.com>; +Cc: pgsql-performance@postgresql.org, Matt Clark <matt@ymogen.net>; Tom Fischer <tom.fischer@ebuz.de>

On Wed, Oct 20, 2004 at 09:38:51AM -0700, Josh Berkus wrote:
> 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.

I'll 3rd but add one tidbit: FreeBSD will schedule disk I/O based on
process priority, while linux won't. This can be very handy for things
like vacuum.
-- 
Jim C. Nasby, Database Consultant               decibel@decibel.org 
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"



^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2004-10-21 22:14 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-10-20 13:10 OS desicion Tom Fischer <tom.fischer@ebuz.de>
2004-10-20 13:23 ` Matt Clark <matt@ymogen.net>
2004-10-20 16:38   ` Josh Berkus <josh@agliodbs.com>
2004-10-20 17:12     ` Matt Clark <matt@ymogen.net>
2004-10-21 22:14     ` Jim C. Nasby <decibel@decibel.org>

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