Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 86D062E2D69 for ; Fri, 14 Mar 2008 07:17:30 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 02089-10 for ; Fri, 14 Mar 2008 07:17:13 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from mu-out-0910.google.com (mu-out-0910.google.com [209.85.134.188]) by postgresql.org (Postfix) with ESMTP id D54952E3090 for ; Fri, 14 Mar 2008 07:17:17 -0300 (ADT) Received: by mu-out-0910.google.com with SMTP id i10so9468966mue.5 for ; Fri, 14 Mar 2008 03:17:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:from:to:in-reply-to:content-type:content-transfer-encoding:mime-version:subject:date:references:x-mailer; bh=ICo73sp5onDJt87wFj8Yp7rct7XfOjY17N8rLTG3J7E=; b=YkeI52HRF6e994tFb58pml8HniAyQbJsgw2Kf9LTqukVGhTD28majJhcLqin5bcy+dPuxaFXGBOqK2R099ue+AZAS6BvE4oaZ2I6yQdjLsmi4cUehCflvMviudZUXGPl+G0ztF3wGn+KQiv842SwNIECXyU2jR3FyHDKwcHqMN0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:from:to:in-reply-to:content-type:content-transfer-encoding:mime-version:subject:date:references:x-mailer; b=O3Oi8ou3JU3fI1oIrJbHd2cBplpiUH9yby+/RBYBXWeVw7l7xegUXVdCwwv5vtvA1r5KM4G2WDN5YpSf1cLjTu6rGnhvjedTXSRZeNJjEyUWf/6vZuaUzvtN43imMYBsa1bF/cwe3TnYzpwzWR1omdL9LrCp3wPx/dgOP4r/+Gg= Received: by 10.78.170.6 with SMTP id s6mr30106249hue.58.1205489835790; Fri, 14 Mar 2008 03:17:15 -0700 (PDT) Received: from ?5.7.226.106? ( [85.18.201.163]) by mx.google.com with ESMTPS id j9sm15018788mue.6.2008.03.14.03.17.14 (version=TLSv1/SSLv3 cipher=OTHER); Fri, 14 Mar 2008 03:17:15 -0700 (PDT) Message-Id: <4FDAF452-E6CD-46CA-96DA-8674E496C5D4@gmail.com> From: Enrico Sirola To: pgsql-performance@postgresql.org In-Reply-To: <2226A814-87D8-4531-AC26-D1E7B44227C0@gmail.com> Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v919.2) Subject: Re: 8.3 write performance Date: Fri, 14 Mar 2008 11:17:12 +0100 References: <2226A814-87D8-4531-AC26-D1E7B44227C0@gmail.com> X-Mailer: Apple Mail (2.919.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/304 X-Sequence-Number: 29258 Hi, I follow up myself: I was using pgbench with the wrong scale size. With the configuration I posted before and scale=100 I Get the following: sudo -u postgres pgbench -c 10 -t 10000 -s 100 starting vacuum...end. transaction type: TPC-B (sort of) scaling factor: 100 number of clients: 10 number of transactions per client: 10000 number of transactions actually processed: 100000/100000 tps = 4399.753895 (including connections establishing) tps = 4405.228901 (excluding connections establishing) sudo -u postgres pgbench -c 50 -t 10000 -s 100 starting vacuum...end. transaction type: TPC-B (sort of) scaling factor: 100 number of clients: 50 number of transactions per client: 10000 number of transactions actually processed: 500000/500000 tps = 3208.532479 (including connections establishing) tps = 3211.816174 (excluding connections establishing) which I think is in line with the expectations. Thanks, e.