Good blog entry by Dr. Tim Tennent, President of Asbury Theological Seminary, on the Psalms:

http://timothytennent.com/2012/11/01/imprecatory-psalms-are-all-the-psalms-suitable-for-christian-use/