title: Column-Oriented Databases for Financial Data Analysis
body: <p>I currently have a lot of financial data I would like to analyze and compute on. I have built a data system that reads from flat-files and does some decently intelligent caching to maintain the performance I want. But I am starting to have to much data for this system...</p>
  
  <p>I was currently thinking about using POSTGres and having a schema sort of like this:</p>
  
  <pre><code>Table: Things
  Fields: T_id, Row, Sub-Row, Column, Resolution, Readable-Name, Meta
  
  Table: Data
  Fields: d_id, T_id, timestamp, value
  </code></pre>
  
  <p>I was wondering if POSTGres would be performant with the above schema if my data table has billions of rows.</p>
  
  <p>Another Idea I had was using a column-oriented database, but I can't seem to find any good open-source ones to get started with. Cassandra is really not made for this situation as I will be reading much much more than writing.</p>