title: Performance: SoftDelete vs Move entries
body: <p>I have a table in a PostreSQL database that holds advertisements. Every day, around 100k new advertisements are added and another 40k expire.</p>
  
  <p>Which approach is more suitable:</p>
  
  <ul>
  <li>having a disable flag but keeping them in the main database (index structure will also be altered)</li>
  <li>having a disabled flag and moving them after a period of time to a storage database where we can analyse the data</li>
  </ul>