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])