title: What is a good size (# of rows) to partition a table to really benefit?
body: <p>I.E. if we have got a table with 4 million rows.</p>
  
  <p>Which has got a <code>STATUS</code> field that can assume the following value: <code>TO_WORK</code>, <code>BLOCKED</code> or <code>WORKED_CORRECTLY</code>.</p>
  
  <p>Would you partition on a field which will change just one time (most of times from to_work to worked_correctly)? How many partitions would you create?</p>