From: Greg Spiegelberg <gspiegelberg@cranel.com>
To: Hannu Krosing <hannu@tm.ee>
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 10:04:20 -0500
Message-ID: <400408F4.5030504@cranel.com> (raw)
In-Reply-To: <1073997967.2528.12.camel@fuji.krosing.net>
References: <387C22290D3FD71195D300508BF7DB5238AE92@colmail01.cranel.com>
<1073923929.2365.22.camel@fuji.krosing.net>
<4002D375.8040807@cranel.com>
<1073997967.2528.12.camel@fuji.krosing.net>
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
**********************************************************************
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: gspiegelberg@cranel.com, hannu@tm.ee, cbbrowne@libertyrms.info
Subject: Re: failures on machines using jfs
In-Reply-To: <400408F4.5030504@cranel.com>
* 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