Received: from regulus.blazenet.net (regulus.blazenet.net [24.104.0.39])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f6D0cNa34970;
	Thu, 12 Jul 2001 20:38:23 -0400 (EDT)
	(envelope-from abmanock@planetcable.net)
Received: from OPS-100.planetcable.net (ip1.29.blca.blazenet.net
 [24.104.29.1])
	by regulus.blazenet.net (8.9.3/8.9.3) with ESMTP id UAA28805;
	Thu, 12 Jul 2001 20:58:35 -0400 (EDT)
Message-Id: <5.1.0.14.2.20010712201157.01e11a80@pop.planetcable.net>
X-Sender: abmanock@pop.planetcable.net
X-Mailer: QUALCOMM Windows Eudora Version 5.1
Date: Thu, 12 Jul 2001 20:32:10 -0400
To: Justin Clift <justin@postgresql.org>
From: Adam Manock <abmanock@planetcable.net>
Subject: Re: Performance tuning for linux, 1GB RAM, dual CPU?
Cc: pgsql-general@postgresql.org
In-Reply-To: <3B4BC8BA.2AC613C4@postgresql.org>
References: <3B4AC78F.9A9A5B45@regaltronic.com>
	<5.1.0.14.2.20010710072714.0234d120@pop.planetcable.net>
	<20010710090607.M12723@datafoundry.net>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"; format=flowed
X-Archive-Number: 200107/467
X-Sequence-Number: 12451

At 01:32 PM 7/11/01 +1000, Justin Clift wrote:

 > Standardised benchmarks would be nice to though.
	Sure would be nice....

Here's some preliminary results of my testing...

System:	RedHat Linux 7.1, kernel 2.4.3smp (i686)
		Dual PIII 733 / 133FSB  1024MB RAM
		2 18Gb 10000rpm U160 SCSI drives, hardware RAID1
		
		added to /etc/sysctl.conf:
			kernel.shmmax = 268435456
			kernel.shmall = 268435456

PG 7.1.2	

postgresql-7.1.2-4PGDG binary rpm set
		
	relevant entries from postgresql.conf:
		max_connections = 32 	
		sort_mem = 4096
		shared_buffers = 32000
		fsync = true

The only benchmark I have is almost useless but I'll put it here anyway...

time ./pg_regress --schedule=parallel_schedule
(using postmaster on Unix socket, default port)
...
...
======================
  All 76 tests passed.
======================


real    0m40.784s
user    0m1.980s
sys     0m1.220s


Adam.