X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 510AC11F66DC for ; Wed, 12 Apr 2006 22:53:02 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0.001 X-Spam-Level: X-Spam-Status: No, score=0.001 required=5 tests=[UNPARSEABLE_RELAY=0.001] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id jvAv4DEqgQie for ; Wed, 12 Apr 2006 22:52:56 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from brmea-mail-2.sun.com (brmea-mail-2.Sun.COM [192.18.98.43]) by postgresql.org (Postfix) with ESMTP id E286011F66C4 for ; Wed, 12 Apr 2006 22:52:53 -0300 (ADT) Received: from fe-amer-05.sun.com ([192.18.108.179]) by brmea-mail-2.sun.com (8.12.10/8.12.9) with ESMTP id k3D1qtmU017509 for ; Wed, 12 Apr 2006 19:52:55 -0600 (MDT) Received: from conversion-daemon.mail-amer.sun.com by mail-amer.sun.com (Sun Java System Messaging Server 6.2-4.02 (built Sep 9 2005)) id <0IXN00L01079S400@mail-amer.sun.com> (original mail from J.K.Shah@Sun.COM) for pgsql-performance@postgresql.org; Wed, 12 Apr 2006 19:52:55 -0600 (MDT) Received: from [129.150.33.52] by mail-amer.sun.com (Sun Java System Messaging Server 6.2-4.02 (built Sep 9 2005)) with ESMTPSA id <0IXN00DGW186OZR4@mail-amer.sun.com>; Wed, 12 Apr 2006 19:52:55 -0600 (MDT) Date: Wed, 12 Apr 2006 21:53:33 -0400 From: "Jignesh K. Shah" Subject: Re: bad performance on Solaris 10 In-reply-to: <200604121956.k3CJuH717290@candle.pha.pa.us> To: Bruce Momjian Cc: Luke Lonergan , Alvaro Herrera , Chris Mair , pgsql-performance@postgresql.org, markir@paradise.net.nz, Josh Berkus Message-id: <443DAF1D.6090007@sun.com> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7BIT X-Accept-Language: en-us, en References: <200604121956.k3CJuH717290@candle.pha.pa.us> User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Archive-Number: 200604/287 X-Sequence-Number: 18371 Bruce, Hard to answer that... People like me who know and love PostgreSQL and Solaris finds this as an opportunity to make their favorite database work best on their favorite operating system. Many times PostgreSQL has many things based on assumption that it will run on Linux and it is left to Solaris to emulate that behavior.That said there are ways to improve performance even on UFS on Solaris, it just requires more tweaks. Hopefully this will lead to few Solaris friendly default values like fsync/odatasync :-) Regards, Jignesh 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. > >