title: Can Spring-JPA work with Postgres partitioning?
body: <p>We have a Spring Boot project that uses Spring-JPA for data access. We have a couple of tables where we create/update rows once (or a few times, all within minutes). We don't update rows that are older than a day. These tables (like audit table) can get very large and we want to use Postgres' table partitioning features to help break up the data by month. So the main table always has this calendar month's data but if the query requires retrieval from previous months it would somehow read it from other partitions.</p>
  
  <p>Two questions: </p>
  
  <p>1) Is this a good idea for archiving older data but still leave it query-able? 
  2) Does Spring-JPA work with partitioned tables? Or do we have to figure out how to break up the query and do native queries and concatenate the restult set? </p>
  
  <p>Thanks.</p>