> Another solution is to partition the data, but that complicates the
> architecture and lengthens many code paths.

Why that? If I am not mistaken, EnterpriseDB or Green Plum go for data
partitioning... Ok, those are DWH systems, but Google and Amazon go for
data partitioning as well.

Roman