title: Table partitioning in PostgreSQL 11 with automatic partition creation?
body: <p>I need to maintain audit table and since the number of changes are going to be huge, I need an efficient way of dealing with the problem. The solution which I have thought is to record only the changed column in the audit table and partition it on the <code>createdon</code> column quarterly or half-yearly. </p>
  
  <p>I wanted to know if there is anything like 'interval partition' of oracle? If not then how can I achieve it?</p>
  
  <p><strong>I want that every 6 months a new partition is created automatically as the row is inserted.</strong></p>
  
  <p>I am using postgres 11 as my db.</p>