From: David Kelly <dkelly@hiwaay.net>
To: Clayton Cottingham <drfrog@smartt.com>
Cc: pgsql-sql@postgreSQL.org
Subject: Re: [SQL] linux vs freebsd as postgres server
Date: Thu, 16 Sep 1999 20:14:18 -0500
Message-ID: <199909170114.UAA33891@nospam.hiwaay.net> (raw)
In-Reply-To: <drfrog@smartt.com> <37E15915.C986BC65@smartt.com>
Clayton Cottingham writes:
> a while back
>
> tom lane, i think ,
> mentioned something about
> freebsd being the best in terms of file system performance
>
> based on the fact linux 's ext2 has some sort of paging /memory handling
> issues?
>
> i was wondering if anyone has any numbers on this sort of thing?
FreeBSD has always supported files larger than 2G. Last I saw with
Linux it was still a matter of "pick your favorite patch set, each has
its strengths and weaknesses." I used to deal with a lot of files
larger than 2G.
> and what about scsi/eide/raid?
If performance (other than $/GB) is an issue, xIDE is eliminated. Altho
FreeBSD does handle IDE HD's, and UDMA IDE. And offers at least two
ways to combine multiple drives into a larger filesystem. RAID5 was
recently added to the CVS archive (not sure if it made its way into
this week's FreeBSD 3.3 release.)
FreeBSD's Adaptec driver is probably the premier example of what
Adaptec's hardware can do. Last I heard FreeBSD's Adaptec driver is
ported to Linux and is the default Adaptec driver in most (or all?)
Linux distributions. This may be diverging as FreeBSD has changed its
storage device paradigm to CAM, and the FreeBSD SCSI drivers were the
first to be changed/re-written.
The FreeBSD NCR/Symbios SCSI driver appears to be developed elsewhere
(Linux? NetBSD? OpenBSD) and ported back into FreeBSD.
I have found FreeBSD to be a superior alternative to Linux. FreeBSD
lacks the hype and political agenda of Linux. FreeBSD is slower to
support every oddball Windows gee-gaw than Linux. FreeBSD's "ports"
system is simple, elegant, works, and is stable, unlike RPM.
Having a mirror of the FreeBSD CVS archive has been quite useful too. It
makes monitoring the changes to FreeBSD (including ports and
documentation) possible.
The specific question was about PostgreSQL under FreeBSD. I've never
stressed PostgreSQL under FreeBSD so I can't specifically answer that
question. But I have stressed FreeBSD in other ways where it held its
head up high with Sun and SGI machines, and Linux didn't. YMMV.
Speaking of ports, in my previous employment, I found FreeBSD's
/usr/ports/ collection of 2000+ utilities to be the best source to
search for utilities and applications for the Sun and SGI systems. I
could find something that looks useful, painlessly download and try it,
and if it passed muster I already had the source code to move to the
other systems. And already had a working version under FreeBSD to
compare the ported Sun and SGI versions. This is where I discovered
PostgreSQL.
--
David Kelly N4HHE, dkelly@nospam.hiwaay.net
=====================================================================
The human mind ordinarily operates at only ten percent of its
capacity -- the rest is overhead for the operating system.
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: dkelly@hiwaay.net, drfrog@smartt.com
Subject: Re: [SQL] linux vs freebsd as postgres server
In-Reply-To: <199909170114.UAA33891@nospam.hiwaay.net>
References: <199909170114.UAA33891@nospam.hiwaay.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