Re: concurrent re-partitioning of declarative partitioned tables

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: concurrent re-partitioning of declarative partitioned tables
Дата
Msg-id CAHOFxGorjGyWXrMUhCMQaeVMwR+p0QDS+My31+HcyGNTnuJmvA@mail.gmail.com
обсуждение исходный текст
Ответ на concurrent re-partitioning of declarative partitioned tables  (Nick Cleaton <nick@cleaton.net>)
Ответы Re: concurrent re-partitioning of declarative partitioned tables
Список pgsql-general
Дерево обсуждения
You can not have overlapping partitions that are both attached. Why do you want to merge partitions that you are "done with" instead of just leaving them partitioned by day?

Why are you partitioning at all? Are you confident that you need partitions for performance & that the trade-offs are worth the cost, or are you needing to detach/drop old data quickly to adhere to a retention policy?

pg_partman extension may be worth looking into. I have only dabbled with it, so I can't offer much comment.

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: error on connecting port 5432
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: concurrent re-partitioning of declarative partitioned tables