Re: Partitions

> On Nov 9, 2017, at 18:41, John Scalia <jayknowsunix(at)gmail(dot)com> wrote:
>
> Set up a trigger on insert to check for the existence of the partition table, then it could do the insert there or create the table if needed and insert. Look online. I know I’ve seen examples of this.

Be careful here, these solutions generally take a massive performance hit. The best method is the native pg_partman function. It includes a built-in scheduler so that you don’t need to rely on an external tool like cron.

> —
> Jay
>
> Sent from my iPad
>
>> On Nov 9, 2017, at 6:28 PM, rammohan ganapavarapu <rammohanganap(at)gmail(dot)com> wrote:
>>
>> Hi,
>>
>> 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?
>>
>> Thanks,
>> Ram
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin