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 2995ED1D876 for ; Tue, 13 Jan 2004 12:59:38 +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 19445-08 for ; Tue, 13 Jan 2004 08:59:10 -0400 (AST) Received: from mta11.adelphia.net (mta11.adelphia.net [68.168.78.205]) by svr1.postgresql.org (Postfix) with ESMTP id B673AD1B440 for ; Tue, 13 Jan 2004 08:59:06 -0400 (AST) Received: from potentialtech.com ([68.68.113.33]) by mta11.adelphia.net (InterMail vM.5.01.06.05 201-253-122-130-105-20030824) with ESMTP id <20040113125909.CXQJ21134.mta11.adelphia.net@potentialtech.com>; Tue, 13 Jan 2004 07:59:09 -0500 Message-ID: <4003EB9C.30406@potentialtech.com> Date: Tue, 13 Jan 2004 07:59:08 -0500 From: Bill Moran User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.4) Gecko/20031005 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Hannu Krosing Cc: Greg Spiegelberg , 'Christopher Browne ' , "'pgsql-performance@postgresql.org '" Subject: Re: failures on machines using jfs References: <387C22290D3FD71195D300508BF7DB5238AE92@colmail01.cranel.com> <1073923929.2365.22.camel@fuji.krosing.net> <4002D375.8040807@cranel.com> <1073997967.2528.12.camel@fuji.krosing.net> In-Reply-To: <1073997967.2528.12.camel@fuji.krosing.net> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/130 X-Sequence-Number: 5305 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