I do make use of partitioning despite the restrictions, there's a link on my blog to a a large document i produced for a presentation I did which talked about partitioning data in general - not just native partitioning. There are maybe not so obvious reasons for partitioning which can be worth the effort - I just find the inability to get unique constraints on a partitioned table where the partitioning key is actually a foreign key a bit of a pain.