If your system will run a significant number of queries involving large amounts of data, then you will need a lot of reading and writing bandwidth in the work location.

If you lose this location, replace the failed component, rebuild the directory structure, and restart Ingres. No files need to be recovered.

If you fill this file system, Ingres will usually recover automatically as the query fails and the offending work file is removed.

For more information about temporary files and sorting, see the Database Administrator Guide.