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
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