Search Postgresql Archives

Re: shared memory settings

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, Sep 26, 2012 at 5:39 AM, Alexander Shutyaev <shutyaev@xxxxxxxxx> wrote:
SHMALL = 2097152

SHMALL * PAGE_SIZE = 2097152 * 4096 = 8589934592

which is smaller than your requested allocation.

SHMALL and SHMMAX need to be sized together.  You likely want 4314090 as your SHMALL.

Bug as Devrim says, are you sure you can handle that?  Perhaps you want a connection pooler instead.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux