Subject: Re: High CPU Load
From: =?ISO-8859-1?Q?J=E9r=F4me?= BENOIS <benois@argia-engineering.fr>
To: Markus Schaber <schabi@logix-tt.com>
Cc: pgsql-performance@postgresql.org
In-Reply-To: <450FBE15.9010905@logix-tt.com>
References: <1158239339.5226.17.camel@localhost.localdomain>
	<450A75DE.6050102@logix-tt.com>
	<1158590646.5665.71.camel@localhost.localdomain>
	<450FBE15.9010905@logix-tt.com>
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="=-ONA+zJNAwaVJc27BzG2Z"
Date: Tue, 19 Sep 2006 14:48:20 +0200
Message-Id: <1158670101.5204.14.camel@localhost.localdomain>
Mime-Version: 1.0


--=-ONA+zJNAwaVJc27BzG2Z
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable

Markus,

Le mardi 19 septembre 2006 =C3=A0 11:53 +0200, Markus Schaber a =C3=A9crit =
:
> Hi, Jerome,
>=20
> J=C3=A9r=C3=B4me BENOIS wrote:
>=20
> > Now i Have 335 concurrent connections, i decreased work_mem parameter t=
o
> > 32768 and disabled Hyper Threading in BIOS. But my CPU load is still
> > very important.
>=20
> What are your settings for commit_siblings and commit_delay?
It default :

#commit_delay =3D 01   # range 0-100000, inmicroseconds
#commit_siblings =3D 5 # range 1-1000

> > Tomorrow morning i plan to add 2Giga RAM ... But I don't understand why
> > my database server worked good with previous version of postgres and
> > same queries ...
>=20
> I don't think any more that it's the RAM, as you told you don't go into
> swap. It has to be something else.
Yes, i agree with you.
>=20
> Could you try logging which are the problematic queries, maybe they have
> bad plans for whatever reason.
>=20
> > I used already database pool on my application and when i decrease
> > number of connection my application is more slow ;-(
>=20
> Could you just make sure that the pool really uses persistent
> connections, and is not broken or misconfigured, always reconnect?
Yes it's persistent.

I plan to return to previous version : 7.4.6 in and i will reinstall all
in a dedicated server in order to reproduce and solve the problem.

J=C3=A9r=C3=B4me.

> HTH,
> Markus
>=20
--=20
J=C3=A9r=C3=B4me,

python -c "print '@'.join(['.'.join([w[::-1] for w in p.split('.')]) for
p in 'sioneb@gnireenigne-aigra.rf'.split('@')])"

--=-ONA+zJNAwaVJc27BzG2Z
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: Ceci est une partie de message
	=?ISO-8859-1?Q?num=E9riquement?= =?ISO-8859-1?Q?_sign=E9e?=

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.2 (GNU/Linux)

iD8DBQBFD+cUCDKlmlhpwnERAs8hAJ4gidKSTopVl8jHqC4EtPvwF1vkjwCggCrm
1A14QzYj9Zv8v3YHkZ0jx9Q=
=I+T/
-----END PGP SIGNATURE-----

--=-ONA+zJNAwaVJc27BzG2Z--