Re: PostgreSQL

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 PostgreSQL.
> I was wondering if any of you have experience with PostgreSQL's performance on 
> NetBSD 3.0 or CURRENT compared to other open source O.S's. 

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 
   (spindles, raid styles, tablespace layouts, etc)
 * memory allocation and similar sizing for WAL, cache, etc
 * indexes, query optimisation and everything else from EXPLAIN

--
Dan.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (NetBSD)

iD8DBQFD4VjXEAVxvV4N66cRAilPAKDrUWVh9yESevz37KJnBQQJc18tcQCfUFxu
Xo4cGrdQuSgxtTtcLCgTKUI=
=wmQ3
-----END PGP SIGNATURE-----