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: 44F4574A.3040705@sun.com (view raw or flat)
Thread:
Lists: pgsql-performance
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
> 

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-2014 The PostgreSQL Global Development Group