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
databases
|postgresql
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