References: <50E4AAB1.9040902@optionshouse.com>
	<B994348460014EC7BA65F310E9D30EBD@BERNICE>
	<50EC6549.3090503@optionshouse.com>
	<CAOR=d=2g4iH+4U2Dkn2EZtTnZrescxp+MW10zehVUzX6a5GXSA@mail.gmail.com>
	<50EC6742.4090303@optionshouse.com>
	<CAOR=d=0R1GPVfhhy9w2+j=czNvgtbA519rY6-Or6sNegvQmdFQ@mail.gmail.com>
	<50EC743E.1040209@optionshouse.com>
	<CABvEAQs7cRUH9PLHyTo-F+0t8=iKgX8N3ZSfCuzeSWXBJ9hM3w@mail.gmail.com>
	<510015A5.8060601@comcast.net>
Mime-Version: 1.0 (1.0)
In-Reply-To: <510015A5.8060601@comcast.net>
Content-Type: text/plain;
	charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Message-Id: <3EB000F8-7FC6-4693-9451-8A263DBD0452@gmail.com>
Cc: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
From: Evgeniy Shishkin <itparanoia@gmail.com>
Subject: Re: autovacuum fringe case?
Date: Wed, 23 Jan 2013 23:03:25 +0400
To: AJ Weber <aweber@comcast.net>
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org


On 23.01.2013, at 20:53, AJ Weber <aweber@comcast.net> wrote:

> I have a server that is IO-bound right now (it's 4 cores, and top indicat=
es the use rarely hits 25%, but the Wait spikes above 25-40% regularly).  T=
he server is running postgresql 9.0 and tomcat 6.  As I have mentioned in a=
 previous thread, I can't alter the hardware to add disks unfortunately, so=
 I'm going to try and move postgresql off this application server to its ow=
n host, but this is a production environment, so in the meantime...
>=20
> Is it possible that some spikes in IO could be attributable to the autova=
cuum process?  Is there a way to check this theory?
>=20

Try iotop

> Would it be advisable (or even permissible to try/test) to disable autova=
cuum, and schedule a manual vacuumdb in the middle of the night, when this =
server is mostly-idle?
>=20
> Thanks for any tips.  I'm in a bit of a jam with my limited hardware.
>=20
> -AJ
>=20
>=20
>=20
> --=20
> Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance


--=20
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance