Re: Partitions

From: rammohan ganapavarapu <rammohanganap(at)gmail(dot)com>
To: Stephen Frost <sfrost(at)snowman(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Partitions
Date: 2017-11-10 01:37:40
Message-ID: CALm_VjggF63ktyuMi2_3jr4r95a+6kRRPsRH6aruXeUGDJo44w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)snowman(dot)net> wrote:

> Greetings,
>
> * rammohan ganapavarapu (rammohanganap(at)gmail(dot)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
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Stephen Frost 2017-11-10 01:50:07 Re: Partitions
Previous Message Stephen Frost 2017-11-10 00:18:57 Re: Partitions