Date: Tue, 29 Aug 2006 16:03:38 +0100
From: "Jignesh K. Shah" <J.K.Shah@Sun.COM>
Subject: Re: slow i/o
In-reply-to: <8d04ce990608281606r153ed796xcf5d9d3a44d8e632@mail.gmail.com>
To: Junaili Lie <junaili@gmail.com>
Cc: pgsql-performance@postgresql.org
Message-id: <44F4574A.3040705@sun.com>
MIME-version: 1.0
Content-type: text/plain; format=flowed; charset=ISO-8859-1
Content-transfer-encoding: 7BIT
References: <8d04ce990608281606r153ed796xcf5d9d3a44d8e632@mail.gmail.com>
User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050322)

Did you increase the checkpoint segments and changed the default WAL lock method to fdsync?

http://blogs.sun.com/jkshah/entry/postgresql_on_solaris_better_use

Try fdsync instead of fysnc as mentioned in the entry.

Regards,
Jignesh


Junaili Lie wrote:
> Hi everyone,
> We have a postgresql 8.1 installed on Solaris 10. It is running fine. 
> However, for the past couple days, we have seen the i/o reports 
> indicating that the i/o is busy most of the time. Before this, we only 
> saw i/o being busy occasionally (very rare). So far, there has been no 
> performance complaints by customers, and the slow query reports doesn't 
> indicate anything out of the ordinary.
> There's no code changes on the applications layer and no database 
> configuration changes.
> I am wondering if there's a tool out there on Solaris to tell which 
> process is doing most of the i/o activity?
> Thank you in advance.
> 
> J
>