Solaris x86 vs Linux vs *BSD for PostgreSQL?

From: Trapper <antispam(at)nonspam(dot)com>
To: pgsql-admin(at)postgresql(dot)org(dot)pgsql-general(at)postgresql(dot)org
Subject: Solaris x86 vs Linux vs *BSD for PostgreSQL?
Date: 2002-03-03 01:14:20
Message-ID: 3C81797E.EF4085BE@nonspam.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Ladies and gents,

I've searched around a bit, and can't seems to find any solid opinion
as to which OS postgresql likes best. Surely some of you, my intrepid
fellow travelers, have done some investigation into this on your own.
What did you find?

I'll be more specific, and describe what I'm using now:

OS: Linux, kernel 2.4.16 with IDE patch
DISK: Linux software raid0 across two ATA100 drives
RAM: 512 MBytes

Total db size is just South of 9 GBytes. Most tables are 50-200 megs,
100-400,000 rows, one big table is >2GB (~4M rows).

I'm not aware of Slowlaris supporting software RAID (at least not
without 3rd party tools) so I'm thinking it's pretty much off the
list. Putting my db on a software RAID0 vs straight disk has
resulted in certain ops going at 10x speed (yes, 10x! (no, it wasn't
due to caching!)).

ISTR that the various BSDs have a concatenated disk driver, which
I'll assume to be not unlike Linux software raid. So, for the sake
of this discussion (unless I'm reeeeeally wrong) let's factor out
BSD vs Linux on the grounds of disk I/O performance.

I guess the thing I'm most curious about is whether there are any
neat little tricks that PostgreSQL uses on BSD that it can't use
under Linux. Any general impressions of which environment it
prefers?

Many thanks.

--Trapper

Browse pgsql-admin by date

  From Date Subject
Next Message Stephan Szabo 2002-03-03 07:42:54 Re: removing duplicated constraints
Previous Message Dan Langille 2002-03-02 21:42:29 Re: removing duplicated constraints

Browse pgsql-general by date

  From Date Subject
Next Message Troy.Campano 2002-03-03 02:10:32 Error with JDBC after drop table
Previous Message Campano, Troy 2002-03-02 23:21:35 Multiple DB Servers on 1 machine