Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B73B99FBCD4 for ; Wed, 13 Jun 2007 13:33:29 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 22207-01 for ; Wed, 13 Jun 2007 13:33:26 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.170]) by postgresql.org (Postfix) with ESMTP id D2CBA9FB8AC for ; Wed, 13 Jun 2007 13:33:25 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id u2so489610uge for ; Wed, 13 Jun 2007 09:33:23 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=eK9ANkrJoJHgpW51/QQ3jIpeoOXlsgZuP06emUnoDfFRzZBvKQ/n/MK3RgonrVzYogLJiEhVrlHX4RyeQEpsggwwf+OcXWwVW3sHAlBSk5B2FztaWuQ0RXvMdVu2tCRsEyldw1kpKYvvmz49ygGZ4yCY+h9q1HmmNYy7nP/CHbU= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=t+LbSTSDUYGmie0eAaMjWn3RAXYfJdZZ4EySCCXp79b99e95QxZGSi/9Tiorozn6cKabL/oXIcz4f0dC9+QJM/kll+l5QZr5bTaiO3VkgBJjhGk1liYSlg7ycZ4r4zL1CBdqSUA8qZUGk0L+OT5dyosV3B9m/RZk91hYrRP+nF8= Received: by 10.78.147.6 with SMTP id u6mr276068hud.1181752403264; Wed, 13 Jun 2007 09:33:23 -0700 (PDT) Received: by 10.78.200.2 with HTTP; Wed, 13 Jun 2007 09:33:22 -0700 (PDT) Message-ID: <70c01d1d0706130933p2a9a348coa4d3c3bbf607c65a@mail.gmail.com> Date: Wed, 13 Jun 2007 09:33:22 -0700 From: "Mark Wong" To: "Markus Schiltknecht" Subject: Re: dbt2 NOTPM numbers Cc: "Heikki Linnakangas" , "Jim Nasby" , PFC , pgsql-performance@postgresql.org In-Reply-To: <466D6DD8.5060201@bluegap.ch> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <466428F7.5010808@bluegap.ch> <46642B33.6030101@enterprisedb.com> <46642F2E.3080509@bluegap.ch> <46646065.50806@bluegap.ch> <47BE2772-D774-4E2C-9D02-FD24C9F6BB90@decibel.org> <466D6A9E.4010703@bluegap.ch> <466D6B8A.6030509@enterprisedb.com> <466D6DD8.5060201@bluegap.ch> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/240 X-Sequence-Number: 25273 On 6/11/07, Markus Schiltknecht wrote: > Heikki Linnakangas wrote: > > Markus Schiltknecht wrote: > >> For dbt2, I've used 500 warehouses and 90 concurrent connections, > >> default values for everything else. > > > > 500? That's just too much for the hardware. Start from say 70 warehouses > > and up it from there 10 at a time until you hit the wall. I'm using 30 > > connections with ~100 warehouses on somewhat similar hardware. > > Aha! That's why... I've seen the '500' in some dbt2 samples and thought > it'd be a good default value. > > But it makes sense that the benchmark doesn't automatically 'scale down'... > > Stupid me. > > Thanks again! Hoping for larger NOTPMs. Yeah, I ran with 500+ warehouses, but I had 6 14-disk arrays of 15K RPM scsi drives and 6 dual-channel controllers... :) Regards, Mark