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
Date: Thu, 24 May 2012 11:57:37 -0400
Message-ID: <20120524155737.GP1267@tamriel.snowman.net> (raw)
In-Reply-To: <33304216.187761337830749805.JavaMail.root@zmbox01.trade-india-local.com>
References: <20061179.187311337829720826.JavaMail.root@zmbox01.trade-india-local.com>
<33304216.187761337830749805.JavaMail.root@zmbox01.trade-india-local.com>
Rajesh,
* Rajesh Kumar. Mallah (mallah@tradeindia.com) wrote:
> We are puzzled why the CPU and DISK I/O system are not being utilized
> 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
> 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
Attachments:
signature.asc (application/pgp-signature, 197B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: sfrost@snowman.net, mallah@tradeindia.com
Subject: Re: High load average in 64-core server , no I/O wait and CPU is idle
In-Reply-To: <20120524155737.GP1267@tamriel.snowman.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox