Chris Hoover <revoohc@gmail.com> writes:
> The problem I am having is how can you safely move records between
> main_table_live and one of the other partition tables?
My advice is "don't do that". Partition just based on the year.
You can exploit your knowledge about status distribution by creating
suitable indexes.
> Also, is there a way to make foreign keys work with the partitioned table
No, not at present, which is another reason you don't want records
moving around.
regards, tom lane