From: Hannu Krosing <hannu@tm.ee>
To: 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 14:46:08 +0200
Message-ID: <1073997967.2528.12.camel@fuji.krosing.net> (raw)
In-Reply-To: <4002D375.8040807@cranel.com>
References: <387C22290D3FD71195D300508BF7DB5238AE92@colmail01.cranel.com>
<1073923929.2365.22.camel@fuji.krosing.net>
<4002D375.8040807@cranel.com>
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.
----------------
Hannu
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: hannu@tm.ee, gspiegelberg@cranel.com, cbbrowne@libertyrms.info
Subject: Re: failures on machines using jfs
In-Reply-To: <1073997967.2528.12.camel@fuji.krosing.net>
* 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