Thank you for your answer. I think the value of shmall I have is very common
cause I've seen it many times in other servers.Do you think there maybe a link
between the request size of postgres and the swap size?
Here is the output of free -m
free -m total used free shared buffers
cachedMem: 7867 1860 6007 0 5
595-/+ buffers/cache: 1258 6609Swap: 1023 2
1021
Regards,
> From: [email protected]
> To: [email protected]
> CC: [email protected]
> Subject: Re: [DOCS] Issue with SHMALL parameter
> Date: Tue, 18 Sep 2012 12:07:46 -0400
>
> data tanger <[email protected]> writes:
> > Here are the shmall and the shmax params of my server:
> > #cat /proc/sys/kernel/shmmax 68719476736
> > #cat /proc/sys/kernel/shmall 4294967296
>
> SHMALL is measured in pages not bytes on Linux. I wonder if that value
> is too large and is causing an internal integer overflow in the kernel.
>
> regards, tom lane
