On Friday 19 March 2004 08:10, Anton Nikiforov wrote:
>
> I do not exactly know how to deal wth such a huge amount of data. The disk
> subsytem is the must and i do undrstand this. SMP architecture is the must
> also. I was asking is there any way that data will migrate from fast disk
> subsystem to slower but relyible automaticaly. Like in Nivell Netware (i
> used to work with it 7-8 years ago) you could ask the system if the file is
> untached for a month - then move it from one disk to magnetic-optical or
> tape but if this file is requested OS could move it back to the operational
> volume.
Won't work for a database - it would have to sit there waiting while someone
went to the vault, got a tape out and restored a few GB of data.
You could separate out old data, say monthly into archive tables and then
backup/drop those.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
