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 B0594568E3 for ; Tue, 22 Mar 2005 21:02:52 +0000 (GMT) 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 79319-03 for ; Tue, 22 Mar 2005 21:02:51 +0000 (GMT) Received: from unicorn.rentec.com (unicorn.rentec.com [216.223.240.9]) by svr1.postgresql.org (Postfix) with ESMTP id 9566D56899 for ; Tue, 22 Mar 2005 21:02:48 +0000 (GMT) Received: from ram.rentec.com (mailhost [192.5.35.66]) by unicorn.rentec.com (8.13.1/8.12.1) with ESMTP id j2ML2ddx029313 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=FAIL); Tue, 22 Mar 2005 16:02:40 -0500 (EST) X-Rentec: external Received: from [172.26.132.145] (hoopoe.rentec.com [172.26.132.145]) by ram.rentec.com (8.13.1/8.12.1) with ESMTP id j2ML2dpE022680; Tue, 22 Mar 2005 16:02:39 -0500 (EST) Message-ID: <424087EF.2070802@rentec.com> Date: Tue, 22 Mar 2005 16:02:39 -0500 From: Alan Stange Reply-To: stange@rentec.com Organization: Renaissance Technologies Corp. User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Brandon Metcalf Cc: pgsql-performance@postgresql.org Subject: Re: PostgreSQL on Solaris 8 and ufs References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Logged: Logged by unicorn.rentec.com as j2ML2ddx029313 at Tue Mar 22 16:02:40 2005 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200503/468 X-Sequence-Number: 11173 Brandon Metcalf wrote: >We've recently moved our pgsql installation and DBs to a Solaris 8 >machine with striped and mirrored ufs filesystem that houses the DB >data. We are now seeing terrible performance and the bottleneck is no >doubt disk I/O. > >We've tried modifying a tunables related to ufs, but it doesn't seem >to be helping. > >Is there anything we should be looking at that is specifically related >to ufs filesystems on Solaris 8 or possibly something in general that >would improve performance? > > Well, Solaris 8 is a bit old now, so I don't remember all the details. But, if memory servers, Solaris 8 still has some "high water" and "lo water" tunables related to the amount of IO can be outstanding to a single file. Try setting set ufs:ufs_WRITES=0 in /etc/system and rebooting, which basically says "any amount of disk IO can be outstanding". There's a tunables doc on docs.sun.com that explains this option. Also, logging UFS might help with some of the metadata requirements of UFS as well. So, use "mount -o logging" or add the relevant entry in /etc/vfstab. Of course, the best thing is Solaris 9 or 10, which would be much better for this sort of thing. Hope this helps. -- Alan