| From: | Adam Manock <abmanock(at)planetcable(dot)net> |
|---|---|
| To: | Justin Clift <justin(at)postgresql(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Performance tuning for linux, 1GB RAM, dual CPU? |
| Date: | 2001-07-13 00:32:10 |
| Message-ID: | 5.1.0.14.2.20010712201157.01e11a80@pop.planetcable.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general pgsql-hackers |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | rjmaia | 2001-07-13 15:08:22 | Error accessing PostgreSQL |
| Previous Message | Tony Reina | 2001-07-13 00:16:42 | Determining which users are logged onto the db |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joseph Shraibman | 2001-07-13 00:33:38 | Re: news server access down? |
| Previous Message | Guy Fraser | 2001-07-12 23:36:51 | Re: vacuum and 24/7 uptime |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Hiroshi Inoue | 2001-07-13 00:42:19 | Re: Rule recompilation |
| Previous Message | Guy Fraser | 2001-07-12 23:18:59 | Re: Re: Postgresql bulk fast loader |