Hi all, we have an Sun E3500 running Solaris 9. It's got 6x336MHz CPU and

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

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


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to