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 8BA21D1B43F for ; Tue, 13 Jan 2004 15:04:53 +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 54046-04 for ; Tue, 13 Jan 2004 11:04:26 -0400 (AST) Received: from COLSWEEPER.cranel.com (newmail.cranel.com [12.32.71.147]) by svr1.postgresql.org (Postfix) with ESMTP id 21EB4D1B519 for ; Tue, 13 Jan 2004 11:04:22 -0400 (AST) Received: from colmail01.cranel.com (colmail01.cranel.com) by COLSWEEPER.cranel.com (Content Technologies SMTPRS 4.3.12) with ESMTP id ; Tue, 13 Jan 2004 10:03:14 -0500 Received: from cranel.com (gspiegelberg.cranel.com [192.168.11.134]) by colmail01.cranel.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id CZTCJ5KW; Tue, 13 Jan 2004 10:08:01 -0500 Message-ID: <400408F4.5030504@cranel.com> Date: Tue, 13 Jan 2004 10:04:20 -0500 From: Greg Spiegelberg Organization: Cranel, Inc. User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4) Gecko/20030624 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Hannu Krosing Cc: '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/131 X-Sequence-Number: 5306 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 ! We do a lot of preprocessing before the data gets loaded. It's that process that experiences the hiccups I mentioned. -- Greg Spiegelberg Sr. Product Development Engineer Cranel, Incorporated. Phone: 614.318.4314 Fax: 614.431.8388 Email: gspiegelberg@Cranel.com Cranel. Technology. Integrity. Focus. ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com **********************************************************************