On Wed, Sep 26, 2012 at 5:39 AM, Alexander Shutyaev 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 su
Hi,
On Wed, 2012-09-26 at 13:39 +0400, Alexander Shutyaev wrote:
> We need to increase max_connections to 3000. When we tried to do this
> we got an error
Not an answer to your question but: Are you talking about 3k
*concurrent* connections? What are the server specs? I am not sure you
can h
Hi all!
We have at present the following parameters related to shared memory:
*postgres*
shared_buffers = 7GB
max_connections = 1500
max_locks_per_transaction = 1024
max_prepared_transactions = 0 (not set)
*system*
SHMALL = 2097152
SHMMAX = 17 670 512 640
SHMMNI = 4096
The amount of RAM is 24
> My last reply was made when I was exhausted. Sorry.
>
> Reconsidering
>
> According to my /usr/include/asm/shmparam.h,
> SHMMAX (should be) <= (PAGE_SIZE << _SHM_IDX_BITS) = (4096 bytes << 15)
> = 128MB.
>
> I still don't see where to find the PAGE_SIZE value, although 4096 seems
> to be
Gregory Bittar <[EMAIL PROTECTED]> writes:
> According to my /usr/include/asm/shmparam.h,
> SHMMAX (should be) <= (PAGE_SIZE << _SHM_IDX_BITS) = (4096 bytes << 15)
> = 128MB.
Mine is just:
#define SHMMAX 0x200
> I still don't see where to find the PAGE_SIZE value, although 4096 seems
> to
