From: | "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov> |
---|---|
To: | "Phoenix Kiula" <phoenix(dot)kiula(at)gmail(dot)com>, <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: The right SHMMAX and FILE_MAX |
Date: | 2011-05-01 17:18:50 |
Message-ID: | 4DBD4FAA020000250003D0C9@gw.wicourts.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com> wrote:
> Now, according to my reading in the PG manual and this list, a
> good recommended value for SHMMAX is
>
> (shared_buffers * 8192)
Where did you see that? The amount of data buffered is the number
of shared buffers * 8KB. Taking shared_buffers as a number of bytes
and multiplying by 8K makes no sense at all. Any documentation
which can be read to indicate that should be fixed.
Besides that, there is shared memory space needed besides the actual
buffered disk pages, so you're not looking at the whole picture once
you stop dealing with "bytes squared".
-Kevin
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Smith | 2011-05-01 19:38:51 | Re: The right SHMMAX and FILE_MAX |
Previous Message | Marti Raudsepp | 2011-05-01 16:18:05 | Re: {Spam} Will shared_buffers crash a server |