postgres on Solaris 10 with ZFS

From: abhishekgautam009(at)gmail(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: postgres on Solaris 10 with ZFS
Date: 2009-12-14 17:05:16
Message-ID: d0e8fd680912140905n768ae26dwe087f0d6fb0fc25f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All,

I have solaris 10 update5 sunfire X4240 with 32GB RAM and ZFS system.I am
having problem while configuring below parameters especially how shmmni
works ---

1) shmmax
2) shmmni
3) arc_max
4) shared_buffers

Since, it's a dedicated server i want to utilize all resources.As of now i
have set parameters as below --

1) shmmax -- 16GB ( size of single shared memory segment)
2) shmmni -- Default 100
3) arc_max -- 26 GB
4) shared_buffers -- 2 GB
5) effective_cache_size -- 5GB

Also, would it be possible if i can have more memory segment for same
postgesql.If yes How ?

Please help.

Regards,
AG

Browse pgsql-general by date

  From Date Subject
Next Message Dave Page 2009-12-14 17:10:25 Re: 8.4.2 - Windows Binaries
Previous Message Richard Broersma 2009-12-14 16:57:35 PG Windows - Installer Error