title: SQL or noSQL database for large data imports and fast lookups?
body: <p>I want to:</p>
  
  <ul>
  <li>read a few 100 GB from csv files > convert some columns to a specific format > save to DB. This should be run a few times a day.</li>
  <li>query the DB with 4 parameters and order the results by an attribute (eg PRICE ASC), then pick the TOP entry.</li>
  </ul>
  
  <p>Postgres performs fine in general, means: 1-2 GB / min (using java).
  Also selects are quite fine when I put an <code>index</code> on my 4 paramters that are used for the select.</p>
  
  <p>Still, it will take a "long" time when importing a few hundred GBs.</p>
  
  <p>Question: could it be worthwhile to try the same using a <code>noSQL</code> engine like <code>apache Cassandra</code>?
  I mean:</p>
  
  <ul>
  <li>could a noSQL DB be faster for mass inserts of data</li>
  <li>can I retrieve a row from noSQL based on a few parameters as quick as in an indexed postgres db?</li>
  </ul>