Reply-To: <gnanam@zoniac.com>
From: "Gnanakumar" <gnanam@zoniac.com>
To: "'Tomas Vondra'" <tv@fuzzy.cz>
Cc: "'Vitalii Tymchyshyn'" <tivv00@gmail.com>,
	<pgsql-performance@postgresql.org>
References: <006301cd07fd$358ebe40$a0ac3ac0$@com> <4F6AF3FE.30407@gmail.com>
	<dc1f59dfd626334d6f37d5a6ffb97bb9.squirrel@sq.gransy.com>
	<008e01cd0817$06418680$12c49380$@com>
	<1bbfac04d1ec4a2708e47593dc84ba8c.squirrel@sq.gransy.com>
In-Reply-To: <1bbfac04d1ec4a2708e47593dc84ba8c.squirrel@sq.gransy.com>
Subject: Re: Write workload is causing severe slowdown in Production
Date: Thu, 22 Mar 2012 17:40:29 +0530
Organization: Zoniac Software Private Limited
Message-ID: <00b601cd0824$c8dfd6d0$5a9f8470$@com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Thread-Index: Ac0IGJQRxpVW+ByNQByMQHjEErYfCwACyOeQ
Content-Language: en-us

> So, what else is running on the system? Because if there's 35GB RAM =
and
> the shared buffers are 1.5GB, then there's about 33GB for page cache.
> Something like 16GB would be a conservative setting.

Yes, you guessed it right.  Both Web server and DB server are running in =
the same machine.

> I'm not saying this will fix the issues, but maybe it shows that =
something
> else is running on the box and maybe that's the culprit, not =
PostgreSQL?

Based on my observations and analysis, I'm sure that database write =
operation "is" causing the slowdown, but not because of other =
applications running in the same server.

> Then install the app again and collect as much info as possible. =
Otherwise
> it's all just wild guesses.

OK.