Обсуждение: Moving child tables to partitions?

Поиск
Список
Период
Сортировка

Moving child tables to partitions?

От
Wells Oliver
Дата:
Is this a possible thing? I'd like to consolidate some older child/parent style relationships into the newer partition style.

--

Re: Moving child tables to partitions?

От
Keith Fiske
Дата:


On Tue, Jan 7, 2020 at 1:54 PM Wells Oliver <wells.oliver@gmail.com> wrote:
Is this a possible thing? I'd like to consolidate some older child/parent style relationships into the newer partition style.

--

Yes, this is certainly possible. Whether it's easy or complex really depends on your original partitioning setup, though. I've got an initial draft up for doing this sort of migration when using pg_partman. While some of the steps use things specific to pg_partman, the overall process should be the same for any migration. I'll be including the finalized doc in my next release.

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