Date: Thu, 24 May 2012 11:57:37 -0400
From: Stephen Frost <sfrost@snowman.net>
To: "Rajesh Kumar. Mallah" <mallah@tradeindia.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: High load average in 64-core server ,
  no I/O wait and CPU is idle
Message-ID: <20120524155737.GP1267@tamriel.snowman.net>
References: 
 <20061179.187311337829720826.JavaMail.root@zmbox01.trade-india-local.com>
	<33304216.187761337830749805.JavaMail.root@zmbox01.trade-india-local.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="o0Vsbun0CJ9H5mm4"
Content-Disposition: inline
In-Reply-To: 
 <33304216.187761337830749805.JavaMail.root@zmbox01.trade-india-local.com>
User-Agent: Mutt/1.5.21 (2010-09-15)


--o0Vsbun0CJ9H5mm4
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Rajesh,

* Rajesh Kumar. Mallah (mallah@tradeindia.com) wrote:
> We are  puzzled why the CPU and DISK I/O system are not being utilized=20
> fully and would seek lists' wisdom on that.

What OS is this?  What kernel version?

> just a thought, will it be a good idea to partition the host hardware=20
> to 4 equal  virtual environments , ie 1 for master (r/w) and 3 slaves r/o
> and distribute the r/o load on the 3 slaves ?

Actually, it might help with 9.1, if you're really running into some
scalability issues in our locking area..  You might review this:

http://rhaas.blogspot.com/2012/04/did-i-say-32-cores-how-about-64.html

That's a pretty contrived test case, but I suppose it's possible your
case is actually close enough to be getting affected also..

	Thanks,

		Stephen

--o0Vsbun0CJ9H5mm4
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature

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

iEYEARECAAYFAk++WnEACgkQrzgMPqB3kijUygCgjw31GgHX6MYGcQAGNt4ZI6bg
GMQAn3cq42U2orTH5uCTG4YJys3uN3e3
=06OE
-----END PGP SIGNATURE-----

--o0Vsbun0CJ9H5mm4--