Re: Convert Existing Table to a Partition Table in PG10

2018-06-23 Thread Ravi Krishna
Does this help: http://ashutoshpg.blogspot.com/2018/06/upgrade-your-partitioning-from.html

Convert Existing Table to a Partition Table in PG10

2018-06-23 Thread Clifford Snow
I have a large table that needs converting to the native partitioning available in PG10. I'm looking for a strategy to safely move the data. I was considering a CREATE TABLE new LIKE old PARTITION ON(my_timestamp). But I figured postgres would execute that before I could create the child tables. D