Subject: Re: PostgreSQL
To: Marcin Jessa <>
From: Daniel Carosone <>
List: current-users
Date: 02/02/2006 11:56:55
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Thu, Feb 02, 2006 at 12:06:35AM +0000, Marcin Jessa wrote:
> Now, my O.S of choice is NetBSD and my open source database of choice is =
> I was wondering if any of you have experience with PostgreSQL's performan=
ce on=20
> NetBSD 3.0 or CURRENT compared to other open source O.S's.=20

To ensure you're getting fair comparisons, you need to make sure that
the installations you're testing have the same policy for things like
flushing writes to disk and syncing disk caches.  This is important
for both the DBMS config as well as OS settings. MySQL/PostgreSQL and
NetBSD/Linux all have different defaults and tunables, and not paying
attention to these can skew your comparisons.

Once you get past that, there's little important difference between
the OS choices.  Of far greater importance to overall performance is
the general database tuning that applies regardless of OS:

 * configuration of disk hardware subsystem for concurrency=20
   (spindles, raid styles, tablespace layouts, etc)
 * memory allocation and similar sizing for WAL, cache, etc
 * indexes, query optimisation and everything else from EXPLAIN

Content-Type: application/pgp-signature
Content-Disposition: inline

Version: GnuPG v1.4.2 (NetBSD)