From: Jignesh K. Shah <J.K.Shah@Sun.COM>
To: Junaili Lie <junaili@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: slow i/o
Date: Tue, 29 Aug 2006 16:03:38 +0100
Message-ID: <44F4574A.3040705@sun.com> (raw)
In-Reply-To: <8d04ce990608281606r153ed796xcf5d9d3a44d8e632@mail.gmail.com>
References: <8d04ce990608281606r153ed796xcf5d9d3a44d8e632@mail.gmail.com>
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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: J.K.Shah@Sun.COM, junaili@gmail.com
Subject: Re: slow i/o
In-Reply-To: <44F4574A.3040705@sun.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox