| From: | "Paul Johnson" <paul(at)oxton(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Solaris 9 tuning |
| Date: | 2005-02-07 22:25:17 |
| Message-ID: | 3834.81.134.31.64.1107815117.squirrel@www.gradwell.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hi all, we have an Sun E3500 running Solaris 9. It's got 6x336MHz CPU and
10GB RAM.
I would like to know what /etc/system and postgresql_conf values are
recommended to deliver as much system resource as possible to Postgres. We
use this Sun box solely for single user Postgres data warehousing
workloads.
Changes made to /etc/system values are:
set shmsys:shminfo_shmmax=0xffffffff
set shmsys:shminfo_shmmni=256
set shmsys:shminfo_shmseg=256
set shmsys:shminfo_shmmin=1
set semsys:seminfo_semmap=256
set semsys:seminfo_semmni=512
set semsys:seminfo_semmns=512
set semsys:seminfo_semmsl=32
Changes made to postgresql.conf are:
shared_buffers = 500000
sort_mem = 2097152
vacuum_mem = 1000000
Thanks.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2005-02-08 02:22:42 | Re: Solaris 9 tuning |
| Previous Message | Merlin Moncure | 2005-02-07 19:52:53 | Re: Retry: Is this possible / slow performance? |