| From: | Greg Smith <greg(at)2ndquadrant(dot)com> |
|---|---|
| To: | DM <dm(dot)aeqa(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: SHMMAX and SHMALL question |
| Date: | 2011-01-22 18:18:29 |
| Message-ID: | 4D3B1F75.8040405@2ndquadrant.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 the hard work, haven't found a Linux
system yet it didn't do the right thing on. It sounds like you might
have the math on the relation between the two backwards, look at the
output and code of this once and that should sort things out for you.
--
Greg Smith 2ndQuadrant US greg(at)2ndQuadrant(dot)com Baltimore, MD
PostgreSQL Training, Services, and 24x7 Support www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books
| Attachment | Content-Type | Size |
|---|---|---|
| shmsetup | text/plain | 915 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrus Moor | 2011-01-22 19:40:55 | Re: Server stops responding in every week |
| Previous Message | Christian Ullrich | 2011-01-22 17:40:36 | Re: Using copy for WAL archiving on Windows |