X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx2.hub.org [200.46.204.254]) by postgresql.org (Postfix) with ESMTP id 814EA11F6009 for ; Wed, 12 Apr 2006 19:35:53 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: -0.964 X-Spam-Level: X-Spam-Status: No, score=-0.964 required=5 tests=[BAYES_00=-2.599, FORGED_RCVD_HELO=0.135, RCVD_NUMERIC_HELO=1.5] Received: from postgresql.org ([200.46.204.71]) by localhost (mx2.hub.org [200.46.204.254]) (amavisd-new, port 10024) with ESMTP id AkF+uCsHa8Kd for ; Wed, 12 Apr 2006 19:35:48 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.mi8.com (d01gw02.mi8.com [63.240.6.46]) by postgresql.org (Postfix) with ESMTP id 9B3A811F610C for ; Wed, 12 Apr 2006 19:35:45 -0300 (ADT) Received: from 172.16.1.25 by mail.mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D2)); Wed, 12 Apr 2006 18:35:36 -0400 X-Server-Uuid: 7829E76E-BB9E-4995-8473-3C0929DF7DD1 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.175]) by D01HOST03.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Wed, 12 Apr 2006 18:35:36 -0400 Received: from 67.103.45.218 ([67.103.45.218]) by MI8NYCMAIL06.Mi8.com ( [172.16.1.219]) via Exchange Front-End Server mi8owa.mi8.com ( [172.16.1.106]) with Microsoft Exchange Server HTTP-DAV ; Wed, 12 Apr 2006 22:35:35 +0000 User-Agent: Microsoft-Entourage/11.2.3.060209 Date: Wed, 12 Apr 2006 15:35:33 -0700 Subject: Re: bad performance on Solaris 10 From: "Luke Lonergan" To: "Bruce Momjian" cc: "Alvaro Herrera" , "Chris Mair" , pgsql-performance@postgresql.org, markir@paradise.net.nz, "Josh Berkus" Message-ID: Thread-Topic: [PERFORM] bad performance on Solaris 10 Thread-Index: AcZeazgLm1+9NlluTleUAj9c7eo9ogAFjDXb In-Reply-To: <200604121956.k3CJuH717290@candle.pha.pa.us> MIME-Version: 1.0 X-OriginalArrivalTime: 12 Apr 2006 22:35:36.0175 (UTC) FILETIME=[6AC55FF0:01C65E81] X-WSS-ID: 68235F322XS44564762-01-01 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200604/274 X-Sequence-Number: 18358 Bruce, On 4/12/06 12:56 PM, "Bruce Momjian" wrote: > It is hard to imagine why people spend so much time modifying Sun > machines run with acceptable performance when non-Sun operating systems > work fine without such hurtles. There are a lot of Solaris customers that we support and that we'd like to support. To many of them, Solaris has many advantages other than speed, though they expect a reasonably comparable performance, perhaps within a factor of 2 of other options. Oracle has spent a great deal of time (a decade!) optimizing their software for Solaris, and it shows. There are also some typical strategies that Solaris people used to use to make Solaris perform better, like using VxFS (Veritas Filesystem), or Oracle Raw IO to make their systems perform better. Lately I find people are not so receptive to VxFS, and Sun is promoting ZFS, and we don't have a reasonable near term option for Raw IO in Postgres, so we need to work to find a reasonable path for Solaris users IMO. The long delays in ZFS production haven't helped us there, as the problems with UFS are severe. We at Greenplum have worked hard over the last year to find options for Postgres on Solaris and have the best configuration setup that we think is possible now on UFS, and our customers benefit from that. However, Linux on XFS or even ext3 is definitely the performance leader. - Luke