title: How to handle foreign key while partitioning
body: <p>I am working on fleet management. I am having large amount of writes on a location table with following columns</p>
  
  <ol>
  <li>date     </li>
  <li>time</li>
  <li>vehicle no.</li>
  <li>long</li>
  <li>latitude</li>
  <li>speed</li>
  <li>userid (which is foreign key...)</li>
  </ol>
  
  <p>Here this table is going to have write operation every 3 sec. Hence there will be millions of record in it.
  So to retrieve faster data I AM PLANNING Partition.
  Now my question:-</p>
  
  <ol>
  <li>How to handle foreign key? I heard that partition does not support foreign key</li>
  <li>Which column should be used for partition.</li>
  <li>is it necessary to have unique key as a partition column. </li>
  </ol>
  
  <p><em>There will be trillions of record</em></p>
  
  <p>@rc-Thanks man..what abt the performance ...see i am inserting data after every 3 sec so i have to run a check procedure every time i insert the data...so what about the performance???</p>
  
  <p>2>I would like to go partition column as vehicle no.....is there any alternate way... </p>