Re: failures on machines using jfs

From: Greg Spiegelberg <gspiegelberg(at)cranel(dot)com>
To: Hannu Krosing <hannu(at)tm(dot)ee>
Cc: 'Christopher Browne ' <cbbrowne(at)libertyrms(dot)info>, "'pgsql-performance(at)postgresql(dot)org '" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: failures on machines using jfs
Date: 2004-01-13 15:04:20
Message-ID: 400408F4.5030504@cranel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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(at)Cranel(dot)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
**********************************************************************

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message David Hill 2004-01-13 16:04:13 freebsd 5.2 and max_connections
Previous Message Bill Moran 2004-01-13 12:59:08 Re: failures on machines using jfs