title: PostgreSQL: Automating deletion of old partitions
body: <p>I am using Imperial Wicket's fine automated partitioning function for PostgreSQL <a href="http://imperialwicket.com/postgresql-automating-monthly-table-partitions/" rel="nofollow noreferrer">http://imperialwicket.com/postgresql-automating-monthly-table-partitions/</a>) to create weekly partitions to store a large amount of data. The database grows by ~100GB per week, so some frequent attention is needed to ensure the server does not run out of disk space.</p>
  
  <p>I have searched SO but cannot find any solutions to automatically drop tables based on disk space thresholds or time periods. Are there any native PostgreSQL solutions or developed functions to automate dropping old partitions, or is this a roll-my-own solution kind of problem?</p>