You can also use extensions like pg_partman or pg_pathman. The last one allows
to partition tables smoothly on live environments.
> On 20. Nov 2019, at 11:49, Ravi Krishna wrote:
>
>> In our production, we use postgres 9.5 with streaming replication
>> using repmgr, there is a large table of 1
>In our production, we use postgres 9.5 with streaming replication
>using repmgr, there is a large table of 140GB size which receives
>lots of inserts,
>Is it possible to partition this table in this version of postgres?
>and if so, please, can someone let me know the best way to accomplish
>thi