X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 1FED9D1D8A0 for ; Tue, 13 Jan 2004 12:46:39 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 19360-08 for ; Tue, 13 Jan 2004 08:46:11 -0400 (AST) Received: from fuji.krosing.net (silmet.estpak.ee [194.126.97.78]) by svr1.postgresql.org (Postfix) with ESMTP id 71C1DD1D889 for ; Tue, 13 Jan 2004 08:46:07 -0400 (AST) Received: from fuji.krosing.net (localhost.localdomain [127.0.0.1]) by fuji.krosing.net (8.12.8/8.12.8) with ESMTP id i0DCk8nj002638; Tue, 13 Jan 2004 14:46:08 +0200 Received: (from hannu@localhost) by fuji.krosing.net (8.12.8/8.12.8/Submit) id i0DCk8XV002636; Tue, 13 Jan 2004 14:46:08 +0200 X-Authentication-Warning: fuji.krosing.net: hannu set sender to hannu@tm.ee using -f Subject: Re: failures on machines using jfs From: Hannu Krosing To: Greg Spiegelberg Cc: "'Christopher Browne '" , "'pgsql-performance@postgresql.org '" In-Reply-To: <4002D375.8040807@cranel.com> References: <387C22290D3FD71195D300508BF7DB5238AE92@colmail01.cranel.com> <1073923929.2365.22.camel@fuji.krosing.net> <4002D375.8040807@cranel.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1073997967.2528.12.camel@fuji.krosing.net> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Tue, 13 Jan 2004 14:46:08 +0200 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/129 X-Sequence-Number: 5304 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