X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8B369329D9F for ; Sun, 19 Sep 2004 11:04:50 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 76496-02 for ; Sun, 19 Sep 2004 10:04:45 +0000 (GMT) Received: from mail.coretech.co.nz (coretech.co.nz [202.36.204.41]) by svr1.postgresql.org (Postfix) with ESMTP id EF153329D83 for ; Sun, 19 Sep 2004 11:04:45 +0100 (BST) Received: (qmail 14187 invoked from network); 19 Sep 2004 10:04:42 -0000 Received: from localhost (127.0.0.1) by 0 with SMTP; 19 Sep 2004 10:04:42 -0000 Received: from 82.133.100.70 ([82.133.100.70]) by mail.coretech.co.nz (Horde) with HTTP for ; Sun, 19 Sep 2004 22:04:41 +1200 Message-ID: <1095588281.29ef3c9d222ad@mail.coretech.co.nz> Date: Sun, 19 Sep 2004 22:04:41 +1200 From: markir@coretech.co.nz To: ischamay.andbergsay@activestateway.com Cc: pgsql-performance@postgresql.org Subject: Re: Tryint to match Solaris-Oracle performance with References: In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Disposition: inline Content-Transfer-Encoding: 7bit User-Agent: Internet Messaging Program (IMP) 4.0-cvs X-Originating-IP: Withheld X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200409/200 X-Sequence-Number: 8328 Hi Mischa, You probably need to determine whether the bottleneck is cpu or disk (should be easy enough!) Having said that, assuming your application is insert/update intensive I would recommend: - mount the ufs filesystems Pg uses *without* logging - use postgresql.conf setting fsync_method=fdatasync These changes made my Pgbench results improve by a factor or 4 (enough to catch the big O maybe...) Then you will need to have a look at your other postgresql.conf parameters! (posting this file to the list might be a plan) Cheers Mark Quoting Mischa Sandberg : > Our product (Sophos PureMessage) runs on a Postgres database. > > Some of our Solaris customers have Oracle licenses, and they've > commented on the performance difference between Oracle and Postgresql > on such boxes. In-house, we've noticed the 2:1 (sometimes 5:1) > performance difference in inserting rows (mostly 2-4K), between > Postgresql on Solaris 8 and on Linux, for machines with comparable > CPU's and RAM. > >