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 <srkrishna@xxxxxxxxxx> wrote: > >> 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 >> this and the best practices around it? > > In this version only inheritance is possible. From my experience avoid using > triggers for insert and let the application (if possible) directly write to the > right table. > > > >
