public inbox for [email protected]
help / color / mirror / Atom feedFrom: Adam Manock <[email protected]>
To: Justin Clift <[email protected]>
Cc: [email protected]
Subject: Re: Performance tuning for linux, 1GB RAM, dual CPU?
Date: Thu, 12 Jul 2001 20:32:10 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<[email protected]>
<[email protected]>
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.
view thread (15+ messages) latest in thread
reply
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 using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Performance tuning for linux, 1GB RAM, dual CPU?
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox