X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 839C09DC868 for ; Tue, 21 Mar 2006 10:03:19 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 79932-01 for ; Tue, 21 Mar 2006 10:03:22 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.193]) by postgresql.org (Postfix) with ESMTP id C5AF99DC877 for ; Tue, 21 Mar 2006 10:03:16 -0400 (AST) Received: by wproxy.gmail.com with SMTP id i22so1309941wra for ; Tue, 21 Mar 2006 06:03:21 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=iI3rmnwJmnLuc3ovAAdtOV42asZTlzJd+Kk3OYTXtSFPNelSLr/1GsLsQbhPm4PZw7hfwxcgiXjEfuN1VOEbRgl+VHfJI/TyMDdViYknDJoQewTojMD/MUiDvzlYne74Ff9IN6DWJFOR/HdzQxJuvfIJ5uNAT9mgvJn1fNgUbCc= Received: by 10.65.113.11 with SMTP id q11mr371304qbm; Tue, 21 Mar 2006 06:03:20 -0800 (PST) Received: by 10.65.135.6 with HTTP; Tue, 21 Mar 2006 06:03:20 -0800 (PST) Message-ID: Date: Tue, 21 Mar 2006 09:03:20 -0500 From: "Merlin Moncure" To: "Amit Soni" Subject: Re: Perfomance test figures Cc: pgsql-performance@postgresql.org In-Reply-To: <20060321055954.85302.qmail@web507.biz.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <20060321055954.85302.qmail@web507.biz.mail.mud.yahoo.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.133 required=5 tests=[AWL=0.133] X-Spam-Score: 0.133 X-Spam-Level: X-Archive-Number: 200603/402 X-Sequence-Number: 17839 On 3/21/06, Amit Soni wrote: > I want to compare performance of postgresql database with some other > database. > > Somebody must have done some performance testing. > > Can you pls. share that data (performance figures) with me? And if possib= leu > pls. share procedure also, that how you have done the same? Unfortunately, most database tests are synthetic and not very helpful. Compounding the problem is that the 'best' way to use the database differs between platforms (case in point: with postgresql you want to use stored procedures for simple qeries, and with mysql you don't want to use them). There are a couple of public benchmarks out there...you could try hitting one of them. But this is no substitute for developing simulations of your workload and doing your own in-house benchmarks. is there a particular reason for wanting to compare various sql databases? merlin