X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 17654D1B4C4 for ; Wed, 10 Dec 2003 13:54:22 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 50470-02 for ; Wed, 10 Dec 2003 09:53:53 -0400 (AST) Received: from jefftrout.com (h00a0cc4084e5.ne.client2.attbi.com [24.128.241.68]) by svr1.postgresql.org (Postfix) with SMTP id 73D61D1B4CC for ; Wed, 10 Dec 2003 09:53:49 -0400 (AST) Received: (qmail 42480 invoked from network); 10 Dec 2003 13:53:47 -0000 Received: from localhost (HELO squeegit) (threshar@127.0.0.1) by localhost with SMTP; 10 Dec 2003 13:53:47 -0000 Date: Wed, 10 Dec 2003 08:53:23 -0500 From: Jeff To: Mark Kirkwood Cc: pgsql-performance@postgresql.org Subject: Re: Solaris Performance (Again) Message-Id: <20031210085323.749a549f.threshar@torgo.978.org> In-Reply-To: <3FD6B596.8090803@paradise.net.nz> References: <3FD6B596.8090803@paradise.net.nz> X-Mailer: Sylpheed version 0.9.7 (GTK+ 1.2.10; i686-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/167 X-Sequence-Number: 5027 On Wed, 10 Dec 2003 18:56:38 +1300 Mark Kirkwood wrote: > The major performance killer appeared to be mounting the filesystem > with the logging option. The next most significant seemed to be the > choice of sync_method for Pg - the default (open_datasync), which we > initially thought should be the best - appears noticeably slower than > fdatasync. > Some interesting stuff, I'll have to play with it. Currently I'm pleased with my solaris performance. What version of PG? If it is before 7.4 PG compiles with _NO_ optimization by default and was a huge part of the slowness of PG on solaris. -- Jeff Trout http://www.jefftrout.com/ http://www.stuarthamm.net/