Postgres Pro
Downloads
Home   >   mailing lists

how big shmmax is good for Postgres... - Mailing list pgsql-performance

From Jessica Richard
Subject how big shmmax is good for Postgres...
Date
Msg-id 639285.44246.qm@web56404.mail.re3.yahoo.com
Whole thread Raw
Responses Re: how big shmmax is good for Postgres...  (Bill Moran <wmoran@collaborativefusion.com>)
Re: how big shmmax is good for Postgres...  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-performance
Tree view
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

pgsql-performance by date:

Previous
From: Ow Mun Heng
Date:
Subject: Re: Altering a column type - Most efficient way
Next
From: Bill Moran
Date:
Subject: Re: how big shmmax is good for Postgres...