Mariposa was an interesting cost-based distributed query engine basedupon PostgreSQL.
Perhaps that study may prove valuable insights.
http://epoch.cs.berkeley.edu:8000/mariposa/