On Tue, 2004-03-02 at 18:24, Anjan Dave wrote: > Can you describe the vendors/components of a "cheap SAN setup?"
heh.. Excellent point. My point was that you could get away with a smaller setup (number of disks) if it doesn't have to deal with reads and writes are not time dependent than you will if you attempt to pull 500MB/sec off the disks. If it is foreseeable that the database can be held in Ram, that it is much easier and cheaper way to get high IO than with physical disks. ---------------------------(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