title: Best storage option for temporary data
body: <p>In the context of an application I am developing I need to store quite a good amount of data for limited amount of time - think of the scenario in terms of object buckets - for a certain limited amount of time objects are in some buckets then they move to others and others... and so on. There is basically a n to m relation between objects (order of millions) and buckets (thousands to maybe tens of thousands)</p>
  
  <p>It is important for this storage layer to be persistent so that, in case of app / server failure, I can recreate the last state.</p>
  
  <p>What would the best option be for implementing such temporary storage</p>
  
  <ul>
  <li>A relational SGBD - we are currently using PostgreSQL, would it be an
  option? I am mainly concern about its capacity to respond to such a
  usage scenario. Would another SGBD be an option ?</li>
  <li>A NOSQL persistence provider - I am thinking mainly at Redis for the
  impressive write / read speed but other DBs, not necessarily from the
  Key-Value family might also be OK.</li>
  </ul>
  
  <p>Thanks</p>