Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] Partitions - Mailing list pgsql-admin

From rammohan ganapavarapu
Subject Re: [ADMIN] Partitions
Date
Msg-id CALm_VjggF63ktyuMi2_3jr4r95a+6kRRPsRH6aruXeUGDJo44w@mail.gmail.com
Whole thread Raw
In response to Re: [ADMIN] Partitions  (Stephen Frost <sfrost@snowman.net>)
Responses Re: [ADMIN] Partitions  (Stephen Frost <sfrost@snowman.net>)
List pgsql-admin
Tree view
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 by date:

Previous
From: Stephen Frost
Date:
Subject: Re: [ADMIN] Partitions
Next
From: Stephen Frost
Date:
Subject: Re: [ADMIN] Partitions