pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bill Moran <wmoran@potentialtech.com>
To: Hannu Krosing <hannu@tm.ee>
Cc: Greg Spiegelberg <gspiegelberg@cranel.com>
Cc: Christopher Browne <cbbrowne@libertyrms.info>
Cc: 'pgsql-performance@postgresql.org ' <pgsql-performance@postgresql.org>
Subject: Re: failures on machines using jfs
Date: Tue, 13 Jan 2004 07:59:08 -0500
Message-ID: <4003EB9C.30406@potentialtech.com> (raw)
In-Reply-To: <1073997967.2528.12.camel@fuji.krosing.net>
References: <387C22290D3FD71195D300508BF7DB5238AE92@colmail01.cranel.com>
	<1073923929.2365.22.camel@fuji.krosing.net>
	<4002D375.8040807@cranel.com>
	<1073997967.2528.12.camel@fuji.krosing.net>

Hannu Krosing wrote:
> Greg Spiegelberg kirjutas E, 12.01.2004 kell 19:03:
> 
>>Hannu Krosing wrote:
>>
>>>Spiegelberg, Greg kirjutas P, 11.01.2004 kell 18:21:
>>>
>>>
>>>>It would seem we're experiencing somthing similiar with our scratch
>>>>volume (JFS mounted with noatime).
>>>
>>>
>>>Which files/directories do you keep on "scratch" volume ?
>>>
>>>All postgres files or just some (WAL, tmp) ?
>>
>>No Postgres files are kept in scratch only the files being loaded
>>into the database via COPY or lo_import.
> 
> 
> then the speedup does not make any sense !
> 
> Is reading from jfs filesystem also 5 times faster than reading from
> ext3 ?
> 
> The only explanation I can give to filling database from jfs volume to
> be so much faster could be some strange filesystem cache interactions.

http://www.potentialtech.com/wmoran/postgresql.php

-- 
Bill Moran
Potential Technologies
http://www.potentialtech.com




view thread (11+ messages)  latest in thread

Message-ID: <4003EB9C.30406@potentialtech.com>
Permalink:  ../4003EB9C.30406@potentialtech.com/
Also on:    postgresql.org/message-id/4003EB9C.30406@potentialtech.com

 · 

reply

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: wmoran@potentialtech.com, hannu@tm.ee, gspiegelberg@cranel.com, cbbrowne@libertyrms.info
  Subject: Re: failures on machines using jfs
  In-Reply-To: <4003EB9C.30406@potentialtech.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