X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 8A8E8D1B34F for ; Wed, 19 May 2004 23:00:31 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 18002-03 for ; Wed, 19 May 2004 23:00:13 -0300 (ADT) Received: from srvr3.iniquinet.com (srvr2.iniquinet.com [64.240.87.12]) by svr1.postgresql.org (Postfix) with SMTP id F1EC8D1B1BD for ; Wed, 19 May 2004 23:00:08 -0300 (ADT) Received: (qmail 21165 invoked by uid 104); 20 May 2004 02:00:12 -0000 Received: from Robert_Creager@LogicalChaos.org by srvr3.iniquinet.com by uid 101 with qmail-scanner-1.15 (clamscan: 0.65. spamassassin: 2.55. Clear:SA:0(-7.7/6.0):. Processed in 33.358499 secs); 20 May 2004 02:00:12 -0000 Received: from unknown (HELO thunder.mshome.net) (216.58.165.126) by srvr3.iniquinet.com with SMTP; 20 May 2004 01:59:38 -0000 Received: from localhost.localdomain (thunder.mshome.net [192.168.0.250]) by thunder.mshome.net (Postfix) with ESMTP id 071CC705C8; Wed, 19 May 2004 19:59:38 -0600 (MDT) Received: from logicalchaos.org (thunder.mshome.net [192.168.0.250]) by thunder.mshome.net (Postfix) with SMTP id 53DC3701EA; Wed, 19 May 2004 19:59:34 -0600 (MDT) Date: Wed, 19 May 2004 19:59:26 -0600 From: Robert Creager To: Bruce Momjian Cc: pg@fastcrypt.com, Josh Berkus , =?ISO-8859-1?Q?Dirk?= =?ISO-8859-1?Q?=5FLutzeb=E4ck?= , ohp@pyrenet.fr, Tom Lane , Joe Conway , "scott.marlowe" , pgsql-performance@postgresql.org, Neil Conway Subject: Re: Wierd context-switching issue on Xeon Message-Id: <20040519195926.3c5fa3bc@thunder.mshome.net> In-Reply-To: <200405200120.i4K1KKm06350@candle.pha.pa.us> References: <1083512362.25096.131.camel@localhost.localdomain> <200405200120.i4K1KKm06350@candle.pha.pa.us> Organization: Starlight Vision, LLC. X-Mailer: Sylpheed version 0.9.10claws (GTK+ 1.2.10; i586-mandrake-linux-gnu) Mime-Version: 1.0 Content-Type: multipart/signed; protocol="application/pgp-signature"; micalg="pgp-sha1"; boundary="Signature=_Wed__19_May_2004_19_59_26_-0600_qr.ctZpT0duCxZPR" X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/159 X-Sequence-Number: 6990 --Signature=_Wed__19_May_2004_19_59_26_-0600_qr.ctZpT0duCxZPR Content-Type: text/plain; charset=US-ASCII Content-Disposition: inline Content-Transfer-Encoding: 7bit When grilled further on (Wed, 19 May 2004 21:20:20 -0400 (EDT)), Bruce Momjian confessed: > > Did we ever come to a conclusion about excessive SMP context switching > under load? > I just figured out what was causing the problem on my system Monday. I'm using the pg_autovacuum daemon, and it was not vacuuming my db. I've no idea why and didn't get a chance to investigate. This lack of vacuuming was causing a huge number of context switches and query delays. the queries that normally take .1 seconds were taking 11 seconds, and the context switches were averaging 160k/s, peaking at 190k/s Unfortunately, I was under pressure to fix the db at the time so I didn't get a chance to play with the patch. I restarted the vacuum daemon, and will keep an eye on it to see if it behaves. If the problem re-occurs, is it worth while to attempt the different patch delay settings? Cheers, Rob -- 19:45:40 up 21 days, 2:30, 4 users, load average: 2.03, 2.09, 2.06 Linux 2.6.5-01 #7 SMP Fri Apr 16 22:45:31 MDT 2004 --Signature=_Wed__19_May_2004_19_59_26_-0600_qr.ctZpT0duCxZPR Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) iEYEARECAAYFAkCsEQYACgkQLQ/DKuwDYzkKFACfRyQ1FLQ9o1u9gX+4OBXdGtqn UhUAoIJ3vfYVjNU0bm6xGNycKOobtIX6 =WXZG -----END PGP SIGNATURE----- --Signature=_Wed__19_May_2004_19_59_26_-0600_qr.ctZpT0duCxZPR--