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 8041FD1B8A3 for ; Thu, 28 Aug 2003 01:14:31 +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 91122-05 for ; Wed, 27 Aug 2003 22:14:03 -0300 (ADT) Received: from mailav.tor1.inquent.com (mail.inquent.com [216.208.117.106]) by svr1.postgresql.org (Postfix) with ESMTP id 5B307D1B550 for ; Wed, 27 Aug 2003 22:13:59 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by mailav.tor1.inquent.com (Postfix) with ESMTP id 581021025B; Wed, 27 Aug 2003 21:06:07 -0400 (EDT) Received: from [192.168.1.200] (dyn-133-83.tor.dsl.tht.net [134.22.133.83]) by mailav.tor1.inquent.com (Postfix) with ESMTP id 28B2710248; Wed, 27 Aug 2003 21:06:05 -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: Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-YhYgy3Doxue4upJh2YKq" Message-Id: <1062033258.71328.2.camel@jester> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.4 Date: Wed, 27 Aug 2003 21:14:19 -0400 X-Virus-Scanned: by AMaViS perl-11 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/358 X-Sequence-Number: 3174 --=-YhYgy3Doxue4upJh2YKq Content-Type: text/plain Content-Transfer-Encoding: quoted-printable > Currently there's only a few users in the database for testing purposes,= =20 > and most of the time the user lookup's take 2-3 ms (I have syslog'ing of= =20 > queries and duration turned on), but several times per hour the duration= =20 > for one of the queries is 2-3 seconds (1000 times larger), while the=20 > surrounding lookups take the usual 2-3 ms. Are there any other jobs running at the time of these excessive queries? --=-YhYgy3Doxue4upJh2YKq 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/TVdq6DETLow6vwwRAthZAJ9F9d2a/jlNXbV78ppkWXTaGCopFQCfaN1n Hao4JtQXlcR4cYWY7wbpeGU= =+wtK -----END PGP SIGNATURE----- --=-YhYgy3Doxue4upJh2YKq--