Skip site navigation (1) Skip section navigation (2)

Re: slow i/o

From: "Jignesh K(dot) Shah" <J(dot)K(dot)Shah(at)Sun(dot)COM>
To: Junaili Lie <junaili(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: slow i/o
Date: 2006-08-29 15:03:38
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
Did you increase the checkpoint segments and changed the default WAL lock method to fdsync?

Try fdsync instead of fysnc as mentioned in the entry.


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

In response to

  • slow i/o at 2006-08-28 23:06:50 from Junaili Lie

pgsql-performance by date

Next:From: Willo van der MerweDate: 2006-08-29 15:06:02
Subject: Re: PostgreSQL performance issues
Previous:From: Joshua D. DrakeDate: 2006-08-29 14:51:50
Subject: Re: PostgreSQL performance issues

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group