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. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
