Post reply

Table partitioning : H/w requirement

  • November 7, 2008 at 6:12 am

    #201282

    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

    #895474

    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.

  • November 10, 2008 at 10:25 am

    #896416

    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