Re: [ADMIN] Partitions

Поиск
Список
Период
Сортировка
От rammohan ganapavarapu
Тема Re: [ADMIN] Partitions
Дата
Msg-id CALm_VjggF63ktyuMi2_3jr4r95a+6kRRPsRH6aruXeUGDJo44w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [ADMIN] Partitions  (Stephen Frost <sfrost@snowman.net>)
Ответы Re: [ADMIN] Partitions  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-admin
I saw pg_parman but it's third party extension right, i am trying to see if I can use native plugin or extension to the job.

Thanks for your suggestion, i will consider it.
Ram

On Nov 9, 2017 4:18 PM, "Stephen Frost" <sfrost@snowman.net> wrote:
Greetings,

* rammohan ganapavarapu (rammohanganap@gmail.com) wrote:
> I have a requirement to create monthly partitions in my db, i am trying to
> understand what is the best way to do it, i know i can run a cron job to
> check if partition exist and create if not at the starting of month. Any
> suggestions?

I'd suggest you take a look at pg_partman.

Thanks!

Stephen

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

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: [ADMIN] Partitions
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: [ADMIN] Partitions