Is it possible to have a database spread across two data files? So if it fills up filesystem1 then we could add a second filesystem and allow it to grow onto this second filesystem?
If you're using Linux there is a tool called the Linux Volume Manager (LVM) which does this. You can change volume sizes dynamically, add new disks etc.
I think all modern operating-systems offer something similar.
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
