Optimal size for Database partitions

Posted by Adrian Mouat on Stack Overflow See other posts from Stack Overflow or by Adrian Mouat
Published on 2010-05-21T10:34:15Z Indexed on 2010/05/21 11:10 UTC
Read the original article Hit count: 518

Filed under:
|

Hi all,

I am creating a very simple, very large Postgresql database. The database will have around 10 billion rows, which means I am looking at partitioning it into several tables. However, I can't find any information on how many partitions we should break it into.

I don't know what type of queries to expect as of yet, so it won't be possible to come up with a perfect partitioning scheme, but are there any rules of thumb for partition size?

Cheers,

Adrian.

© Stack Overflow or respective owner

Related posts about databases

Related posts about postgresql