Re: Partitioning an existing table - pg10.6 - Mailing list pgsql-general

From Michael Lewis
Subject Re: Partitioning an existing table - pg10.6
Date
Msg-id CAHOFxGrtRWsXBBNadRZH2NGBwEu79L7m=p5kjYnEes0CgSd0WQ@mail.gmail.com
Whole thread Raw
In response to Re: Partitioning an existing table - pg10.6  (legrand legrand <legrand_legrand@hotmail.com>)
List pgsql-general
I have not personally used this, but the write-up seems solid to minimize downtime to help you to shift data gradually. Be sure you understand the limitations of partitioning, particularly when you are still on 10x not yet on v11 where updates will shift a row to a new partition if the partition key is updated.

pgsql-general by date:

Previous
From: PegoraroF10
Date:
Subject: Re: Converting to identity columns with domains on PK columns
Next
From: PegoraroF10
Date:
Subject: Re: Converting to identity columns with domains on PK columns