How do I permanently delete unapproved posts?

[ChopperCharles]

I have a huge forum, and my database size keeps increasing. I need to prune all unapproved posts. I've had a spam problem lately, and there are thousands of posts that are now unapproved, but still in the database. (aka, soft deleted). I wan to permanently delete these posts.

In fact, when I mark someone as a spammer, I want any and all posts permanently deleted. I don't want them to be soft deleted.

Also.... are there any other techniques I can use to minimize my database size?

Thanks.

Charles.