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: [EMAIL PROTECTED]
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
**********************************************************************


---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to