Re: shared memory settings - Mailing list pgsql-general

From Vick Khera
Subject Re: shared memory settings
Date
Msg-id CALd+dce8ajYR-4xVdvZL8b7fMpnUykra6xDvCpNyCzEX_kqoTg@mail.gmail.com
Whole thread Raw
In response to shared memory settings  (Alexander Shutyaev <shutyaev@gmail.com>)
List pgsql-general
On Wed, Sep 26, 2012 at 5:39 AM, Alexander Shutyaev <shutyaev@gmail.com> 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.

pgsql-general by date:

Previous
From: Lonni J Friedman
Date:
Subject: Re: strange hot_standby behaviour
Next
From: Moshe Jacobson
Date:
Subject: Re: What's faster? BEGIN ... EXCEPTION or CREATE TEMP TABLE IF NOT EXISTS?