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 ACEA8565AA for ; Tue, 22 Mar 2005 21:26:27 +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 87090-01 for ; Tue, 22 Mar 2005 21:26:18 +0000 (GMT) Received: from linda-1.paradise.net.nz (bm-1a.paradise.net.nz [202.0.58.20]) by svr1.postgresql.org (Postfix) with ESMTP id D8F365653D for ; Tue, 22 Mar 2005 21:26:16 +0000 (GMT) Received: from smtp-1.paradise.net.nz (smtp-1a.paradise.net.nz [202.0.32.194]) by linda-1.paradise.net.nz (Paradise.net.nz) with ESMTP id <0IDR00KDBVJT6W@linda-1.paradise.net.nz> for pgsql-performance@postgresql.org; Wed, 23 Mar 2005 09:26:18 +1200 (NZST) Received: from [192.168.1.11] (218-101-14-86.paradise.net.nz [218.101.14.86]) by smtp-1.paradise.net.nz (Postfix) with ESMTP id 2421E82798; Wed, 23 Mar 2005 09:26:17 +1200 (NZST) Date: Wed, 23 Mar 2005 09:26:16 +1200 From: Mark Kirkwood Subject: Re: PostgreSQL on Solaris 8 and ufs In-reply-to: To: Brandon Metcalf Cc: pgsql-performance@postgresql.org Message-id: <42408D78.1020100@paradise.net.nz> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7bit User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.8b) Gecko/20050301 References: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.053 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/472 X-Sequence-Number: 11177 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? > > Thanks. > I found that mounting the filesystem that contains the PGDATA directory (probably only the pg_xlog directory in fact) without logging improved things a great deal (assuming you are using logging that is...). In addition changing the postgresql.conf parameter wal_sync_method from the default of open_datasync to fdatasync improved things a bit more. However I seem to recall a posting suggesting the opposite! ...so feel free to experiment and let us know! Mark P.s : original tests on Solaris 8, http://archives.postgresql.org/pgsql-performance/2003-12/msg00165.php