Re: Moving child tables to partitions?

Поиск
Список
Период
Сортировка
От Keith Fiske
Тема Re: Moving child tables to partitions?
Дата
Msg-id CAODZiv60=GLEH+z+zvz7HNrAKLaVkex0KV1yqT74VKe=wvoMiQ@mail.gmail.com
обсуждение исходный текст
Ответ на Moving child tables to partitions?  (Wells Oliver <wells.oliver@gmail.com>)
Список pgsql-admin


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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Jerry Sievers
Дата:
Сообщение: Re: Alter command getting stuck on a table
Следующее
От: Shrikant Bhende
Дата:
Сообщение: Re: Alter command getting stuck on a table