writes: > > Here are the shmall and the shmax params of my server: > > #cat /proc/sys/kernel/shmmax 68719476736 > > #cat /proc/sys/kernel/shmall 4294967296 >=20 > 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. >=20 > regards=2C tom lane = --_0aabdf70-83ef-422c-b941-e7e3cbd8678c_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Thank you for your answer. I think the value of shmall I have is very commo= n cause I've seen it many times in other servers.

Do you think there ma= ybe a link between the request size of postgres and the swap size?

Here is the output of free -m

free -m

=3B =3B =3B =3B =3B =3B &= nbsp=3Btotal =3B =3B =3B used =3B =3B =3B fre= e =3B =3B shared =3B =3Bbuffers =3B =3B cache= d

Mem: =3B =3B =3B =3B =3B7867 =3B = =3B =3B 1860 =3B =3B =3B 6007 =3B =3B &n= bsp=3B =3B =3B0 =3B =3B =3B =3B =3B5 &nb= sp=3B =3B =3B =3B595

-/+ buffers/cache: =3B &= nbsp=3B =3B 1258 =3B =3B =3B 6609

Swap: = =3B =3B =3B =3B 1023 =3B =3B =3B =3B &nb= sp=3B2 =3B =3B =3B 1021

Regards=2C<= /div>

>=3B From: tgl@sss.pg= h.pa.us
>=3B To: datatanger@hotmail.fr
>=3B CC: pgsql-docs@postgr= esql.org
>=3B Subject: Re: [DOCS] Issue with SHMALL parameter
>= =3B Date: Tue=2C 18 Sep 2012 12:07:46 -0400
>=3B
>=3B data tange= r <=3Bdatatanger@hotmail.fr>=3B writes:
>=3B >=3B Here are the s= hmall and the shmax params of my server:
>=3B >=3B #cat /proc/sys/ke= rnel/shmmax 68719476736
>=3B >=3B #cat /proc/sys/kernel/shmall = 4294967296
>=3B
>=3B SHMALL is measured in pages not bytes on= Linux. I wonder if that value
>=3B is too large and is causing an in= ternal integer overflow in the kernel.
>=3B
>=3B regards=2C t= om lane

= --_0aabdf70-83ef-422c-b941-e7e3cbd8678c_--