Re: failures on machines using jfs - Mailing list pgsql-performance

From Greg Spiegelberg
Subject Re: failures on machines using jfs
Date
Msg-id 400408F4.5030504@cranel.com
Whole thread Raw
In response to Re: failures on machines using jfs  (Hannu Krosing <hannu@tm.ee>)
List 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@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
**********************************************************************


pgsql-performance by date:

Previous
From: Bill Moran
Date:
Subject: Re: failures on machines using jfs
Next
From: David Hill
Date:
Subject: freebsd 5.2 and max_connections