Re: Partitioning an existing table - pg10.6

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: legrand legrand <legrand_legrand(at)hotmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Partitioning an existing table - pg10.6
Date: 2019-07-05 20:55:04
Message-ID: CAHOFxGrtRWsXBBNadRZH2NGBwEu79L7m=p5kjYnEes0CgSd0WQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

https://www.depesz.com/2019/03/19/migrating-simple-table-to-partitioned-how/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message PegoraroF10 2019-07-05 20:55:35 Re: Converting to identity columns with domains on PK columns
Previous Message PegoraroF10 2019-07-05 20:49:57 Re: Converting to identity columns with domains on PK columns