Yes. We are using partitioned tables for all data that are loaded daily.

hi,

you are right. Old data will be less important at some point of time. An archive will be necessary for historic data. But i would be nice to have it...

Hi,

good question. The short answer is: We know our data will grow. We want to do our current tasks in the future, so we want 10x performance and capacity. It...

Thank you for your helpful suggestions. I understand that a san like storageworks could be a solution. I'm not a SAN expert, but I doubt that such a system would...

ok, the disks will have more capacity, but speed probably wont be enough. All queries will take twice the time for twice the data. Everybody says the number of drives...

Hello,

thank you for your ideas.

A few additional questions: For better IO/s performance we think about using more drives with 1GB (or less). So we get 11TB in a RAID5. This...