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

Re: failures on machines using jfs

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Andrew Sullivan <andrew(at)libertyrms(dot)info>,pgsql-performance(at)postgresql(dot)org
Subject: Re: failures on machines using jfs
Date: 2004-01-08 18:52:40
Message-ID: 200401081052.40807.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-performance
Andrew,

> None of this is to say that jfs is in fact to blame, nor even that,
> if it is, it does not have something to do with the age of our
> installations, &c. (these are all RH 8).  In fact, I suspect hardware
> in both cases.  But I thought I'd mention it just in case other
> people are seeing strange behaviour, on the principle of "better
> safe than sorry."

Always useful.    Actually, I just fielded on IRC a report of poor I/O 
utilization with XFS during checkpointing.    Not sure if the problem is XFS 
or PostgreSQL, but the fact that XFS (alone among filesystems) does its own 
cache management instead of using the kernel cache makes me suspicious.

-- 
-Josh Berkus
 Aglio Database Solutions
 San Francisco


In response to

pgsql-performance by date

Next:From: Rod TaylorDate: 2004-01-09 03:16:49
Subject: Re: optimizing Postgres queries
Previous:From: Bradley TateDate: 2004-01-08 05:52:05
Subject: Slow query problem

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