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
Hi There,
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