X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 50B459FA43B for ; Thu, 14 Sep 2006 04:05:51 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 75820-05 for ; Thu, 14 Sep 2006 07:05:42 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.logix-tt.com (mail.logix-tt.com [212.211.145.186]) by postgresql.org (Postfix) with ESMTP id 39C6A9FA36A for ; Thu, 14 Sep 2006 04:05:41 -0300 (ADT) Received: from kingfisher.intern.logix-tt.com (p549D223A.dip0.t-ipconnect.de [84.157.34.58]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.logix-tt.com (Postfix) with ESMTP id E442865977; Thu, 14 Sep 2006 09:07:51 +0200 (CEST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by kingfisher.intern.logix-tt.com (Postfix) with ESMTP id 4E58C18587DAB; Thu, 14 Sep 2006 09:05:35 +0200 (CEST) Message-ID: <4508FF3E.6030202@logix-tt.com> Date: Thu, 14 Sep 2006 09:05:34 +0200 From: Markus Schaber Organization: Logical Tracking and Tracing International AG, Switzerland User-Agent: Thunderbird 1.5.0.5 (X11/20060812) MIME-Version: 1.0 To: yoav x Cc: pgsql-performance@postgresql.org Subject: Re: sql-bench References: <20060914065522.23041.qmail@web35806.mail.mud.yahoo.com> In-Reply-To: <20060914065522.23041.qmail@web35806.mail.mud.yahoo.com> X-Enigmail-Version: 0.94.0.0 Content-Type: text/plain; charset=ISO-8859-15 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.135 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200609/146 X-Sequence-Number: 20832 Hi, Yoav X, yoav x wrote: > You can use the test with InnoDB by giving the --create-options=engine=innodb option in the > command line. Even with InnoDB, in some specific tests PG looks very bad compared to InnoDB. As far as I've seen, they include the CREATE TABLE command in their benchmarks. Realistic in-production workloads don't have so much create table commands, I think. Wondering, Markus -- Markus Schaber | Logical Tracking&Tracing International AG Dipl. Inf. | Software Development GIS Fight against software patents in Europe! www.ffii.org www.nosoftwarepatents.org