X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id BB483D1B8BB for ; Thu, 28 Aug 2003 18:33:23 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 69524-08 for ; Thu, 28 Aug 2003 15:33:11 -0300 (ADT) Received: from mailav.tor1.inquent.com (mail.inquent.com [216.208.117.106]) by svr1.postgresql.org (Postfix) with ESMTP id 897BAD1B8AB for ; Thu, 28 Aug 2003 15:33:10 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by mailav.tor1.inquent.com (Postfix) with ESMTP id EC9D41024D; Thu, 28 Aug 2003 14:25:14 -0400 (EDT) Received: from [10.0.2.5] (unknown [10.0.2.5]) by mailav.tor1.inquent.com (Postfix) with ESMTP id 55FA610248; Thu, 28 Aug 2003 14:25:12 -0400 (EDT) Subject: Re: Queries sometimes take 1000 times the normal time From: Rod Taylor To: "Anders K. Pedersen" Cc: Postgresql Performance In-Reply-To: References: <1062033258.71328.2.camel@jester> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-MA5LX7Kj9shonc9JZCr3" Message-Id: <1062095603.79027.205.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.4 Date: Thu, 28 Aug 2003 14:33:24 -0400 X-Virus-Scanned: by AMaViS perl-11 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/434 X-Sequence-Number: 3250 --=-MA5LX7Kj9shonc9JZCr3 Content-Type: text/plain Content-Transfer-Encoding: quoted-printable > With regards to other jobs on the server, there is a MySQL server on it= =20 > as well, which from time to time has some multi-second queries generated= =20 > from a webserver also on this host, but the MySQL is running with nice=20 > 10 (PostgreSQL isn't nice'd). Do those MySQL queries hit disk hard? I've never seen PostgreSQL have hicups like you describe when running on a machine by itself. I have experienced similar issues when another process (cron job in my case) caused brief swapping to occur. --=-MA5LX7Kj9shonc9JZCr3 Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.3 (FreeBSD) iD8DBQA/Tkrz6DETLow6vwwRAtulAJ0YVZ1cDQCgs/woxrjoXHTDvCAYzACfUDm/ BVFt6GQZE39FcBGmXe8eX7Q= =RiGI -----END PGP SIGNATURE----- --=-MA5LX7Kj9shonc9JZCr3--