Hello All,
In postgresql, Is it possible to partition an existing nonpartitioned table having data already residing in it and indexes and constraints defined in it, without the need of manually moving the data around, to make it faster? Similarly merging multiple partitions to one partition or splitting a single partition into multiple partitions?
Appreciate any reference doc or sample syntax for the same.
Thanks and Regards
Veem