Database Table Partitioning

[url]http://en.wikipedia.org/wiki/Partition_(database)[/url][quote]常见的为 table 做 partitioning 的策略有：
[b]Range partitioning [/b]
Selects a partition by determining if the partitioning key is inside a certain range. An example could be a partition for all rows where the column zipcode has a value between 70000 and 79999.
[b]List partitioning [/b]
A partition is assigned a list of values. If the partitioning key has one of these values, the partition is chosen. For example all rows where the column Country is either Iceland, Norway, Sweden, Finland or Denmark could build a partition for the Nordic countries.
[b]Hash partitioning [/b]
The value of a hash function determines membership in a partition. Assuming there are four partitions, the hash function could return a value from 0 to 3.[/quote]

[b]postgresql：[/b]
postgresql支持 Range 和 List 两种方式的 partitioning：
[url]http://www.postgresql.org/docs/9.1/static/ddl-partitioning.html[/url][quote]The following forms of partitioning can be implemented in PostgreSQL:
Range Partitioning
The table is partitioned into "ranges" defined by a key column or set of columns, with no overlap between the ranges of values assigned to different partitions. For example one might partition by date ranges, or by ranges of identifiers for particular business objects.
List Partitioning
The table is partitioned by explicitly listing which key values appear in each partition.[/quote]