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@xxxxxxxxxxx> wrote:
Greetings,
* rammohan ganapavarapu (rammohanganap@xxxxxxxxx) 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
