Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 0840B9FB362 for ; Fri, 19 Jan 2007 09:46:00 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 49857-06 for ; Fri, 19 Jan 2007 09:45:35 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.245]) by postgresql.org (Postfix) with ESMTP id CB1D29FB2F9 for ; Fri, 19 Jan 2007 09:45:45 -0400 (AST) Received: by an-out-0708.google.com with SMTP id c3so217746ana for ; Fri, 19 Jan 2007 05:45:44 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=lpQ3awb8io/uk1Ub2ISJtds+VYO5BevDimPGo0cM502QHyol9WDeullOO1dxMUQdeAPEVFX0lLwx0N7pAC7PslFosZTqwPdC9jq/xjxmMa4vDR2WDiChdfnGyPmSU66EWlYM1lE5P1ybng6CRzMT0f2OHfW0L+BdMdsFwie2pO0= Received: by 10.78.164.13 with SMTP id m13mr198733hue.1169214313865; Fri, 19 Jan 2007 05:45:13 -0800 (PST) Received: by 10.78.45.3 with HTTP; Fri, 19 Jan 2007 05:45:13 -0800 (PST) Message-ID: Date: Fri, 19 Jan 2007 08:45:13 -0500 From: "Merlin Moncure" To: "Kevin Hunter" Subject: Re: DB benchmark and pg config file help Cc: "PostgreSQL Performance List" In-Reply-To: <45AE9FFC.20709@earlham.edu> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <45AE9FFC.20709@earlham.edu> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/331 X-Sequence-Number: 22932 On 1/17/07, Kevin Hunter wrote: > Hello List, > > Not sure to which list I should post (gray lines, and all that), so > point me in the right direction if'n it's a problem. > > I am in the process of learning some of the art/science of benchmarking. > Given novnov's recent post about the comparison of MS SQL vs > PostgresQL, I felt it time to do a benchmark comparison of sorts for > myself . . . more for me and the benchmark learning process than the > DB's, but I'm interested in DB's in general, so it's a good fit. (If I > find anything interesting/new, I will of course share the results.) Just remember that all the major commercial databases have anti-benchmark clauses in their license agreements. So, if you decide to publish your results (especially in a formal benchmark), you can't mention the big boys by name. [yes this is cowardice] merlin