How can we create partitions on the existing table which has not defined with the portion key when it is created?

I have one large table and it has 1B+ records and 600GB in size.

  1. Are there any new approaches to create a partition on the existing table?


  2. Should we create a new table and copy data from old to new one?

  • 1
    The only option you have is 2. If you really need partitioning, I would strongly recommend to upgrade to Postgres 12. There were many substantial improvements to native partitioning since v10.
    – user1822
    Apr 15, 2020 at 5:34
  • Thanks. Currently we have a server with v9.6 and upgrading to v10.7.
    – Rj_N
    Apr 15, 2020 at 9:23
  • 1
    Then you should be upgrading straight to 12.
    – user1822
    Apr 15, 2020 at 9:33
  • This cluster is service in ars rds and has only the option is to go 10x as of now. I think we can do it after that.
    – Rj_N
    Apr 15, 2020 at 16:46


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.