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

From Stephen Frost
Subject Re: [ADMIN] Partitions
Date
Msg-id 20171110001857.GV4628@tamriel.snowman.net
Whole thread Raw
In response to [ADMIN] Partitions  (rammohan ganapavarapu <rammohanganap@gmail.com>)
Responses Re: [ADMIN] Partitions  (rammohan ganapavarapu <rammohanganap@gmail.com>)
List pgsql-admin
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: John Scalia
Date:
Subject: Re: [ADMIN] Partitions
Next
From: rammohan ganapavarapu
Date:
Subject: Re: [ADMIN] Partitions