Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id D0B482E156A for ; Tue, 11 Dec 2007 07:16:19 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 81640-03 for ; Tue, 11 Dec 2007 07:16:03 -0400 (AST) Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.169]) by postgresql.org (Postfix) with ESMTP id 710652E2DD2 for ; Tue, 11 Dec 2007 07:16:07 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id j3so224769ugf.49 for ; Tue, 11 Dec 2007 03:16:05 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=ckuEBHisjNHUl8FbzmAWWYKWK3++/rIL42czenpaXSA=; b=hrz3JBVAi2eMVpbsOih/BHzvMiA7Ut15rfsydc8Ddc5uSxjyLqtiLntMAxMnUomCh6RePfQYIHM69fKFZdcFEOpx4eKPhcNbKkJI0Dmnj7jOKa9RARARzRtv8j+oAWgKTUJfdTEjJGnRC0ljHJLoBXWTRCbVJZ8Ag6fhsKBMRQ4= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=mPKgvhfYfdxTql0BgiAFevEDsJJYTkvp6EUcSf11ewBlbK6RefHC2owXIh+NteFvz8SrCbz5z28r3L8a3BrkSD1nsjhBsEFfCwoPWh8+M7qDI5OQZSbBKuCdqK29bf3tj1guzciCd8HFdtKAmq8bGd0wtOp8a2VpovLZ2s9igLM= Received: by 10.78.159.7 with SMTP id h7mr8344630hue.1197371762613; Tue, 11 Dec 2007 03:16:02 -0800 (PST) Received: by 10.78.162.8 with HTTP; Tue, 11 Dec 2007 03:16:02 -0800 (PST) Message-ID: Date: Tue, 11 Dec 2007 04:16:02 -0700 From: "Josh Tolley" To: "Manolo _" Subject: Re: Benchmarking PG Cc: pgsql-performance@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/124 X-Sequence-Number: 27940 On Dec 11, 2007 4:06 AM, Manolo _ wrote: > > Hi to all. > > I'd like to benchmark PG. I'd like to compare sorting performances (time spent, #of disk accesses, # of run produced etc) of the present Replacement Selection (external sorting) algorithm and of a refinement I'm going to implement. > > I'm new on PG, I just had the idea of how to possibly get better that algorithm and choosed to test it on PG since it's an open-source DBMS. > > I've been searching the web for a benchmark. I suppose TPC-H and Wisconsin could fit, but had problems when trying to use them. > Any suggestion on a "good benchmark"? > Any tutorial on how to use them? > > Thanks for your time. > > Regards. > Manolo. > _________________________________________________________________ > Express yourself instantly with MSN Messenger! Download today it's FREE! > http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > Well, there's pgbench. http://www.postgresql.org/docs/8.3/static/pgbench.html - Josh / eggyknap