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 3B26F11F66CE for ; Wed, 5 Apr 2006 18:40:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 94839-05 for ; Wed, 5 Apr 2006 18:40:26 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.Mi8.com (d01gw01.mi8.com [63.240.6.47]) by postgresql.org (Postfix) with ESMTP id 61C8911F66EB for ; Wed, 5 Apr 2006 18:40:24 -0300 (ADT) Received: from 172.16.1.110 by mail.Mi8.com with ESMTP (- Welcome to Mi8 Corporation www.Mi8.com (D1)); Wed, 05 Apr 2006 17:40:16 -0400 X-Server-Uuid: 241911D6-425B-44B9-A073-E3FE0F8FC774 Received: from MI8NYCMAIL06.Mi8.com ([172.16.1.160]) by D01SMTP01.Mi8.com with Microsoft SMTPSVC(6.0.3790.1830); Wed, 5 Apr 2006 17:40:16 -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, 5 Apr 2006 21:40:15 +0000 User-Agent: Microsoft-Entourage/11.2.3.060209 Date: Wed, 05 Apr 2006 14:40:14 -0700 Subject: Re: bad performance on Solaris 10 From: "Luke Lonergan" To: "Chris Mair" , pgsql-performance@postgresql.org cc: markir@paradise.net.nz, "Josh Berkus" Message-ID: Thread-Topic: [PERFORM] bad performance on Solaris 10 Thread-Index: AcZY+FrURFljMLR4SNKDeWRcbV2MogAASrjh In-Reply-To: <1144272685.4562.43.camel@dell.home.lan> MIME-Version: 1.0 X-OriginalArrivalTime: 05 Apr 2006 21:40:16.0605 (UTC) FILETIME=[8742F0D0:01C658F9] X-WSS-ID: 682AE6CA0NK2395623-01-01 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.346 required=5 tests=[AWL=0.093, RCVD_NUMERIC_HELO=1.253] X-Spam-Score: 1.346 X-Spam-Level: * X-Archive-Number: 200604/66 X-Sequence-Number: 18150 Chris, On 4/5/06 2:31 PM, "Chris Mair" wrote: > Doing what http://blogs.sun.com/roller/page/jkshah suggests: > wal_sync_method = fsync (unchanged) > wal_buffers = 128 (was 8) > checkpoint_segments = 128 (was 3) > bgwriter_all_percent = 0 (was 0.333) > bgwriter_all_maxpages = 0 (was 5) > and leaving everything else default (solarispackages from pgfoundry) > increased performance ~ 7 times! In the recent past, Jignesh Shaw of Sun MDE discovered that changing the bgwriter_* parameters to zero had a dramatic positive impact on performance. There are also some critical UFS kernel tuning parameters to set, you should find those in his blog. We found and fixed some libpq issues with Solaris that were also critical - they should be in 8.1.3 I think. - Luke