On Fri, Apr 22, 2022 at 11:28 AM Loles <lolesft(at)gmail(dot)com> 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