title: Database choice for large data volume?
body: <p>I'm about to start a new project which should have a rather large database. </p>
  
  <p>The number of tables will not be large (&lt;15), majority of data (99%) will be contained in one big table, which is almost insert/read only (no updates).</p>
  
  <p>The estimated amount of data in that one table is going to grow at <strong>500.000 records a day</strong>, and we should keep at least <strong>1 year</strong> of them to be able to do various reports.</p>
  
  <p>There needs to be (read-only) <strong>replicated</strong> database as a backup/failover, and maybe for offloading reports in peak time.</p>
  
  <p>I don't have first hand experience with that large databases, so I'm asking the ones that have which DB is the best choice in this situation. I know that <strong>Oracle</strong> is the safe bet, but am more interested if anyone have experience with <strong>Postgresql</strong> or <strong>Mysql</strong> with similar setup.</p>