X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 2CCF69DCB92 for ; Wed, 7 Dec 2005 12:24:42 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 04991-05 for ; Wed, 7 Dec 2005 12:24:40 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from koolancexeon.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id AE34B9DCABF for ; Wed, 7 Dec 2005 12:24:37 -0400 (AST) Received: mail.g2switchworks.com 10.10.1.8 from 10.10.1.37 10.10.1.37 via HTTP with MS-WebStorage 6.5.6944 Received: from state.g2switchworks.com by mail.g2switchworks.com; 07 Dec 2005 10:24:33 -0600 Subject: Re: High context switches occurring From: Scott Marlowe To: Tom Lane Cc: Bruce Momjian , Tatsuo Ishii , Postgresql Performance In-Reply-To: <24708.1133930968@sss.pgh.pa.us> References: <200512070434.jB74Y4o20004@candle.pha.pa.us> <24708.1133930968@sss.pgh.pa.us> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1133972672.11803.23.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Wed, 07 Dec 2005 10:24:33 -0600 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[UNPARSEABLE_RELAY=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200512/233 X-Sequence-Number: 16054 On Tue, 2005-12-06 at 22:49, Tom Lane wrote: > Bruce Momjian writes: > > Tom Lane wrote: > >> 1. You don't want number of clients (-c) much higher than scaling factor > >> (-s in the initialization step). > > > Should we throw a warning when someone runs the test this way? > > Not a bad idea (though of course only for the "standard" scripts). > Tatsuo, what do you think? Just to clarify, I think the pgbench program should throw the warning, not postgresql itself. Not sure if that's what you were meaning or not. Maybe even have it require a switch to run in such a mode, like a --yes-i-want-to-run-a-meaningless-test switch or something.