X-Original-To: pgsql-benchmarks-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 55A6DD1B262 for ; Tue, 15 Jun 2004 03:03:54 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 41616-05 for ; Tue, 15 Jun 2004 06:03:45 +0000 (GMT) Received: from rediffmail.com (unknown [203.199.83.148]) by svr1.postgresql.org (Postfix) with SMTP id B98C3D1B1BC for ; Tue, 15 Jun 2004 03:03:42 -0300 (ADT) Received: (qmail 28536 invoked by uid 510); 15 Jun 2004 06:03:40 -0000 Date: 15 Jun 2004 06:03:40 -0000 Message-ID: <20040615060340.28535.qmail@webmail26.rediffmail.com> Received: from unknown (203.199.33.2) by rediffmail.com via HTTP; 15 jun 2004 06:03:40 -0000 MIME-Version: 1.0 From: "Neeraj " Reply-To: "Neeraj " To: pgsql-benchmarks@postgresql.org, pgsql-performance@postgresql.org, pgsql-general@postgresql.org Subject: Interpreting OSDB Results Content-type: multipart/alternative; boundary="Next_1087279420---0-203.199.83.148-28517" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.9 tagged_above=0.0 required=5.0 tests=HTML_IMAGE_ONLY_10, HTML_MESSAGE, MSGID_FROM_MTA_HEADER X-Spam-Level: * X-Archive-Number: 200406/2 X-Sequence-Number: 13 This is a multipart mime message --Next_1087279420---0-203.199.83.148-28517 Content-type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline

Hi All,

Im testing my postgres 7.3.2 db on redhat 9.0 using osdb 0.16. I couldnot f= ind any docuementation  for interpreting the results obtained. Im doin= g multiuser (10 users) test. I've two different con figurations for postgre= sql.conf. In one it takes 44 mins to finish while in other it takes 18 mins= to finish. But tps (both mixed IR & mixed OLTP) is very high in first = one. Also i want to know relation between tuples/sec and transactions/sec. =

Thanks & Regards

Neeraj Malhotra

--Next_1087279420---0-203.199.83.148-28517 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi All, Im testing my postgres 7.3.2 db on redhat 9.0 using osdb 0.16. I couldnot f= ind any docuementation for interpreting the results obtained. Im doing mul= tiuser (10 users) test. I've two different con figurations for postgresql.c= onf. In one it takes 44 mins to finish while in other it takes 18 mins to f= inish. But tps (both mixed IR & mixed OLTP) is very high in first one. Also= i want to know relation between tuples/sec and transactions/sec.=20 Thanks & Regards Neeraj Malhotra --Next_1087279420---0-203.199.83.148-28517--