pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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





view thread (11+ messages)  latest in thread

Message-ID: <1073997967.2528.12.camel@fuji.krosing.net>
Permalink:  ../1073997967.2528.12.camel@fuji.krosing.net/
Also on:    postgresql.org/message-id/1073997967.2528.12.camel@fuji.krosing.net

 · 

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