Chris Hoover <revoohc@xxxxxxxxx> 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
