Re: concurrent re-partitioning of declarative partitioned tables

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: concurrent re-partitioning of declarative partitioned tables
Дата
Msg-id CAKFQuwag2WvGOJkOMkxTrZTB_FSVT_U4-+aQKGszHzmX3U5SoA@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
Дерево обсуждения
On Mon, Nov 30, 2020 at 8:36 AM Nick Cleaton <nick@cleaton.net> wrote:
I want to set up a large table on postgresql 12.4, using declarative partitioning to partition by record creation date. I'd like to have recent records in small partitions but old records in a few larger partitions, so I want merges. The merges should be concurrent, in the sense that they lock out readers or writers only for very short intervals if at all.

Once a date has passed is the table for that date effectively read-only?

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

Предыдущее
От: Michael Lewis
Дата:
Сообщение: Re: concurrent re-partitioning of declarative partitioned tables
Следующее
От: Nick Cleaton
Дата:
Сообщение: Re: concurrent re-partitioning of declarative partitioned tables