X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 964A89FA508 for ; Sun, 23 Jul 2006 20:47:35 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 06512-01 for ; Sun, 23 Jul 2006 23:47:27 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.200]) by postgresql.org (Postfix) with ESMTP id 5676B9FA48B for ; Sun, 23 Jul 2006 20:47:27 -0300 (ADT) Received: by nz-out-0102.google.com with SMTP id z3so342291nzf for ; Sun, 23 Jul 2006 16:47:25 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth; b=th5N0VuKBOuKTV6r5ApsW4qLAHorc9F52/JI1+s7TDYYS/fNexap9ke2GtqkBYmsnD/63Y36V8R7kCSmJm64J9xKDEONThvA0XRNEm708oc+ZI3AXFozu5orzJT0QdiBryEfMbwBCl09MGVIqCOwQN1neYva1Yp03YUYxeCc3Fk= Received: by 10.65.116.7 with SMTP id t7mr2678213qbm; Sun, 23 Jul 2006 16:47:25 -0700 (PDT) Received: by 10.64.179.18 with HTTP; Sun, 23 Jul 2006 16:47:25 -0700 (PDT) Message-ID: <5f820f750607231647u466597d9g25ec5cf5157e2cbf@mail.gmail.com> Date: Sun, 23 Jul 2006 19:47:25 -0400 From: "Denis Lussier" To: "Petronenko D.S." Subject: Re: postgres benchmarks Cc: pgsql-performance@postgresql.org In-Reply-To: <44C0D822.60604@gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_69253_20699650.1153698445764" References: <44C0D822.60604@gmail.com> X-Google-Sender-Auth: d7d93db4d8c86a06 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.696 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_40_50, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200607/228 X-Sequence-Number: 20088 ------=_Part_69253_20699650.1153698445764 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline At EnterpriseDB we make extensive use of the OSDB's OLTP Benchmark. We also use the Java based benchamrk called BenchmarkSQL from SourceForge. Both of these benchmarks are update intensive OLTP tests that closely mimic the Traqnsaction Processing COuncil's TPC-C benchmark. Postgres also ships with pg_bench, which is a simpler OLTP benchmark that I believe is similar to a TPC-B. --Denis Lussier CTO http://www.enterprisedb.com On 7/21/06, Petronenko D.S. wrote: > > Hello, > > does anybody use OSDB benchmarks for postgres? > if not, which kind of bechmarks are used for postgres? > > Thanks, > Denis. > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > ------=_Part_69253_20699650.1153698445764 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
 
At EnterpriseDB we make extensive use of the OSDB's OLTP Benchmark.   We also use the Java based benchamrk called BenchmarkSQL from SourceForge.  Both of these benchmarks are update intensive OLTP tests that closely mimic the Traqnsaction Processing COuncil's TPC-C benchmark.
 
Postgres also ships with pg_bench, which is a simpler OLTP benchmark that I believe is similar to a TPC-B.
 
--Denis Lussier
  CTO
On 7/21/06, Petronenko D.S. <petronenko@gmail.com> wrote:
Hello,

does anybody use OSDB benchmarks for postgres?
if not, which kind of bechmarks are used for postgres?

Thanks,
Denis.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@postgresql.org so that your
      message can get through to the mailing list cleanly

------=_Part_69253_20699650.1153698445764--