Skip site navigation (1) Skip section navigation (2)

how big shmmax is good for Postgres...

From: Jessica Richard <rjessil(at)yahoo(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: how big shmmax is good for Postgres...
Date: 2008-07-10 10:53:40
Message-ID: 639285.44246.qm@web56404.mail.re3.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-performance
On a Linux system,  if the total memory is 4G and the shmmax is set to 4G, I know it is bad, but how bad can it be? Just trying to understand the impact the "shmmax" parameter can have  on Postgres  and the entire system after Postgres comes up on this number.

What is the reasonable setting for shmmax on a 4G total machine?

Thanks a lot,
Jessica



      

Responses

pgsql-performance by date

Next:From: Bill MoranDate: 2008-07-10 11:19:19
Subject: Re: how big shmmax is good for Postgres...
Previous:From: Ow Mun HengDate: 2008-07-10 09:34:41
Subject: Re: Altering a column type - Most efficient way

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group