title: How to delete lots of rows from PostgreSQL?
body: <p>We have a table with lots of rows (100m) hosted in AWS RDS.</p>
  <ol>
  <li>How can we efficiently delete 50% of rows if the table has constant read, write and update queries?</li>
  <li>How to delete 1% of data on daily basis?</li>
  </ol>
  <p>Table structure:</p>
  <ul>
  <li>created_at</li>
  <li>user_id</li>
  <li>other data</li>
  </ul>
  <p>We tried deleting day by day, but then autovacuum started and queue depth grew.</p>