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 !

Is reading from jfs filesystem also 5 times faster than reading from
ext3 ?

The only explanation I can give to filling database from jfs volume to
be so much faster could be some strange filesystem cache interactions.

http://www.potentialtech.com/wmoran/postgresql.php


--
Bill Moran
Potential Technologies
http://www.potentialtech.com


---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to