Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id C294D2E2DDF for ; Tue, 11 Dec 2007 07:36:30 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 63246-02-5 for ; Tue, 11 Dec 2007 07:36:24 -0400 (AST) Received: from bay0-omc2-s27.bay0.hotmail.com (bay0-omc2-s27.bay0.hotmail.com [65.54.246.163]) by postgresql.org (Postfix) with ESMTP id A65F72E2F9E for ; Tue, 11 Dec 2007 07:36:20 -0400 (AST) Received: from BAY112-W37 ([64.4.26.137]) by bay0-omc2-s27.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.3959); Tue, 11 Dec 2007 03:36:19 -0800 Message-ID: X-Originating-IP: [82.57.73.221] From: Manolo _ To: Subject: Re: Benchmarking PG Date: Tue, 11 Dec 2007 11:36:19 +0000 Importance: Normal In-Reply-To: References: Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-OriginalArrivalTime: 11 Dec 2007 11:36:19.0567 (UTC) FILETIME=[0C59FFF0:01C83BEA] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/126 X-Sequence-Number: 27942 Hi Josh! Thanks for your reply. Actually I forgot to mention PGBench, sorry. But I also forgot to mention I= 'm looking for an "impartial"... I mean "outer" tool to test PG. Any suggestion, please? Regards. ---------------------------------------- > Date: Tue, 11 Dec 2007 04:16:02 -0700 > From: eggyknap@gmail.com > To: mac_man2005@hotmail.it > Subject: Re: [PERFORM] Benchmarking PG > CC: pgsql-performance@postgresql.org >=20 > 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 Replacemen= t Selection (external sorting) algorithm and of a refinement I'm going to i= mplement. >> >> I'm new on PG, I just had the idea of how to possibly get better that al= gorithm 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 Wiscons= in 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 >> >=20 > Well, there's pgbench. http://www.postgresql.org/docs/8.3/static/pgbench.= html >=20 > - Josh / eggyknap _________________________________________________________________ Express yourself instantly with MSN Messenger! Download today it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/=