Re: Partitioning without downtime

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Fri, Apr 22, 2022 at 11:28 AM Loles <lolesft@xxxxxxxxx> wrote:
Hi!

Is there a way to partition a table in production without downtime? Or extension that allows it.

Thanks!

Zero downtime (or without a table lock at some point) is not possible with native partitioning since you cannot convert an existing table into a natively partitioned table. However, it is possible to do it with very little downtime if the circumstances allow. I've laid out a method of doing this with pg_partman here - https://github.com/pgpartman/pg_partman/blob/master/doc/pg_partman_howto_native.md

--
Keith Fiske
Senior Database Engineer
Crunchy Data - http://crunchydata.com

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux