Re: shared memory settings

From: Vick Khera <vivek(at)khera(dot)org>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: shared memory settings
Date: 2012-10-01 14:57:45
Message-ID: CALd+dce8ajYR-4xVdvZL8b7fMpnUykra6xDvCpNyCzEX_kqoTg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Sep 26, 2012 at 5:39 AM, Alexander Shutyaev <shutyaev(at)gmail(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Moshe Jacobson 2012-10-01 15:21:41 Re: What's faster? BEGIN ... EXCEPTION or CREATE TEMP TABLE IF NOT EXISTS?
Previous Message Lonni J Friedman 2012-10-01 14:56:16 Re: strange hot_standby behaviour