node revisions

The node_revisions table in my D6 database is too huge (2.6gb). I don't use node revisions and have turn off node revision per content type. This has resulted to shouting my website down because the database is over its allocated size. Below is the email I just received. I tried deleting old notes using the below query but 0 record deleted

DELETE FROM {node_revisions} nr WHERE nr.vid NOT IN (SELECT n.vid FROM (node) n)');

While the more expansive workflow features that were proposed did not make it in time for code freeze, we still have an opportunity during the current "code slush" period to make a few key alterations to the underlying Drupal database. This will enable further development in Contrib of comprehensive workflow and content moderation modules, with an eye towards D8. However, time is running out. After October 15, all hope is lost.

The upcoming Drupal 7 update brings with it a great opportunity to provide better support in Core for advanced workflows with content moderation, but the code freeze is fast approaching and this opportunity may pass us by. I encourage all developers to check out Support Revisions in Different States in the Drupal issue queue and lend a hand.

Why you should care?

As for most of our sites we want to turn revisions on for all content types, a module (or D7 core patch) to do this from somewhere with a single switch (or checkboxes for all content types in one place) would be nice.

Questions:
* Is there already a module that does this, hiding from my searches?
* Should other per-content-type workflow settings also be centralized?
* Where should centralized settings like this live in the administration menu?

I'm pushing for Core to support having different revisions of a node in different defined states. This would finally allow nodes to be moderated effectively and would provide a greatly improved foundation for modules like Workflow and Rules to tap into. Please take a look at the feature request and join in the discussion:

http://drupal.org/node/218755

Workflow only keep track of current node revision in the arbitrary workflow stage(s), what do I have to do if I want workflow to keep track of the node revision? For example, I create 3 stages as follow draft, review, publish. I have a Node which have 3 revisions. The first revision is in draft stage, and second revision in review stage, and third revision is in publish stage.