Thank you so much for the script.
~deepak
On Jan 22, 2011, at 10:18 AM, Greg Smith wrote:
> DM wrote:
>> RAM = 16GB, what value should i set for shmall?
>
> Given that PostgreSQL rarely sees increasing improvement as shared_buffers
> goes over 50% of RAM, I just use that figure for the shmal
DM wrote:
RAM = 16GB, what value should i set for shmall?
Given that PostgreSQL rarely sees increasing improvement as
shared_buffers goes over 50% of RAM, I just use that figure for the
shmall and then compute shmmax based on the page size to match it. I
use the attached script to do all th
On Fri, Jan 21, 2011 at 6:34 PM, DM wrote:
> Firstof all sorry for posting linux kernel question in pgsql-general, but i
> am trying to figure out what value to set for postgresql db server.
>
> RAM = 16GB, what value should i set for shmall?
>
> If i set shmall to 4294967296 (4GB),
shmall is mea
Firstof all sorry for posting linux kernel question in pgsql-general, but i
am trying to figure out what value to set for postgresql db server.
RAM = 16GB, what value should i set for shmall?
If i set shmall to 4294967296 (4GB), current PAGE_SIZE is 4096 should i need
to set my shmmax = 429496729
