Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 8A6499FB934 for ; Mon, 11 Jun 2007 12:35:50 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 99251-02-2 for ; Mon, 11 Jun 2007 12:35:03 -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.175]) by postgresql.org (Postfix) with ESMTP id 82EA59FB9B9 for ; Mon, 11 Jun 2007 12:35:02 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id u2so1652430uge for ; Mon, 11 Jun 2007 08:35:01 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender; b=of1sFQrcwfcZGSu5o0Td2L9oOMnWhQCTTwLAE+2IIhgNEondetLVUGnUpyvt8odm7JCaIfA3EsRk/n+4okVKtrxNgzTPAK6kxvKOCHa06fXgRFL7GKKeA5pyLHysK+URm6BDTDNPIF6keN+g2Eyh8jU/BjEF5WPqlj7K8fh/FMI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:user-agent:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding:sender; b=Sj1KkNzwB974jmGP5MbxonijN1fp8OoeQG3wHMwEo7xx3FJrH9M2tLhBfjWS12/sd7E2qVtSPUVc61MyDOKSAWf4VpUm26TZmAOYW44pUDsnnocwhIiUaRULnoZTHE+nSq8JfSemUjWscx7bI9UGI7qwwfxCRYpl0p/0H63wie8= Received: by 10.67.31.17 with SMTP id i17mr4363750ugj.1181576101358; Mon, 11 Jun 2007 08:35:01 -0700 (PDT) Received: from ?172.24.32.61? ( [62.232.55.118]) by mx.google.com with ESMTP id y7sm8378104ugc.2007.06.11.08.34.59 (version=SSLv3 cipher=RC4-MD5); Mon, 11 Jun 2007 08:34:59 -0700 (PDT) Message-ID: <466D6B8A.6030509@enterprisedb.com> Date: Mon, 11 Jun 2007 16:34:34 +0100 From: Heikki Linnakangas User-Agent: Icedove 1.5.0.10 (X11/20070329) MIME-Version: 1.0 To: Markus Schiltknecht CC: Jim Nasby , PFC , pgsql-performance@postgresql.org Subject: Re: dbt2 NOTPM numbers 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> In-Reply-To: <466D6A9E.4010703@bluegap.ch> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200706/188 X-Sequence-Number: 25221 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. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com