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 0DBA99FB38D for ; Thu, 21 Sep 2006 11:52:54 -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 08813-04 for ; Thu, 21 Sep 2006 11:52:46 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web35813.mail.mud.yahoo.com (web35813.mail.mud.yahoo.com [66.163.179.182]) by postgresql.org (Postfix) with SMTP id E2C119FB376 for ; Thu, 21 Sep 2006 11:52:45 -0300 (ADT) Received: (qmail 13007 invoked by uid 60001); 21 Sep 2006 14:52:44 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=3gwhKkQyIC1nziPbbYEwOKNWlm8UTohhJaZ+9B4fLNq6UDw6bmjvisfmgoFuiJZdnLcXBkl8c/pMDr6S5CFbTaFiG+XTk3Kb2SuehEAVJtiA9a3OfTsKZ8iQGv+4mOzF8Rhlqh164BjdfnPx2oub34dl13JMlD3fMK6UNHx/b/Y= ; Message-ID: <20060921145244.13005.qmail@web35813.mail.mud.yahoo.com> Received: from [194.29.36.33] by web35813.mail.mud.yahoo.com via HTTP; Thu, 21 Sep 2006 07:52:44 PDT Date: Thu, 21 Sep 2006 07:52:44 -0700 (PDT) From: yoav x Subject: PostgreSQL and sql-bench To: pgsql-performance@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.566 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS X-Spam-Level: ** X-Archive-Number: 200609/277 X-Sequence-Number: 20963 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? Thanks. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com