If you haven't seen it yet, check this presentation about partitioning with PostgreSQL:

http://images.omniti.net/omniti.com/talks/partitions-public....