X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 0E6119FB3AE for ; Thu, 21 Sep 2006 12:03:28 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 09703-06 for ; Thu, 21 Sep 2006 12:03:14 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.libertyrms.com (vgateway.libertyrms.info [207.219.45.62]) by postgresql.org (Postfix) with ESMTP id 851A99FB38D for ; Thu, 21 Sep 2006 12:03:14 -0300 (ADT) Received: from dba5.int.libertyrms.com ([10.1.3.44]) by mail.libertyrms.com with esmtp (Exim 4.22) id 1GQQ53-0000BC-Bj; Thu, 21 Sep 2006 11:03:13 -0400 Subject: Re: PostgreSQL and sql-bench From: Brad Nicholson To: yoav x Cc: pgsql-performance@postgresql.org In-Reply-To: <20060921145244.13005.qmail@web35813.mail.mud.yahoo.com> References: <20060921145244.13005.qmail@web35813.mail.mud.yahoo.com> Content-Type: text/plain Date: Thu, 21 Sep 2006 11:03:12 -0400 Message-Id: <1158850992.30235.10.camel@dba5.int.libertyrms.com> Mime-Version: 1.0 X-Mailer: Evolution 2.6.2 (2.6.2-1.fc5.5) Content-Transfer-Encoding: 7bit X-SA-Exim-Mail-From: bnichols@ca.afilias.info X-SA-Exim-Scanned: No; SAEximRunCond expanded to false X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.273 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200609/278 X-Sequence-Number: 20964 On Thu, 2006-09-21 at 07:52 -0700, yoav x wrote: > Hi > > After upgrading DBI and DBD::Pg, this benchmark still picks MySQL as the winner (at least on Linux > RH3 on a Dell 1875 server with 2 hyperthreaded 3.6GHz CPUs and 4GB RAM). > I've applied the following parameters to postgres.conf: > > max_connections = 500 > shared_buffers = 3000 > work_mem = 100000 > effective_cache_size = 3000000000 > > Most queries still perform slower than with MySQL. > Is there anything else that can be tweaked or is this a limitation of PG or the benchmark? As mentioned by others, you are using a benchmark that is slanted towards MySQL.