Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id C97A5633B55 for ; Sat, 27 Mar 2010 17:06:16 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 87491-10 for ; Sat, 27 Mar 2010 20:06:01 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-bw0-f216.google.com (mail-bw0-f216.google.com [209.85.218.216]) by mail.postgresql.org (Postfix) with ESMTP id C573763325F for ; Sat, 27 Mar 2010 17:06:04 -0300 (ADT) Received: by bwz8 with SMTP id 8so3834895bwz.3 for ; Sat, 27 Mar 2010 13:06:03 -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 :content-type:content-transfer-encoding:mime-version:subject:date :x-mailer; bh=JNj4F2YNtTxX61/g0BfHYzP+e1n3tMdfFqR5AF3fagc=; b=uBbAXrmV9E3qzZ+JZMNPdsRIoH+0Xj0D0uF8mAGgA6JoahXfvk//oKMPfQDWEmY+gT IZtbiT9GgRi5ah9XZj0AfqQf3vaRe1hLELHYAdmmvv/4I0fhecvAiu3XO7rBXhuGZGqH 0QMcZ+KUtURUuCIXBwb1NYKjUk/sm8yrjxa1I= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:from:to:content-type:content-transfer-encoding :mime-version:subject:date:x-mailer; b=E+7e6hlLOffsopiUjUgv5xViwo9Me3dQ+JSIupQoQij+Vg0YIkOq0JvzDRM5H8eL69 JCGstaBO0R8A3JWhzjzudy2JWQsLEb2Hb0vIAlNoVo0YeTXX1PKJELTw2tVcnvJTY7pC worCf4h9WdKz87cW2cjF6j77ylPEo3qBiD8J0= Received: by 10.204.5.130 with SMTP id 2mr181908bkv.189.1269720362555; Sat, 27 Mar 2010 13:06:02 -0700 (PDT) Received: from [192.168.1.113] ([85.105.92.53]) by mx.google.com with ESMTPS id 24sm20666239bkr.18.2010.03.27.13.06.01 (version=TLSv1/SSLv3 cipher=RC4-MD5); Sat, 27 Mar 2010 13:06:01 -0700 (PDT) Message-Id: From: Reydan Cankur To: pgsql-performance@postgresql.org Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v935.3) Subject: Pgbench TPS Calculation Date: Sat, 27 Mar 2010 22:05:59 +0200 X-Mailer: Apple Mail (2.935.3) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=-10 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 201003/347 X-Sequence-Number: 38172 Hi, I am using pgbench for running tests on PostgreSQL. I have a few questions; 1) For calculating time to get the TPS, is pgbench using the wall clock time or cpu time? 2)How is TPS calculated? Thanks in advance, Reydan