November 7, 2008 at 6:12 am
Hi
I request you to please let me know the configuration of hardware required for efficiently partitioning a table which would store approximately 1.3 billion records.
Regards
Pojha
November 7, 2008 at 6:18 am
There isn't a set hardware configuration.
How are you partitioning? What is the purpose? There isn't a way to answer a general question like this because it depends on how the system will be used. A single table can handle a billion rows. If you have querying issues, you can look to partition and separate different partitions to different disks, but really partitioning works well when the majority of queries will only hit a few partitions and not the entire data set.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
November 10, 2008 at 10:25 am
I agree with Steve.
We have several billion+ row tables, and they're actually stored on the same physical drive. If you currently store your 1.3 billion row table, then you can use your existing hardware to hold the partitioned version, too.
If you need additional information on partitioning, I have an article here: http://sqlfool.com/2008/11/partitioning-101/[/url]
I also have a partitioning example, including code to swap out partitions, here: http://sqlfool.com/2008/11/102/[/url]
HTH!
Regards,
Michelle Ufford
SQLFool.com - Adventures in SQL Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply